How to get list of Stored Procedure
You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.
2008-08-11
1,115 reads
You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.
2008-08-11
1,115 reads
2008-08-11 (first published: 2008-06-17)
910 reads
This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL
2008-08-09
1,107 reads
2008-08-08 (first published: 2008-06-16)
987 reads
Locate and remove/delete user logins from all databases and even SQL server.
2008-08-08
11,239 reads
Used to generate Select/Delete scripts. It does NOT run them.
You need to copy the output of this script to a new window and run it manually.
2008-08-06
625 reads
2008-08-06 (first published: 2008-06-16)
2,740 reads
Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.
2008-08-05
579 reads
Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.
2008-08-05
1,243 reads
Feed it large strings of delimited horizontal data and it returns it back as a vertical table.
2008-08-05
1,478 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