have you been granted VIEW SERVER STATE permission ?

I think tosscrosby is spot on !

You should be able to pull that info (alter database) from the instances default trace data.

Have a look at :http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

My registration is completed :w00t:

(it have been two long years without ... :Whistling:)

Very nice HowTo article, Roy :smooooth:

It's this kind of short ToDo's that will get people started with testing the ResGov and exploring its purposes and usages.

Thank your for sharing.

I hope my little article can get you started with SSB.

http://www.sqlservercentral.com/articles/Service+Broker/2897/

Use a format parameter with convert !

Code:

declare @x datetime2

set @x = CURRENT_TIMESTAMP

print '1:' + convert(char(30),current_timestamp, 121)

check books online http://msdn.microsoft.com/en-us/library/ms187928.aspx

are all your sql 2000 servers on SP4 ?

(after upgrade to sp4 for sql2k we noticed this change in behavior in some cases)

Check the linked server definitions as they may have their own security setting to get to the linked server !

One option may be to adjust Gails query to

SELECT logins.name, roles.name

FROM...

- are there any triggers on the object (that may prevent inserts ...)

- how do you actually insert ? using an sproc ? (check if it uses the execute as...

- you should check your setup bootstrap to see how/when your error occured.

- Since it states SQLServer failed to start, I would take a look at the sqlserver errorlog file...

some DMV will not work in you are connected to a down-level db.

e.g.

use TheSQL2000db

select *from sys.dm_db_index_physical_stats(db_id(), object_id(NULL), null, null, null)

will not work on a level...

Indeed.

there is no need for that to be changed !

all it does is provide the port number to a request that uses the instance name of a named instance.

from bol:

Account...

SQLServer actually on unix : only when hell freezes over 😉

...

in place upgrade may not be supported !

Also keep in mind, SQL2005EntEdtn vs SQL2008(r2 ?) StdEdtn means feature loss !!

e.g. no more online reindex, ...

"Compare Edition Features"

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx