This is a stored procedure for viewing details of trigger. It accepts trigger name as a optional parameter. When specified, it shows details of only that trigger. If no trigger name is specified shows the details of all the triggers in that database. this SP is created in master database but can be called from […]
2002-06-12
314 reads
This stored procedure can be used to send mail through CDONTS and SQL Server. It resides in the Master database and accepts email addresses and subjects with a maximum of 50 characters and a body with a maximum of 500 characters. (You can increase or decrease these according to your requirements.) For this stored procedure […]
2002-06-03
2,091 reads
In February 2011, Pat Wright invited us to talk about Automation: So the topic...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...
Hi there, Complete newb. Need some guidance. Running SQL 2012, running INFOR ERP. Indexes...
Hi, I am getting CSV files with hundreds of columns many of which have...
Hi, I've created a simple dataflow with flat file source and sql server destination....
Ask SSC