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,112 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 | 1,005 reads

Kill Database sessions

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

By mobasha B 2013/05/21 | Source: SQLServerCentral.com | Category: administration

Rating: (not yet rated) |

Discuss |

Briefcase | 930 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 | 905 reads

Get Linked Server Configuration

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

By mobasha B 2009/12/17 | Source: SQLServerCentral.com | Category: linked server

Rating:

|

Discuss |

Briefcase | 1,602 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 | 943 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,348 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 | 3,236 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 2012/01/13 | Source: SQLServerCentral.com | Category: monitoring

Rating:

|

Discuss |

Briefcase | 3,798 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,298 reads