Quick table finder
This little script will search for all matching tables on the SQL Server instance
2007-11-30 (first published: 2007-10-15)
779 reads
This little script will search for all matching tables on the SQL Server instance
2007-11-30 (first published: 2007-10-15)
779 reads
This script will delete all rows from the database, except system tables.
2007-11-26 (first published: 2007-09-30)
1,719 reads
As per Threshold value DBA will get notified about the Disk Drive usage.
2007-11-23 (first published: 2007-10-08)
1,854 reads
This tabled valued function can be used to parse a comma seperated list of IDs so you can pass a parameter to use in a in clause without having to use dynamic SQL.
2007-11-22 (first published: 2007-10-04)
951 reads
Script will Provide us about the person who is running query and from where and why it is slowing down your CPU.
2007-11-20 (first published: 2007-08-28)
2,920 reads
i was trying to use the script 'create log tables and trigger' by well0549 it was very helpfull but at some tables it just didnt work ..later i find out that these tables have an identity columns but they were tinyint or small int .. i didnt do much but i did add less than […]
2007-11-14 (first published: 2007-09-03)
743 reads
This SP will be create C# classes using all table in the specified Database
2007-11-13 (first published: 2007-09-04)
2,539 reads
Warning: This script has no DBA value, but is useful for DBAs who have inclination towards occultƒº.Yesterday I had to decide the name of my new website. Since I wanted the name to be numerological correct. I wrote a T-SQL script for the same.For those of you who are not familiar with Numerology let me […]
2007-11-12 (first published: 2007-09-04)
645 reads
this procedure takes a sql login name and returns information about the login.anyone who knows Sybase will recognise the name and layout. use :- exec sp_displaylogin 'loginname' to get login information returned.this procedure has been tested on SQL Server 2005 sp2any problems email pgr_consulting @ yahoo.com
2007-11-09 (first published: 2007-08-31)
1,254 reads
this a quick sproc I put together to do various collation checks. databases that have different collations from serverdatabases that have different collations of columns withindatabases that have column collations different from database collation
2007-11-06 (first published: 2007-07-27)
2,411 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