SQL Server Central - Scripts by Lester Policarpio

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,095 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 | 499 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 | 685 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 | 4,364 reads