I guess that's what the "true" parameter is for in

use exec sp_changedbowner 'sa', true.

You can use sp_changeobjectowner @objname = 'oldowner.object' , @newowner =  'newowner'

making this #é&() mistakes, you can immagine the rest of my day

Still early on the day

SELECT BS.database_name

, BMF.physical_device_name

, BMF.device_type   

FROM msdb.dbo.backupset BS

INNER JOIN  msdb.dbo.backupfile BF

ON BF.backup_set_id = BS.backup_set_id

INNER JOIN msdb.dbo.backupmediafamily BMF

on BMF.media_set_id = BS.backup_set_id...

SELECT BS.database_name

, BF.physical_name  

FROM msdb.dbo.backupset BS

INNER JOIN  msdb.dbo.backupfile BF

ON BF.backup_set_id = BS.backup_set_id

WHERE BS.database_name = 'MyDB'

- If you're using a "sqlserver maintenance plan", it will optimize _all_ objects of the selected databases.

- verify that they don't drop and recreate their tablesat runtime ! because then...

- your sqlserver-serviceaccount or your sqlagent's (if you're using a job) need read-auth for the .bak-file

- you as sql-user ... you need to be at least db-creator or database-owner...

This is one of the enoying things where they use actual "work"-tables in stead of #-temp-tables.

So the create them on the fly, use them and drop the at the end...

use exec sp_changedbowner 'sa', true.

Keep in mind this is one of the flaws of EM. You'll have to disconnect an reconnect to see the correct results.

If you want to restore using EM, you'll need to have the backup-file(s) at the server itself.

If your bak-files are on a remote location, you can use e.g. QA and...

check http://www.databasejournal.com/scripts/article.php/1496451

to apply the rename of your windows server in your sqlserver instance.

According to my biztalk-admin changing the biztalksettings to connect to the new servername should be a peice...

- Oracle does not have locking, it has versioning ! Different concept.

- SQL2005 Snapshot isolation level mimics this behaviour.

maybe these art. clarify a bit :

http://www.databasejournal.com/features/mssql/article.php/3560451

http://msdn2.microsoft.com/en-us/library/ms130975.aspx

http://msdn2.microsoft.com/en-us/library/ms189050.aspx

If you're alowed, you could also quickly create a delete-trigger to log all deletes from that table (maybe even narrowing the rows to the ones you want to)  into a audit-table....

after the attatch you'll have to use this :

use yourdb

exec sp_changedbowner @loginame = 'sa' ,@map = 'true'

Also keep in mind EM does not refresh db-owner info ! You'll have to...

how about just adding startupparameters to your sqlserverinstance ?

add -T1204 and -T3605 so deadlock info lis logged into the sqlserver errorlog.

(

Today, your article was one of the featured articles with the newsletter.

Since your filed the article in 2005, things have changed.

Now you have the...