If you have any requirement where you want to find out all the SPIDs running on a database along with the program/application name of the SPID and the login details. You can run the procedure to get the details very easily.
2014-08-12 (first published: 2014-06-30)
4,122 reads
2014-08-11 (first published: 2014-05-28)
1,798 reads
This script was published originally on http://humakhurshid.blog.com/2011/07/14/script_out_fulltext_catalog/
The author has tweaked it little bit to improve it.
2014-08-07 (first published: 2014-07-02)
5,820 reads
The script below executes on the first of every month and moves files from source to destination location.
2014-07-24 (first published: 2014-06-16)
956 reads
2014-07-23 (first published: 2014-06-17)
1,772 reads
2014-07-22 (first published: 2014-05-16)
2,008 reads
Most of the people know about the right-click option 'View Dependencies' in the SQL Management Studio.
It will diplay expandable tree off all dependencies each way. Correct me if I'm wrong, but I couldn't find any other way to save this othere than taking a screenshot of the window.
2014-07-21 (first published: 2014-05-19)
937 reads
This is an example of how to Cache Query results on the Server side
then page though the results
2014-06-06 (first published: 2014-05-05)
2,260 reads
this is a powershell script that can start a job at a defined step name (default will be step 1), on a network instance either on a network on locally.
2014-06-04 (first published: 2014-05-05)
777 reads
2014-05-30 (first published: 2014-05-05)
1,483 reads
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers