SQLServerCentral - Scripts by mobasha B

Grant Mass permissions

Create A role and grant it a permission on a DB Schemas. Read more...

By mobasha B 2009/04/09 | Source: SQLServerCentral.com | Category: security

Rating:

|

Discuss |

Briefcase | 1,047 reads

Get DB Files in directoy

get the database files existed in specified directory Read more...

By mobasha B 2009/04/17 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 964 reads

Kill Database sessions

This script will kill the user sessions on a specified database. Read more...

By mobasha B | Source: SQLServerCentral.com | Category: administration

Rating: (not yet rated) |

Discuss |

Briefcase | 878 reads

Get DBMail information

get the profile name and the account name etc about the dbmails created on the server Read more...

By mobasha B 2008/09/12 | Source: SQLServerCentral.com | Category: database mail

Rating:

|

Discuss |

Briefcase | 873 reads

Get Linked Server Configuration

This query will return the linked servers configuration Read more...

By mobasha B 0001/01/01 | Source: SQLServerCentral.com | Category: linked server

Rating:

|

Discuss |

Briefcase | 1,518 reads

Create Snapshot Dynamicly

Create Snapshot Dynamically considering multiple database files Read more...

By mobasha B 2008/08/20 | Source: SQLServerCentral.com | Category: database snapshots

Rating:

|

Discuss |

Briefcase | 894 reads

Automatic Restore

Restore a random backup file on a predefined directory to check backup validity. Read more...

By mobasha B 2008/06/20 | Source: SQLServerCentral.com | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 1,271 reads

Script permissions on all databases

i took the core from a script found in the site for generating permissions and update it. Read more...

By mobasha B 2008/05/06 | Source: SQLServerCentral.com | Category: security

Rating:

|

Discuss |

Briefcase | 2,939 reads

Who did what?

This select will show the last sql statement for every open session plus many helpfull information. Read more...

By mobasha B 0001/01/01 | Source: SQLServerCentral.com | Category: monitoring

Rating:

|

Discuss |

Briefcase | 3,660 reads

space check

When run it will check the space left on the disk. If it was under 4GB it will raiserror. Read more...

By mobasha B 2008/05/05 | Source: SQLServerCentral.com

Rating:

|

Discuss |

Briefcase | 1,244 reads