2011-09-09 (first published: 2007-11-19)
8,964 reads
2011-09-09 (first published: 2007-11-19)
8,964 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,641 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...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers