Restore Server/Database users/roles
Restore server/database users and roles from another server when we are restoring databases to another server.
2012-04-12 (first published: 2007-10-23)
3,109 reads
Lester Policarpio
Select, Update, Delete, Insert etc.. in many servers using 1 query
Query Servers using 1 sql statement. Will make your job easy!!!
2012-03-28 (first published: 2008-01-16)
3,353 reads
2011-06-01 (first published: 2007-09-02)
10,461 reads
Automatically Restore Backup Files for SQL 2005
This script helps with restoring backup files SQL Server 2005
2008-12-31 (first published: 2008-12-11)
1,597 reads
Server Login/Role And DB User/Role Script
This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results
2008-01-25 (first published: 2007-11-27)
3,781 reads
Blogs
SQL Server Wait Stats
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
FabCon 2025 Recap
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Forums
The Subtle Differences Between COALESCE and ISNULL
Comments posted to this topic are about the item The Subtle Differences Between COALESCE...
SQL Server Collations
Comments posted to this topic are about the item SQL Server Collations
Why would using a variable vs Hard Value impact a Query's Performance
Why would using variables in place of hard coded numbers impact a query's performance? ...
Question of the Day
SQL Server Collations
At what levels can we set the collation in SQL Server 2022?
See possible answers