I assume your dts package (dts2000 ?) is trying to send a mail, but it does not succeed. Hence "NOTE: Failed to notify 'HELPDESK' via email."

Check your account that serves...

can I have a go ?

Since I try to avoid hints ...

how about ....

-- just a copy from your initial #empshifts

insert #empshifts2

select * from #empshifts ;

--now set up...

with SQL2005 osql and isql have been replaced with SQLCMD.

If you cannot alter the software to use SQLCMD, I guess you'll need an SQL2000 client install (or msde) to get...

- as with many of us, one of the problems is there is no application name '.Net SqlClient Data':crazy: provided by the connections.

- try to determine the host your suspect...

can you post the result of "sp_who2" (standard system sproc ) ?

If you have a remote desktop connection available, you can use EM, rightclick the servername and select properties;

In the security tab, you can see the account that is being used.

(on...

- can you double check the recipient's email address ? ( possible typo )

what service account are you using for :

- SQLServer

- SQLAgent

just grant de AD-group login rights to your sqlserver instance, then add the ad-group to the correct database role and grant the needed privileges to the AD-group.

use yourdb

GO...

a classic DML-trigger will provide auditing capacity;

Keep in mind to keep your trigger as short as possible, local, ...

because it is executed within transaction context. If your trigger fails, the...

- did you test the mail profile ?

- can you find any messages in the mail system's logging ?

- can you send "non-html" text messages ?

I've used this code to...

Matt Miller (1/18/2008)

---

... A view definition is composed of a SINGLE select statement. I'm pretty sure that won't ever create the view, unless you UNION ALL the statements (like...

Oh no, forget about the function. that won't work with temptb's

(as the error states)

In stead just add the create #mytmptb at the beginning of your master stored procedure.

and add...

indeed, you've mixed them up.

It's destiny for many of us dba's ...

Sometimes you have to proove you're human after all :w00t::D

I wonder how intelligent SQL2005 would handle a this

create view V_myLanguages

as

select 'English' as Language, Base, Text

from tbEnglish

select 'French' , Base, Text

from tbFrench

select 'Chinese' , Base, Text

from tbChinese

go

Select ...

from V_myLanguages

where...