If you establish linked servers you can loop through sysservers and then use a 4 part query to get all of the information in just one QA session.

What about bcp out through a view ?

I dunno ... If it were my server I'd be performing a master/msdb recovery ...

Lots of good stuff here. Basically I agree that SOX is a pain and those who know the least make the most mess procedurally for us DBAs. But now I...

Today is your lucky day ... I just ran into this information in another forum earlier this week ... try this:

use msdb

exec master..sp_addlogin 'testme', 'testme', 'msdb'

exec msdb..sp_adduser 'testme', 'testme', 'TargetServersRole'

grant...

Thanks Carl !

 ... yet another reason not to autogrow by 10% ...

Could you post the bat/cmd file ?

Here is a kinder and gentler way taken from a fairly recent post:

Try setting 'Auto Close' and then just check your SQL Server errorlog !

A database does not need to be in single user mode to modify size, growth or it's growth limiting factor. As for an SP, well you would have to write...

WOW !

sp_who active works as well

from BOL:

RESTORE DATABASE { database_name | @database_name_var }

[ FROM < backup_device > [ ,...n ] ]

[ WITH

    [ RESTRICTED_USER ]

    [ [ , ] FILE = { file_number...

Agreed.

It sounds as though you have non-DBAs using either the sa account or they have sysadmin server role. If either is true then the 'gremlins' may strike at you again ......

Another question ... are you performing the backup to a local drive or a mapped drive ?