SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Scripts with tags T-SQL, Administration Rss

Refine your search with one of the following additional tags (with number of items):

Maintenance (3)     T-SQL Aids (2)     Extended StoredProcedure (1)     Security (1)    
Search (3)     Admin (1)     GRANT (1)     SQL Permissions (1)    
Administrator (2)     Colum Permission (1)     Object Permissions (1)     sys.foreign_key_columns (1)    
Maintenance and Management (2)     column (1)     Permissions (1)     sys.foreign_keys (1)    
Search Stored PRocedures (2)     Column Permissions (1)     PUBLIC (1)     sys.sql_modules (1)    
SQL Server 2005 (2)    

Search for any content tagged T-SQL & Administration

Add a script

   Items 1 to 8 of 8   
 

The Ultimate Foreign Key Researcher

Searches for actual and potential foreign key columns for a given primary key reference.  Read more...
By Jesse Roberge 2008/08/15 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 148 reads

The Ultimate Precompiled Procedure Searcher

Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.  Read more...
By Jesse Roberge 2008/08/29 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: (not yet rated) |  Discuss |  Briefcase | 100 reads

public access to extended SP's

check public access to extended stored procedures  Read more...
By Mani Singh 2008/08/08 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 77 reads

Grant Permission to Specific objects(e.g. SP's)

Grant permissions to specific objects in Database using dynamic SQL.  Read more...
By Mani Singh 2008/08/01 | Source: SQLServerCentral.com | Category: Administrator
Rating: |  Discuss |  Briefcase | 152 reads

Column Level Permissions

GRANT Column Level Permissions  Read more...
By Mani Singh | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 61 reads

Search for a String in all Stored Procedures and beyond?

Search for String Occurence with this script in your stored procedures.  Read more...
By Mani Singh 2008/07/31 | Source: SQLServerCentral.com | Category: Search
Rating: (not yet rated) |  Discuss |  Briefcase | 196 reads

Modify columns' name in batches

Modify columns' name in batches.  Read more...
By hxd001_810 2008/02/14 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 586 reads

How to empty database

Sometimes you need to empty the content of database. Following script can do that for you.  Read more...
By Boka | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 2,026 reads
   Items 1 to 8 of 8