Sunday, 1 July 2012

Search text from all PROCEDURE In sqlserver


SELECT DISTINCT object_name(id) FROM syscomments WHERE text LIKE '%Saved Successfully%' ORDER BY 1
- No comments:
Subscribe to: Comments (Atom)

Get all non-clustered indexes

DECLARE cIX CURSOR FOR     SELECT OBJECT_NAME(SI.Object_ID), SI.Object_ID, SI.Name, SI.Index_ID         FROM Sys.Indexes SI             ...