Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag DBA Code Rss

   Items 1 to 3 of 3   
 

List schemas in a database

This is an expansion of the sys.schemas table. User schemas are sorted to the top, schema type is decoded, schema authorization is included.  Read more...
By Chris Compton 2015/07/14 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 969 reads

Search All SQL Script Objects in All Databases for Text

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.  Read more...
By Joshua A. Walker 2013/05/21 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,679 reads

Search All SQL Script Objects in All Databases for Text

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.  Read more...
By Joshua A. Walker 2013/05/21 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,679 reads
   Items 1 to 3 of 3   
 
Tags
miscellaneous (2)    
function (1)    
schema (1)    
stored procedures (1)    
views (1)