It would be because you simply didn't have the authority to start and stop services from the system perspective, so regardless of what rights you had in SQL Server, the...

lol....

Ah, I had a link to a resource for this as well.......

http://support.microsoft.com/default.aspx?scid=kb;en-us;322140

The most common cause of this in my experience has been when one of the files needed by sql server was not on a shared resource, and Sql Server, once...

Sounds like a permissions issue.......Do you have the correct permissions to manage the server your attaching to? And has the server been set up to allow remote connections?

OK,

Your error in my script would have to have been caused by having a value in the syscomments table that was too long.....here is a modified version that will work...

Yelena, that will only give the first 256 characters of the proc per line.....

Here's on that does it by largest proc in length....

select

O.name, Sum(Len(

select

O.name, S.Text from

sysobjects O

inner

join

In every enviroment I have worked in, the packages have been saved as files, and then the files can be transported to whatever enviroment you want, by copying the files...

Subqueries are fine within distributed transactions. Post your code, and let us look at what your doing.

So far as I know, currently no version of SQL Server handles more than two nodes to a cluster. SQL Server 2005 is supposed to allow up to 8, but...

What is: 1075 Database

What is: 151 locs/proc ID

What is: 63 Locks/objc.

And what is: server specification can handle up to 1000 Database

It sounds like you have an application that is walking...

If your looking to delete a particular command, you'll find all replicated commands in the REPLCmnds table in the distributor, and can track down the one you need by publication...

That's slick....create a table variable of identities and create a date from them........wouldn't need updating later either......kudos to Ryan