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

Kind of crab sold to your boss.

You should indeed disable them if you are not using sql agent jobs.

If your system is secure and you have implemented all security related...

Probably you're using DHCP addresses on your client.

The IPadress registered is the one it had at install time.

It's the port number that is unique for your machine, so that's the...

We've has some connection losses to, but the mirroring (primary-mirror-witness) resumed as soon as the connection could be reactivated between principal and mirror.

It caught up very well (sql2005 std)

I know...