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

Scripts by Shiva Challa

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Remove comments from the SQL Code

Takes text (varchar(max)) as input and strips out any comments and RETURN the string. Comment is replaced by new-line character.  Read more...
By Shiva Challa 2012/07/04 | Source: SQLServerCentral.com | Category: un comment
Rating: |  Discuss |   Briefcase | 1,745 reads

List all Usernames, Roles for all the databases.

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).  Read more...
By Shiva Challa 2013/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 20,206 reads

Create Role for specific set of Objects based on a set of Conditions.

This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.   Read more...
By Shiva Challa 2008/10/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,081 reads
   Items 1 to 3 of 3