Technical Article

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

You rated this post out of 5. Change rating

2002-06-12

351 reads

Technical Article

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)

You rated this post out of 5. Change rating

2002-06-03

2,201 reads

Blogs

A New Word: Dorgone

By

dorgone– adj. wondering if you could slip away from an event or group conversation...

Tell It Once: Setting Up Claude With Skills and MCP Servers

By

Many of us use AI the same way every single day. Open a tab....

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

By

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

Read the latest Blogs

Forums

Hyperscale Replicas II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas II

Practical Reporting Queries with CROSS APPLY (Part 3)

By Imran2629

Comments posted to this topic are about the item Practical Reporting Queries with CROSS...

Your Favorite Quotes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Your Favorite Quotes

Visit the forum

Question of the Day

Hyperscale Replicas II

How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?

See possible answers