Lowell (6/9/2011)

---

if this is updating a table in a different database, it might be OK...

i see it is updating renovest.dbo.[Testtable$Afsl_ Vejehoved] ...what database is the table with the trigger in?...

He he, it could look as it's the same due to my mistake. The company name was in the name and I did a search and replace.

It's an equal table...

Thanks, I will look into that 🙂

/René

I have the book made by Tom Carpenter and have used it for passing 70-432. I had another book too and find that Tom Carpenters book goes a bit more...

Found it, - thanks.

And yes you are right about the ALL SERVER was missing.

/René

Sometimes one’s mind plays you a trick. In the attempt to reproduce I did manage to find the right way:

DROP TRIGGER connection_limit_trigger ON ALL SERVER

did it.

Thanks for your help...

The executed code are:

CREATE TRIGGER connection_limit_trigger

ON ALL SERVER WITH EXECUTE AS 'navi'

FOR LOGON

AS

BEGIN

IF ORIGINAL_LOGIN()= 'navi' AND

(SELECT COUNT(*) FROM sys.dm_exec_sessions

...

Thanks a lot we will try to go this way.

/René