Alter database owner to SA from any user details on all user databases
Alter database owner to SA from any other user details against all user databases
2019-05-03 (first published: 2015-01-13)
1,702 reads
Alter database owner to SA from any other user details against all user databases
2019-05-03 (first published: 2015-01-13)
1,702 reads
A script to generate a recovery script for setting your sa account back to the password it is using at the time of running this script.
2012-05-14 (first published: 2012-04-09)
973 reads
You will need to re-install SQL Server on your DR box, then restore the backups. You will also have to repair permissions, as all of your db users will be orphaned. See sp_change_users_login in BOL.Steve
2004-06-15
2003-12-04
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers