2011-09-09 (first published: 2007-11-19)
8,965 reads
2011-09-09 (first published: 2007-11-19)
8,965 reads
Script one or all roles in a database. Includes users, obect permissions and column permissions.
2011-09-08 (first published: 2008-01-08)
5,304 reads
Generate the scripts that will allow you to compare tables pass/fail.
2011-09-07 (first published: 2007-12-28)
12,642 reads
2011-09-06 (first published: 2011-08-13)
2,005 reads
2011-09-05 (first published: 2007-01-25)
4,024 reads
This function returns the difference between the date in text format
2011-09-01 (first published: 2011-08-30)
1,071 reads
2011-08-31 (first published: 2011-08-24)
2,608 reads
Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).
Useful when rebuilding indexes online.
2011-08-30 (first published: 2011-08-25)
777 reads
Output table of gaps in a primary key across multiple databases on same, remote and/or linked servers.
2011-08-29 (first published: 2011-08-12)
981 reads
2011-08-24 (first published: 2011-08-12)
1,190 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