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

315 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,093 reads

Blogs

Clustering SAP #ASCS and #ERS on #AWS using Windows Server Failover Clustering

By

When ensuring high availability for SAP ASCS and ERS running on WIndows Server, the...

Ethics in Modern Data at the Baton Rouge Analytics and Intelligence Network (BRAIN)

By

On July 27, Christine and I will present our joint presentation on Ethics in...

Heading Font Weights and List View Toggles Arrive in Block Editor and WordPress 5.8

By

With the WordPress 5.8 release, we're starting to introduce features that overall improve your...

Read the latest Blogs

Forums

SSIS Custom transform component connectin manager

By Donpi

Hi, I'am currently working on a custom SSIS transform component. I allways create an...

The ways of Alerting when comparing two tables columns and find differences..

By asita

Hello Good Morning Guru's Can you please help me to give some ideas or...

the reads of SQL profiler is the number of SQL Server logical read?

By 892717952

I used SQL Profiler to trace SQL scripts and got one sql statement with...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers