Stored procedure for viewing trigger details

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

312 reads

Sending mail using CDONTS and Sql Server

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 […]

3.33 (3)

2002-06-03

2,078 reads

Blogs

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

CRM Data Source Connection Error

By

This article takes us to the edge with a couple of CRM related errors...

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Read the latest Blogs

Forums

Migration sandbox

By tcroninlifepoint

Inherited about 190 2008 servers I need to migrate.  Was going to build 2014/16...

Query Help Needed

By rjjh78

To all: I am trying to create a query that will be able to...

Linked server and SQL Server 2019

By Johan_1975

Hi, I searched the infomation but I didn't found it so... Is Linked Server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers