Ian Scarlett (8/11/2009)

---

I presume you are getting syntax errors on the xp_cmdshell line.

Try this instead

DECLARE @CALL int

SET @CALL = Call_Num From Table_2

DECLARE @PC nchar(10)

SET @PC = Schedular_PC From Table_2

DECLARE...

and this would work bearing in mind that the table to be changed had approx 56,000 rows and the post code table would have approx 3500 rows?

oh ok i see the logic there - the only issue i can see is that i dont have a definative list of all of the post codes - i...

a little confused - sorry very new.

ah thanks Gail - that'll teach me for being a plank!

thats great guys thank you for your help i think i'll be able to cope - there's just one last thing that baffling me - how will i transfer the...

ok cool, well in that case what i'm after is a trigger to cope the fields from one table to another lol

pants lol, oh ok so still use a trigger to populate my new table and then somehow auto send the email from there?

mmmmmmm ran:

sp_configure @configname = 'Database Mail XPs'

returned:

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 79

The configuration option 'Database Mail XPs' does not exist, or it may be an advanced...

I ran it exactly how you gave it to me and it returned an error so i...

Hi Jack,

Running:

sys.sp_configure@configname = 'Database Mail XPs'

Returned:

Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near '='.

thanks Jack ill go and check it in a sec, the info that we would like to be in the email is as follows:

Subject: Insafe Helpdesk - New Call Logged...

oh ok lol i misunderstood - there's no problems with it at all.

well..... at the moment we kind of don't have an official one lol, i've asked the question but it may take a while for someone to come back to me,...

hi gail, nope nothing set up - any suggestions as to what is the best way?