Does SQL Server Browser Service need to be a clustered resource for a Clustered SQL 2005 S

I have a SQL Server 2005 CLuster; Does SQL SERVER BROWSER service need to
be a clustered resource. It wasn't set up that way, but I was just
wondering.
ThanksI just found out that it is not supported as a clustered resource.
"Steven" <skong@.ap.org> wrote in message
news:uV9w10DHGHA.1728@.TK2MSFTNGP09.phx.gbl...
>I have a SQL Server 2005 CLuster; Does SQL SERVER BROWSER service need to
>be a clustered resource. It wasn't set up that way, but I was just
>wondering.
> Thanks
>

Does SQL Server Browser Service need to be a clustered resource for a Clustered SQL 2005 S

I have a SQL Server 2005 CLuster; Does SQL SERVER BROWSER service need to
be a clustered resource. It wasn't set up that way, but I was just
wondering.
Thanks
I just found out that it is not supported as a clustered resource.
"Steven" <skong@.ap.org> wrote in message
news:uV9w10DHGHA.1728@.TK2MSFTNGP09.phx.gbl...
>I have a SQL Server 2005 CLuster; Does SQL SERVER BROWSER service need to
>be a clustered resource. It wasn't set up that way, but I was just
>wondering.
> Thanks
>

Does SQL Server Browser Service need to be a clustered resource for a Clustered SQL 20

I have a SQL Server 2005 CLuster; Does SQL SERVER BROWSER service need to
be a clustered resource. It wasn't set up that way, but I was just
wondering.
ThanksI just found out that it is not supported as a clustered resource.
"Steven" <skong@.ap.org> wrote in message
news:uV9w10DHGHA.1728@.TK2MSFTNGP09.phx.gbl...
>I have a SQL Server 2005 CLuster; Does SQL SERVER BROWSER service need to
>be a clustered resource. It wasn't set up that way, but I was just
>wondering.
> Thanks
>sql

Does SQL Server 2005 Workgroup edition support scheduling report?

Hello,

In the feature list of workgroup edition, it says Reporting services is included.

After I finally installed it, the reporting service is there as expected. But what is missing is the subscription tab in the report manager. Then I went to Reporting service Configuration Manager, and I saw emailing setting is there (which indicates scheudling and emailling is supported), then I setup valid sender email address and SMTP server, but the Subscription tab is still missing.

Could anyone (from microsoft) tell me whether emailling and scheduling are supported in Workgroup edition or not?

Thanks a lot!

Details about available RS features per edition can be found here: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

Subscriptions are available for Standard Edition and Enterprise Editions. Data-driven subscriptions are Enterprise Edition only.

-- Robert

sql

Does sql server 2000 require a reboot?

Hi All,
I'm installing 2k developer, and the service pack 3a. Do either of these
require a reboot?
Thanks in advance
RyanSee the SP3a readme, section 3.4 (but I always reboot the computer after
installing a service pack. You need to take down SQL Server anyway if you
install an SP, so what's another 2 minutes for a server reboot?):
3.4 Stop Services and Applications Before Running SP3a Setup
The following information applies to all components.
You can apply SP3a without shutting down services. If you do not shut down
services, you are prompted to reboot the computer when Setup is complete.
Without rebooting, the following services fail to start:
a.. Microsoft Distributed Transaction Coordinator (MS DTC) and the
Microsoft Search and MSSQLServerOLAPService services.
b.. The MSSQLServer and SQLServerAgent services for the instance being
upgraded (for example, MSSQL$NamedInstance).
c.. Microsoft Component Services, Microsoft Message Queuing, and Microsoft
COM Transaction Integrator.
d.. All applications, including Control Panel. (optional)
You can apply SP3a without restarting your computer by stopping these
services and applications before applying the SP3a.
You cannot stop the services in a clustered environment. For more
information, see Section 3.10 Installing on a Failover Cluster.
Jacco Schalkwijk
SQL Server MVP
"Ryan Breakspear" <r.breakspear@.removespamfdsltd.co.uk> wrote in message
news:%23WDWxN0CEHA.688@.tk2msftngp13.phx.gbl...
> Hi All,
> I'm installing 2k developer, and the service pack 3a. Do either of these
> require a reboot?
> Thanks in advance
> Ryan
>|||Sorry, maybe I didn't make it clear. I'm installing SQL Server 2000
developer as well as the 3a service pack. I've since read that the service
pack requires a restart of the SQL Server services (which I'm not worried
about). I will do a re-boot at the end of the day, but the server is also a
file server, so don't want to do a reboot now after installing MS SQL Server
2000. Is this required?
Thanks
Ryan
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:esUq4m0CEHA.3132@.TK2MSFTNGP11.phx.gbl...
> See the SP3a readme, section 3.4 (but I always reboot the computer after
> installing a service pack. You need to take down SQL Server anyway if you
> install an SP, so what's another 2 minutes for a server reboot?):
> 3.4 Stop Services and Applications Before Running SP3a Setup
> The following information applies to all components.
> You can apply SP3a without shutting down services. If you do not shut down
> services, you are prompted to reboot the computer when Setup is complete.
> Without rebooting, the following services fail to start:
> a.. Microsoft Distributed Transaction Coordinator (MS DTC) and the
> Microsoft Search and MSSQLServerOLAPService services.
>
> b.. The MSSQLServer and SQLServerAgent services for the instance being
> upgraded (for example, MSSQL$NamedInstance).
>
> c.. Microsoft Component Services, Microsoft Message Queuing, and
Microsoft
> COM Transaction Integrator.
>
> d.. All applications, including Control Panel. (optional)
> You can apply SP3a without restarting your computer by stopping these
> services and applications before applying the SP3a.
> You cannot stop the services in a clustered environment. For more
> information, see Section 3.10 Installing on a Failover Cluster.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Ryan Breakspear" <r.breakspear@.removespamfdsltd.co.uk> wrote in message
> news:%23WDWxN0CEHA.688@.tk2msftngp13.phx.gbl...
these
>|||You have to reboot your server after installing SQL Server 2000. You can
install it now though, and only do the reboot at the end of the day, before
you install the service pack.
Jacco Schalkwijk
SQL Server MVP
"Ryan Breakspear" <r.breakspear@.removespamfdsltd.co.uk> wrote in message
news:%23DlS7t0CEHA.1588@.tk2msftngp13.phx.gbl...
> Sorry, maybe I didn't make it clear. I'm installing SQL Server 2000
> developer as well as the 3a service pack. I've since read that the
service
> pack requires a restart of the SQL Server services (which I'm not worried
> about). I will do a re-boot at the end of the day, but the server is also
a
> file server, so don't want to do a reboot now after installing MS SQL
Server
> 2000. Is this required?
> Thanks
> Ryan
> "Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
> news:esUq4m0CEHA.3132@.TK2MSFTNGP11.phx.gbl...
you
down
complete.
> Microsoft
> these
>|||OK, thanks
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:ueIl8y0CEHA.464@.TK2MSFTNGP11.phx.gbl...
> You have to reboot your server after installing SQL Server 2000. You can
> install it now though, and only do the reboot at the end of the day,
before
> you install the service pack.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Ryan Breakspear" <r.breakspear@.removespamfdsltd.co.uk> wrote in message
> news:%23DlS7t0CEHA.1588@.tk2msftngp13.phx.gbl...
> service
worried
also
> a
> Server
after
> you
> down
> complete.
being
message
>

Does SQL 7.0 SP4 include security patch?

Does anyone know if the SQL Server 7.0 service pack 4 that you download from
Microsoft today include the 327068 Security Patch? Or do you have to
download and install it seperately?Hi Mike,
Check this article - http://support.microsoft.com/kb/327068. It says
specifically that:
Before you apply the patch, you must install SQL Server 7.0 Service Pack
4 (SP4)
Jonathan
Mike wrote:
> Does anyone know if the SQL Server 7.0 service pack 4 that you download fr
om
> Microsoft today include the 327068 Security Patch? Or do you have to
> download and install it seperately?
>

Does Service Pack 2 affect Client Tools?

Hello,

Does Service Pack 2 affect client tools? In other words, if you have a client machine with just the tools installed (management studio, BIDS, etc) do I need to run the SP2 package on this client as well?

Regards, Jeroen

YES. Always update ALL clients to the same SP as the servers.

|||thnx Tom...sql

Does service broker use MSDTC? What is sb's underlying technology

We are using MSDTC in our stored procedures. We use BEGIN DISTRIBUTED TRAN
in our code. We are passing data from one server.database to another
server.database. These servers are on windows 2003 sp2 and using sql server
2005 sp2 plus clustering. We have run into a couple of issues where the
MSDTC acts flaky. Log files and error messages from msdtc queries is
extremely poor. The only solutions that we have found in this situation is
to failover the cluster and/or restart the sql server services. I am
pondering if we should consider editing our code. I know that the service
broker is a new feature. We are not currently using it. In passing data
around from server to server what is the underlying technology? Does it use
MSDTC. If so, I think a re-write of our code to piggy back ontop of service
broker is not going to help us. Can someone elaborate on cross server query
messages using service broker?
Thanks,
TimNo, SB does not use DTC. As far as I understand, the re-try of message sending is built-in to SB
itself, which uses TCP sockets (defined when you create your endpoint). As I understand it, the data
format (the protocol between two SB instances) isn't public, and it is in binary format (no XML or
similar). I suggest you pick up Roger Wolter's book on SB, great reading, with lots of insight...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"timw86" <timw86@.discussions.microsoft.com> wrote in message
news:7508D9D5-A4ED-4993-89B1-4CFE079F0905@.microsoft.com...
> We are using MSDTC in our stored procedures. We use BEGIN DISTRIBUTED TRAN
> in our code. We are passing data from one server.database to another
> server.database. These servers are on windows 2003 sp2 and using sql server
> 2005 sp2 plus clustering. We have run into a couple of issues where the
> MSDTC acts flaky. Log files and error messages from msdtc queries is
> extremely poor. The only solutions that we have found in this situation is
> to failover the cluster and/or restart the sql server services. I am
> pondering if we should consider editing our code. I know that the service
> broker is a new feature. We are not currently using it. In passing data
> around from server to server what is the underlying technology? Does it use
> MSDTC. If so, I think a re-write of our code to piggy back ontop of service
> broker is not going to help us. Can someone elaborate on cross server query
> messages using service broker?
> Thanks,
> Tim

Does service broker use MSDTC? What is sb's underlying technology

We are using MSDTC in our stored procedures. We use BEGIN DISTRIBUTED TRAN
in our code. We are passing data from one server.database to another
server.database. These servers are on windows 2003 sp2 and using sql server
2005 sp2 plus clustering. We have run into a couple of issues where the
MSDTC acts flaky. Log files and error messages from msdtc queries is
extremely poor. The only solutions that we have found in this situation is
to failover the cluster and/or restart the sql server services. I am
pondering if we should consider editing our code. I know that the service
broker is a new feature. We are not currently using it. In passing data
around from server to server what is the underlying technology? Does it use
MSDTC. If so, I think a re-write of our code to piggy back ontop of service
broker is not going to help us. Can someone elaborate on cross server query
messages using service broker?
Thanks,
Tim
No, SB does not use DTC. As far as I understand, the re-try of message sending is built-in to SB
itself, which uses TCP sockets (defined when you create your endpoint). As I understand it, the data
format (the protocol between two SB instances) isn't public, and it is in binary format (no XML or
similar). I suggest you pick up Roger Wolter's book on SB, great reading, with lots of insight...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"timw86" <timw86@.discussions.microsoft.com> wrote in message
news:7508D9D5-A4ED-4993-89B1-4CFE079F0905@.microsoft.com...
> We are using MSDTC in our stored procedures. We use BEGIN DISTRIBUTED TRAN
> in our code. We are passing data from one server.database to another
> server.database. These servers are on windows 2003 sp2 and using sql server
> 2005 sp2 plus clustering. We have run into a couple of issues where the
> MSDTC acts flaky. Log files and error messages from msdtc queries is
> extremely poor. The only solutions that we have found in this situation is
> to failover the cluster and/or restart the sql server services. I am
> pondering if we should consider editing our code. I know that the service
> broker is a new feature. We are not currently using it. In passing data
> around from server to server what is the underlying technology? Does it use
> MSDTC. If so, I think a re-write of our code to piggy back ontop of service
> broker is not going to help us. Can someone elaborate on cross server query
> messages using service broker?
> Thanks,
> Tim

Does service broker use MSDTC? What is sb's underlying technology

We are using MSDTC in our stored procedures. We use BEGIN DISTRIBUTED TRAN
in our code. We are passing data from one server.database to another
server.database. These servers are on windows 2003 sp2 and using sql serve
r
2005 sp2 plus clustering. We have run into a couple of issues where the
MSDTC acts flaky. Log files and error messages from msdtc queries is
extremely poor. The only solutions that we have found in this situation is
to failover the cluster and/or restart the sql server services. I am
pondering if we should consider editing our code. I know that the service
broker is a new feature. We are not currently using it. In passing data
around from server to server what is the underlying technology? Does it use
MSDTC. If so, I think a re-write of our code to piggy back ontop of service
broker is not going to help us. Can someone elaborate on cross server query
messages using service broker?
Thanks,
TimNo, SB does not use DTC. As far as I understand, the re-try of message sendi
ng is built-in to SB
itself, which uses TCP sockets (defined when you create your endpoint). As I
understand it, the data
format (the protocol between two SB instances) isn't public, and it is in bi
nary format (no XML or
similar). I suggest you pick up Roger Wolter's book on SB, great reading, wi
th lots of insight...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"timw86" <timw86@.discussions.microsoft.com> wrote in message
news:7508D9D5-A4ED-4993-89B1-4CFE079F0905@.microsoft.com...
> We are using MSDTC in our stored procedures. We use BEGIN DISTRIBUTED TRA
N
> in our code. We are passing data from one server.database to another
> server.database. These servers are on windows 2003 sp2 and using sql ser
ver
> 2005 sp2 plus clustering. We have run into a couple of issues where the
> MSDTC acts flaky. Log files and error messages from msdtc queries is
> extremely poor. The only solutions that we have found in this situation i
s
> to failover the cluster and/or restart the sql server services. I am
> pondering if we should consider editing our code. I know that the servic
e
> broker is a new feature. We are not currently using it. In passing data
> around from server to server what is the underlying technology? Does it u
se
> MSDTC. If so, I think a re-write of our code to piggy back ontop of servi
ce
> broker is not going to help us. Can someone elaborate on cross server que
ry
> messages using service broker?
> Thanks,
> Tim

does service broker come with sql express?

we're a little confused, we understand that between instances of sql express that a licensed edition would be necessary for service broker to be used but what if there is just one sql express edition/instance in the picture, does service broker come with express and can most of service broker's features be used "intra" (inside) that instance?

SQL Server Service Broker does come with Express. And you do need another (paid) edition involved for messages that pass outside the instance.

From http://msdn2.microsoft.com/en-us/library/ms345154.aspx#sseover_topic10:

SQL Server Express can use Service Broker only in combination with other SQL Server 2005 editions. If SQL Server Express receives a Broker message from another Express instance, and if another SQL Server 2005 edition has not processed the message, then the message is dropped. So the message can originate from an Express instance and end up at one, but it must be routed through a non-Express instance if that is the case. You can check a Message Drop trace event that is accessible from the Profiler or use tracing stored procedures to track this type of occurrence. The error message associated with the dropped message includes verbiage to this effect: "This message has been dropped due to licensing restrictions."

Don

|||thanks, I've read that first sentence before and totally misinterpreted its meaning.

Does reporting service support Chinese?

My report has some chinese. It can be display by IE, but when I export it
as PDF, the chinese words are displayed by "'?" in PDF file.
I don't know how to handle it.I have the same problem.
The Chinese characters show very well in HTML. However, when I export it to
PDF, all of these Chinese characters show as question mark -- ? even I use
Chinese version of Acrobat Reader.
Is it a reporting service bug?
Regards,
AndyZ
"°Ë´óɽÈË" <zhoushaofeng@.hotmail.com> дÈëÓʼþ
news:%23tsMrF1XEHA.2812@.TK2MSFTNGP11.phx.gbl...
> My report has some chinese. It can be display by IE, but when I export it
> as PDF, the chinese words are displayed by "'?" in PDF file.
> I don't know how to handle it.
>|||Update to SP1, it is working fine now.
But I am very sad that when I upgrade to SP1, PDF is OK and E-mail in worng
code(GB2312, it should be UTF-8)
Tony
"Andy Zhang" <A@.A> wrote in message
news:eJPJRw2XEHA.4008@.TK2MSFTNGP09.phx.gbl...
> I have the same problem.
> The Chinese characters show very well in HTML. However, when I export it
to
> PDF, all of these Chinese characters show as question mark -- ? even I use
> Chinese version of Acrobat Reader.
> Is it a reporting service bug?
> Regards,
> AndyZ
> "°Ë´óɽÈË" <zhoushaofeng@.hotmail.com> дÈëÓʼþ
> news:%23tsMrF1XEHA.2812@.TK2MSFTNGP11.phx.gbl...
> > My report has some chinese. It can be display by IE, but when I export
it
> > as PDF, the chinese words are displayed by "'?" in PDF file.
> > I don't know how to handle it.
> >
> >
>|||You will need to use a FontFamily that is localized. The default FontFamily,
Arial, does not support Chinese characters.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"°Ë´óɽÈË" <zhoushaofeng@.hotmail.com> wrote in message
news:%23tsMrF1XEHA.2812@.TK2MSFTNGP11.phx.gbl...
> My report has some chinese. It can be display by IE, but when I export it
> as PDF, the chinese words are displayed by "'?" in PDF file.
> I don't know how to handle it.
>

Does Reporting service for SQL server work with SQL trial version

Does Reporting service for SQL server work with SQL trial version?
Need to know in advance if it provide a function before buying SQL serverit does work with enterprise edition eval
--
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"sabot" <sab0t777@.yahoo.com> wrote in message
news:ffe9912.0312181131.1e6f1f09@.posting.google.com...
> Does Reporting service for SQL server work with SQL trial version?
> Need to know in advance if it provide a function before buying SQL server|||Tried installing Report Service beta2. The setup gave this error
message
"This edition of the Report Server Database is not supported on the
edition of SQL Server 2000 you have chosen. Please choose another SQL
Server that matches the requirements."
What am I doing wrong?
running SQL Server 2000 Eval - 8.00.760 (SP3) on Win2000 AS
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Does MSSQL service account rights

Does the MSSQL Service domain service account have to be a member of the
system administrators role?No - al permisions that it needs are listed in Books OnLine, topic "Setting
up Windows Services Accounts"
(mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\in
stsql.chm::/in_overview_6k1f.htm).
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Rod Bautista" <rod.bautista@.adam-us.com> wrote in message
news:Oq5Hx4KhEHA.1344@.TK2MSFTNGP11.phx.gbl...
> Does the MSSQL Service domain service account have to be a member of the
> system administrators role?
>|||Hi,
See the below link:-
http://support.microsoft.com/defaul...b;en-us;Q283811
Thanks
Hari
MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OyhMAFPhEHA.3612@.TK2MSFTNGP12.phx.gbl...
> No - al permisions that it needs are listed in Books OnLine, topic
"Setting
> up Windows Services Accounts"
>
(mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\in[vbc
ol=seagreen]
> stsql.chm::/in_overview_6k1f.htm).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Rod Bautista" <rod.bautista@.adam-us.com> wrote in message
> news:Oq5Hx4KhEHA.1344@.TK2MSFTNGP11.phx.gbl...
>[/vbcol]|||Yes.
It does not have to be a member of the operating system local
Administrators group, but needs to be part of the sysadmin fixed database
roll.

>On Tue, 17 Aug 2004 16:01:49 -0700, Rod Bautista wrote:

> Does the MSSQL Service domain service account have to be a member of the
> system administrators role?|||Thanks.
To clarify, I understand that the service account does not have to be a
local administrator on the machine, but does it have to be a member of the
sysadmin fixed server role?
I have a SQL Server that runs under a domain account. This SQL Server has
BUILTIN\Administrators removed from the system administrators role. The
domain account used to start the MSSQL service is not a member of the
sysadmin role. Curiously, the SQL Server runs without issue. This tells me
that membership in the sysadmin role is not required. However, if this same
account was used to start the SQL Server AGent, would it then be required to
have membership in the sysadmin role?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OyhMAFPhEHA.3612@.TK2MSFTNGP12.phx.gbl...
> No - al permisions that it needs are listed in Books OnLine, topic
"Setting
> up Windows Services Accounts"
>
(mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\in[vbc
ol=seagreen]
> stsql.chm::/in_overview_6k1f.htm).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Rod Bautista" <rod.bautista@.adam-us.com> wrote in message
> news:Oq5Hx4KhEHA.1344@.TK2MSFTNGP11.phx.gbl...
>[/vbcol]|||Yes. I think someone may have referred you to the following:
How to change the SQL Server or SQL Server Agent Service
account without using SQL Enterprise Manager in SQL Server
2000
http://support.microsoft.com/?id=283811
Check the Miscellaneous steps section.
-Sue
On Fri, 20 Aug 2004 09:14:18 -0700, "Rod Bautista"
<rod.bautista@.adam-us.com> wrote:

>Thanks.
>To clarify, I understand that the service account does not have to be a
>local administrator on the machine, but does it have to be a member of the
>sysadmin fixed server role?
>I have a SQL Server that runs under a domain account. This SQL Server has
>BUILTIN\Administrators removed from the system administrators role. The
>domain account used to start the MSSQL service is not a member of the
>sysadmin role. Curiously, the SQL Server runs without issue. This tells me
>that membership in the sysadmin role is not required. However, if this sam
e
>account was used to start the SQL Server AGent, would it then be required t
o
>have membership in the sysadmin role?
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
>message news:OyhMAFPhEHA.3612@.TK2MSFTNGP12.phx.gbl...
>"Setting
> (mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\i
n
>|||Thanks for the clarification Sue.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:7poji0tj3pk1rv3tqab80aasfsh1kn8h6v@.
4ax.com...
> Yes. I think someone may have referred you to the following:
> How to change the SQL Server or SQL Server Agent Service
> account without using SQL Enterprise Manager in SQL Server
> 2000
> http://support.microsoft.com/?id=283811
> Check the Miscellaneous steps section.
> -Sue
> On Fri, 20 Aug 2004 09:14:18 -0700, "Rod Bautista"
> <rod.bautista@.adam-us.com> wrote:
>
the[vbcol=seagreen]
has[vbcol=seagreen]
me[vbcol=seagreen]
same[vbcol=seagreen]
to[vbcol=seagreen]
in[vbcol=seagreen]
> (mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\i
n
the[vbcol=seagreen]
>

Does MSDE (SP4) support Full Text Research?

How can i install eand run Full text research Service in Windows xp Sp2
hi,
S. Luca wrote:
> How can i install eand run Full text research Service in Windows xp
> Sp2
MSDE does not support (and provide) Full Text engine..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

does microsoft offer new updatable version of MSDTC?

hi all
microsoft offers new updatable version of MSDTC
not by the windows service pack or sql server service pack?
cjpark
---
cjpark's Profile: http://www.msmcse.ms/member.php?userid=543
View this thread: http://www.msmcse.ms/t-1869428251Hi
On Windows 2000 and later, MSDTC is the responsibility of the OS and will be
updated with OS Service Packs.
If you need a hotfix for DTC, call Microsoft PSS in your area.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cjpark" <cjpark.1no03y@.no-mx.msmcse.ms> wrote in message
news:cjpark.1no03y@.no-mx.msmcse.ms...
> hi all
> microsoft offers new updatable version of MSDTC
> not by the windows service pack or sql server service pack?
>
> --
> cjpark
> ---
> cjpark's Profile: http://www.msmcse.ms/member.php?userid=543
> View this thread: http://www.msmcse.ms/t-1869428251
>|||thank you much Mike
cjpark
---
cjpark's Profile: http://www.msmcse.ms/member.php?userid=543
View this thread: http://www.msmcse.ms/t-1869428251

Does IIS need to be installed on the SQL Server machine?

If I have Reporting Service installed on one server and the ReportServer
database on another server, do I need IIS installed on the server that houses
the ReportServer database? I'd rather not have IIS and SQL Server on the
same machine.No you do not. IIS has to be only on the server that has RS installed. RS is
an asp.net application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Munter" <Dave Munter@.discussions.microsoft.com> wrote in message
news:B0E4CDDD-F2B6-42C1-976B-03315BC1AF85@.microsoft.com...
> If I have Reporting Service installed on one server and the ReportServer
> database on another server, do I need IIS installed on the server that
houses
> the ReportServer database? I'd rather not have IIS and SQL Server on the
> same machine.
>

Does creating KPI require cube reprocess?

The Analysis Service help says that after creating a KPI you need to process the cube in order to browse it. However, that's not the behavior I'm seeing - it looks like the KPI becomes available immediately. What behavior should I be expecting here?

The Books Online is being incorrect in this case. You dont need to re-process your cube after creating KPI's.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Does anyone know what this means? Anyone?

AuthzInitializeContextFromSid: Win32 error: 234
get this when trying to send an email subscription or a file-share
subscription. Running the service as a domain account and made the account a
member of the WAA group.I should probably mention that I love the "there is more information in the
log file" message that you can find....you guessed it...in the log file.
"chicagoclone" wrote:
> AuthzInitializeContextFromSid: Win32 error: 234
> get this when trying to send an email subscription or a file-share
> subscription. Running the service as a domain account and made the account a
> member of the WAA group.|||In fact, I read the log file, it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
I eventually got out of this endless loop after about 16 hours of
recursively checking the log file.
"chicagoclone" wrote:
> AuthzInitializeContextFromSid: Win32 error: 234
> get this when trying to send an email subscription or a file-share
> subscription. Running the service as a domain account and made the account a
> member of the WAA group.

Documentation Tools for SSB?

Does anyone know if there are automated documentation tools around that will produce docs for Service Broker objects?

Thanks,

AndrewM

There is no tool for documentation, but there is one for retrieving a more formal specification (Called service listing). It's called Service Listings Manager and Remus has contributed that to the code gallery. You might want to use that as a starting point to build a doc generator.