i guess i'm feeling generous;

I didn't even bother looking at the request, as the lack of consumable data was as far as i cared to...

syntax...you can fix that....the original trigger i wrote was tested, so it's gotta be a modification.

note i did test on a 2008 server...there may be a difference if this is...

not a server wide trigger No.

triggers for ALL SERVER can only track LOGON...

Tara-1044200 (9/10/2010)

---

I am sorry if i have confused you.

from the above script does it mean that users listed in NOT IN cluse can drop the tables.

Actually my goal is to...

Tara-1044200 (9/10/2010)

---

Looks like this trigger prohibits dropping all tables and all users and it is raising error only for the given users.

I want to prohibit everyone except User1 and User2...

because of the error "A triggermust be the first command in a batch"

you have to use dynamic SQL after the IF EXISTS test.

that goes the same for procedure/ function/ view...

Tara-1044200 (9/10/2010)

---

actually i want to handle this in reverse like say i want to restrict access to eevry one except one win group, how do i filter that group or...

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