Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by mobasha B

SQLServerCentral.com profile

   Items 1 to 11 of 11   
 

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,225 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,063 reads

Kill Database sessions

This script will kill the user sessions on a specified database.  Read more...
By mobasha B 2008/08/27 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 962 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 | 931 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,708 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 | 997 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,412 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,356 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,884 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,364 reads
   Items 1 to 11 of 11