Hi SSCoach, do you have an example of a holding table? Also do you have an example of retrieving data from the " inserted or deleted virtual tables"?

Now if I want to grab information from this new row that has been entered, what is the best way before sending the email?

CREATE TRIGGER reminder2

ON Sales.Customer

AFTER INSERT, UPDATE, DELETE...

What I need to do is send an email every time an entry is added to a specific table. Any ideas or suggestion on how best to this are...

OK I have run this:

DECLARE @ResultSet INT

EXEC @Resultset =spMyStoredProc

SELECT @ResultSet

I get two results

First result:

EXEC @Resultset =spMyStoredProc returns

387961

387962

Second result:

SELECT @ResultSet returns

0

If I run EXEC spMyStoredProc I get two results:

387961

387962

@Results returns

387961

387962

The results of EXEC spMyStoredProc are:

387961

387962

Just two numbers

OK, but even when I try this it doesn't work

IF @Results > 10

PRINT 'Hello'

ELSE

PRINT 'OK thanks'

This part doesn't work

IF @Results IS NOT NULL

PRINT 'Hello'

ELSE

PRINT 'OK thanks'

I tried

SELECT DISTINCT PGNAME

FROM INSTALLS

WHERE PGNAME != (CAST (PGNAME as NVARCHAR(100)) collate SQL_Latin1_General_CP1_CI_AS)

This returned rows like:

???????? ????? ??? ????? ?????????? ?????? ???????

Thermo Fisher Scientific Inc.

But it...

Yes I mean identifying any characters not belonging to the Latin General language.

Your query picks up some, but still misses others.

Just identify them

I want to find any non latin chartacters: cyriliic, chineese, Japanese, ect

OK SOLVED

I removed the "WITH MOVE"

Nothing is using the database - I just ran SP_WHO

Yes the files are right. Do I need to use this: ALTER DATABASE [YOUR_DATABASE] SET OFFLINE WITH ROLLBACK IMMEDIATE