SQLServerCentral - Scripts by Lester Policarpio

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,348 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 0001/01/01 | Source: SQLServerCentral.com | Category: linked server

Rating:

|

Discuss |

Briefcase | 3,173 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 | 2,734 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 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 2,746 reads

Automatically Restores All database .BAK Files

Restore Many Backup FIles Read more...

By Lester Policarpio 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 9,351 reads