Figured out the problem. The script is not completely copied since the result is displaying in less character....Choose Tool-->Option-->Results-->max char set-->8612

Cheers

Slava, i am having the same problem while i try to setup a transactional replication. Wondering if you were able find a solution. Please share

Cheers

Here is a link to CDR…But I am looking more on Database files copying

http://news.thomasnet.com/fullstory/470040/2695

Brain thanks for your reply. In fact that's exactly what we have in place right now, what we are looking though is to replace it with a trigger with out violating...

Point take Rgr. I am looking for other's opinion as well. Thanks for your post again.

There are certain systable that you can not create triggers like sysobjects, however you can create a trigger on sysconfigures, make sure enable the option "allow changes to system tables"...

Thanks for the reply Rgr'us. Brain or Andy can you please comment on  this if you know any details or links to MS Support on SQL Server 2000.

Thanks

This doesn't applies to me since I am not using Full Text. I appreciate your reply

Thanks

Brian, It is under investigation rite now. This just I am collecting data for the documentation. Right now we don't have any problems, at least for now. Our...

Thanks for the answer Brian. I can't believe this is true. So even though I do have sp3 rite now its not really sp3 since couple of file...

I guess you don't need to include the service name in the quotes. I am able to stop/start the service without quotes

Thanks for the reply. With with windows resource kit we can do the following one

TO start

SC \\Servername Start Service_Name

SC \\Servername Stop Service_Name

To...

Psullivan, did find the answer for your question.  I am hoping that you can share the details here. I just started my research about Biztask server.

Just spoke with the MS rep and the only way that we can clear those SPIDS is to cycle the service after the process has been killed

Nope. I sure don't want to restart the service.