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

313 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,085 reads

Blogs

Daily Coping 10 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 9 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Refreshing a Power BI Dataset in Azure Data Factory

By

I recently needed to ensure that a Power BI imported dataset would be refreshed...

Read the latest Blogs

Forums

Controlling Intelligent Query Processing Features

By Kathi Kellenberger

Comments posted to this topic are about the item Controlling Intelligent Query Processing Features,...

To use the same function to pass table name as a parameter

By Kenean

I have this function, but I wanted to pass a table so as to...

Create SQL Login to View only one database on server

By yogi123

Hi All, I have one task to create a login, and user need to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers