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

322 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.33 (3)

You rated this post out of 5. Change rating

2002-06-03

2,145 reads

Blogs

A New Word: Redesis

By

redesis – n. a feeling of queasiness while offering someone advice, knowing they might...

Friday Flyway Tips: Autopilot in 10 minutes

By

The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...

Visualising SQL Server in Kubernetes

By

The other day I came across an interesting repo on github, KubeDiagrams. What this...

Read the latest Blogs

Forums

Solution to a problem without using a CURSOR

By krishnagceb

Hi there to all SQL gurus So, here is the scenario. I have a...

Error when running sql server backup routine job

By Jeco

Guys, I am facing problems when running a backup routine JOB in SQL Server,...

Prepare Sum of Bill Amount Having two different status with fast performance

By techrajendra

1, Customer table [TBLMEMBER] 's structure CREATE TABLE [dbo].[TBLMEMBER]( [TRANNO] [int] IDENTITY(1,1) NOT NULL,...

Visit the forum

Question of the Day

Counting Bits II

What is the result of this query in SQL Server 2022+?

select bit_count('7')

See possible answers