<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
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
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Scripts by Mehernosh
SQLServerCentral.com profile
Items 1 to 4 of 4
sp_MSforeachtable:Add SQL objects to multiple database on a server.
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
Read more...
By
Mehernosh
2011/11/14
|
Source:
SQLServerCentral.com
|
Category:
sp_msforeachtable
Rating:
|
Discuss
|
Briefcase
|
487 reads
Query to list all running SQL jobs.
Query to list all running SQL jobs.
Read more...
By
Mehernosh
2011/09/15
|
Source:
SQLServerCentral.com
|
Category:
list all running jobs.
Rating:
|
Discuss
|
Briefcase
|
2,499 reads
A simple SysProcess query
A quick and simple SysProcess query which will display most of the common parameters of interest.
Read more...
By
Mehernosh
2011/07/28
|
Source:
SQLServerCentral.com
|
Category:
sysprocesses
Rating:
|
Discuss
|
Briefcase
|
1,265 reads
SQL Process % Complete
Display %complete SQL using SYS.DM_EXEC_REQUESTS
Read more...
By
Mehernosh
2011/08/05
|
Source:
SQLServerCentral.com
|
Category:
sys.dm_exec_requests
Rating:
|
Discuss
|
Briefcase
|
1,900 reads
Items 1 to 4 of 4
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
