Tara-1044200 (9/10/2010)

---

Lowell

This looks exciting to me and would like to try but few questions..

1. Yes i have 3 tables only across all servers

2. i have 2 win groups to restrict...

Tara i saw the other thread , and yes it's possible, but you need to decide on some way to identify the table...specific name, maybe from a table in master,...

Tara i saw the other thread , and yes it's possible, but you need to decide on some way to identify the table...specific name, maybe from a table in master,...

yes that was exactly what i was trying to show you; i just included the whole code so you could see how to obfuscate a specific script;

you can see that...

lets try something different...show us what you think the INSERT INTO statement would look like;

your requirement changed form updating colA and colB to something different....all the clues for your trigger...

igngua (9/9/2010)

---

if i do an instead of trigger that would delete the original record. I dont want the original record to be deleted. I want a new record that takes...

if the three columns make the row unique, why are you changing one of the values? a trigger like that should change columns other than those comrising the primary key.

if...

update dbo.eicanalesres

SET idcontrato = '13'

FROM INSERTED

WHERE dbo.eicanalesres.IdContrato = INSERTED.IdContrato

AND dbo.eicanalesres.EiCanalId = INSERTED.EiCanalId

AND dbo.eicanalesres.EiFechServ = INSERTED.EiFechServ

AND inserted.idcontrato = '02'

AND inserted.EiCanalId = '91'

and inserted.eifechserv = eicanalesres.eifechserv

you missed the core of...

can we telecommute from the US?

hehe just kidding, since the location is India; i thought a little role reversal would be funny.

I know there is usually a reason behind everything in your posts , Jeff...I love reading your posts specifically because I learn something (and I'm...

i love logon traces, but for tracking/ accessing specific databases, i don't think it would work;, a logon trigger occurs before a user connects to a database...so in the trigger...

the parameter @recipients for msdb.dbo.sp_send_dbmail expects a semicolon delimited list of recipients; there's no limit to the # of recipients, since it is a varchar(max) definition;

so if you are...

As a solution to my own question, one of the real problems is that a CREDENTIAL is created to hold the password for the SMTP user; i do not know...

yeah, digging for stuff is turning into a pain...

just going for the account info, for example, the password associated to the username used for SMTP AUTH command appears to use...

it's easy!

there is a link named "Control Panel" just left of the oh so familiar "Recent Posts"

click that, and down on the left is a link to "Edit Avatar"

click that...