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

Scripts by Lester Policarpio 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: | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,570 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: | Category: linked server
Rating: |  Discuss |   Briefcase | 3,312 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: | Category: security
Rating: |  Discuss |   Briefcase | 3,619 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: | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,024 reads
   Items 1 to 5 of 5