Modify All Database Data and Logfile Names
This script modifies all dtabase .mdf and .ldf to have a standardized name of DatabaseName_Data and DatabaseName_Log.
2011-08-08 (first published: 2011-07-28)
974 reads
This script modifies all dtabase .mdf and .ldf to have a standardized name of DatabaseName_Data and DatabaseName_Log.
2011-08-08 (first published: 2011-07-28)
974 reads
2011-08-05 (first published: 2011-07-23)
2,288 reads
2011-08-04 (first published: 2011-07-25)
3,333 reads
These scripts will extract security for Windows Logins, Database Users, Roles, Objects and SQL Logins.
2011-08-03 (first published: 2011-07-28)
2,227 reads
2011-08-02 (first published: 2011-07-28)
3,055 reads
2011-08-01 (first published: 2011-07-28)
3,216 reads
This script will rename the Primary keys to standard notation - PK_TableName
2011-07-29 (first published: 2010-02-09)
1,724 reads
A quick and simple SysProcess query which will display most of the common parameters of interest.
2011-07-28 (first published: 2011-07-23)
1,421 reads
Verifies that a specified login name exists and has correct settings.
2011-07-27 (first published: 2011-07-11)
1,771 reads
This script will gather a number of Server Information items that are useful in baselining a SQL Server.
2011-07-25 (first published: 2010-01-19)
7,434 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