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

Scripts by Lester Policarpio

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

Automatically Restore Backup Files for SQL 2005

This script helps with restoring backup files SQL Server 2005  Read more...
By Lester Policarpio 2008/12/31 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,534 reads

Select, Update, Delete, Insert etc.. in many servers using 1 query

Query Servers using 1 sql statement. Will make your job easy!!!  Read more...
By Lester Policarpio 2012/03/28 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 3,280 reads

Server Login/Role And DB User/Role Script

This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results  Read more...
By Lester Policarpio 2008/01/25 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 3,453 reads

Restore Server/Database users/roles

Restore server/database users and roles from another server when we are restoring databases to another server.  Read more...
By Lester Policarpio 2012/04/12 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,024 reads
   Items 1 to 5 of 5