Archive for 'database'
MSSQL and Stored Procedures
Have you ever wanted to get a list of every stored procedure (stored proc) on an sql server and which tables each corresponds with? I know that I have
Try this bit of T-SQL code:
SELECT
“Table Name” = P.[name],
“Trigger Name” = O.[name],
“Trigger […]
Posted: February 14th, 2005 under programming, database.
Comments: none