Check all the running SQL services in different servers.
You can use the details before you start implementing SQL Patch to the servers i.e. if you want to explicitly stop the SQL Services.
2015-03-31 (first published: 2015-03-26)
2,129 reads
This procedure let you list [optional] by table:
-Foreign keys
-Primary key
-Indexes
2015-03-27 (first published: 2014-02-06)
4,063 reads
Create a stored procedure that will send the result of a query as an html table from the database mail.
2015-03-26 (first published: 2014-02-14)
5,158 reads
2015-03-25 (first published: 2014-02-25)
8,436 reads
Populate a calendar table with user set interval start and end datetime values.
2015-03-24 (first published: 2014-02-21)
2,466 reads
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-20 (first published: 2015-03-17)
952 reads
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-17
174 reads
Getting rid of R-BAR to split a delimited string. This method is popular for it's simplicity, speed and zero reads.
2015-03-17 (first published: 2013-07-29)
4,849 reads
Enable Filestream on SQL instance and database with database name.
2015-03-16 (first published: 2013-08-12)
1,681 reads
DDL trigger will add a user to a newly created database and assign db_owner role. It can be modified for what role is required.
2015-03-12 (first published: 2013-08-22)
1,634 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