- 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...

Is there a problem when using a temp table to generate your number ?

e.g.

create table #mytmptb (myNumber int identity(1,1))

set nocount on

declare @MyNumber int

insert into #mytmptb

output inserted.myNumber

default values

set...

my first impression ?

- just call the sproc have it return a rowset to a .net-dataset and the write the .net dataset to an xml-file.

(I don't know the coffee language...

just my 2ct.

- avoid dynamic sql

- add a language code column an just use one table

- maybe even partition on the language code column

- if you still want tables to...