Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
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,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
create log tables and trigger modyfied
Read more...
By
mobasha B
2007/11/14
|
Category:
t-sql aids
Rating:
|
Discuss
|
Briefcase
|
668 reads
Items 1 to 11 of 11
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.