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,112 reads
Scripts
2008-08-11 (first published: 2008-06-17)
910 reads
Find the port no Get Port SQL Server 2000
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)
983 reads
Remove SQL Logins from All Databases and SQL Server
Locate and remove/delete user logins from all databases and even SQL server.
2008-08-08
11,237 reads
Delete records in all related tables
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
622 reads
2008-08-06 (first published: 2008-06-16)
2,735 reads
Counter Table (table of numbers) Setter-Upper for SQL Server 2000
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
576 reads
Counter Table (table of numbers) Setter-Upper for SQL Server 2005
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,236 reads
Delimited String Parsing Functions - Big Set
Feed it large strings of delimited horizontal data and it returns it back as a vertical table.
2008-08-05
1,474 reads
Blogs
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
Forums
LAYANAN BCA KCU PRABUMULIH Telp/Wa 08388333589
Jl. Jenderal Sudirman No.14, Muara Dua, Kec. Prabumulih Tim., Kota Prabumulih, Sumatera Selatan 31121
Alamat Telp BCA KCP Siliwangi (+62) 838-4945-0961
Wa:083849450961 Jl. Jenderal Sudirman No.39, Krobokan, Kec. Semarang Barat, Kota Semarang, Jawa Tengah 50141
Alamat Telp BCA KCU SIDOARJO (+62) 838-4945-0961
Wa:083849450961 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers