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,818 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)
954 reads
This script is an example explaining how to write DML using CTE.
2014-07-23 (first published: 2014-06-17)
1,772 reads
Function to know column Exists or not in the Table?
2014-07-22 (first published: 2014-05-16)
2,007 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,259 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
Get a report of backups older than 60 days.
2014-05-30 (first published: 2014-05-05)
1,481 reads
Report on failed SQL agent jobs
2014-05-28 (first published: 2014-05-02)
2,124 reads
This script returns a list of all the fields of a table with it properties, primary keys and user defined types.
2014-05-23 (first published: 2014-04-30)
1,738 reads