If...

I've worked with this sort of scenario before and it can be worth while setting this up.

In the event of a planned failover, e.g. for maintenance, where you need to...

Also, it is commonly believed that one can't create an index on a table variable, however, this can be achieved by declaring a primary key like in the example below....

I may be wrong as I can't see your data, but it looks like this portion of your code always returns one row:

If @RId is not null and @ADt...

This only works on SQL 2005 up. I've tested it and I know...

The OR line has an extra parameter. Note the extra ,1 in the brackets.

Leo

You need to use the PWDCOMPARE function:

Reat this article: http://msdn.microsoft.com/en-us/library/dd822792.aspx

Use it like this,

SELECT name FROM sys.sql_logins

WHERE PWDCOMPARE('', password_hash) = 1

OR PWDCOMPARE('', password_hash, 1) = 1 ;

Cheers

Leo

Consider just adding another file on a new drive and letting the data flow over into that. Then restrict growth on the original .mdf to it's current size.

Another option is...

The problem has been resolve. There was a SQL Monitoring System patch release that changed the settings.

Cheers

Leo

If these aren't the defaults, then I suspect they may be maximums, particulalry the 250000 value. The strange thing is I have another client and every one of their servers...

This will give you a script you can run against each database. It will return you the min date as the first column and the table and column names as...

Consider using BCP out to create a file on file server that all the other instances can see, then use BCP in from each of the instances that need the...

This will list all the jobs and their databases assuming the developer was disiplined enough to set the correct database on each job step, and didn't use the database name...

I've also got the attached document. I set it up about 2 years ago, but I can't imagine it's changed much.

Cheers

Leo

I have this in my notes

EXEC master.dbo.xp_backup_database

@database = 'MyDB'

, @filename = '\\MyServer\g$\backup\daily\MyDB.bkl'

AND

EXEC master.dbo.xp_restore_database

@database = 'MyDB',

@filename = '\\MyServer\g$\backup\daily\MyDB.bkl',

@with = 'move "MyDB_data" to "g:\data\MyDB.mdf"',

@with =...