DBUser Roles Script
This script will be used to script out the users and their permissions at the database level. We can use this when we are replacing /overrighting the existing database.
2011-12-28 (first published: 2011-11-22)
1,839 reads
This script will be used to script out the users and their permissions at the database level. We can use this when we are replacing /overrighting the existing database.
2011-12-28 (first published: 2011-11-22)
1,839 reads
This script can be used to generate alter column length of any string data type column(s) in a database.
2011-12-27 (first published: 2011-11-22)
1,280 reads
This script can be used to return a csv column such emails in separate rows
2011-12-26 (first published: 2011-09-14)
1,573 reads
These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.
2011-12-23 (first published: 2008-06-08)
2,383 reads
These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.
2011-12-22 (first published: 2008-01-29)
3,550 reads
A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.
2011-12-21 (first published: 2008-04-30)
4,273 reads
This script will find foreign keys (on referencing table) that are not indexed in SQL Server 2005.
2011-12-20 (first published: 2007-08-10)
3,782 reads
Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005
2011-12-19 (first published: 2008-06-03)
3,347 reads
2011-12-16 (first published: 2007-12-27)
4,134 reads
Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.
2011-12-15 (first published: 2007-10-11)
3,628 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
WhatsApp:0817819444 Jl. Raya Ngunut I No.100, Lingkungan 6, Ngunut, Kec. Ngunut, Kabupaten Tulungagung, Jawa...
WhatsApp:0817819444 Jl. Raya Durenan - Bandung, Genengan, Bandung, Kec. Bandung, Kabupaten Tulungagung, Jawa Timur...
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers