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

309 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,073 reads

Blogs

Last Weeks Reading (2019-05-26)

By

It was tremendously extensive week for me (a week ago) when I spent time...

Migrating SSIS to Azure – Slidedeck (Techorama 2019)

By

Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Transforming rows into columns

By rkarr7

Hi Everyone, I have a table with the structure as attached in the Table...

Reduce SQL Filestream limit

By lidds

I want to save images into an sql database, and in my situation the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers