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 | 744 reads

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

Query Servers using 1 sql statement. Will make your job easy!!! Read more...

By Lester Policarpio 2008/02/19 | Source: SQLServerCentral.com | Category: Linked Server

Rating:

|

Discuss |

Briefcase | 1,841 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: (not yet rated) |

Discuss |

Briefcase | 844 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 2007/12/26 | Source: SQLServerCentral.com | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 1,449 reads

Automatically Restores All database ".BAK" Files

Restore Many Backup FIles Read more...

By Lester Policarpio 2007/11/08 | Source: SQLServerCentral.com | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 6,853 reads