Hi ,
I tried to create a logon trigger in my database, I used this sql query :
CREATE TRIGGER connection_limit_trigger
ON ALL SERVER
FOR LOGON
AS
BEGIN
INSERT INTO adherent(nom,prenom)VALUES ('toto','titi')
END;
Then, If I try to connect , it shows to me this error message:
Logon failed for login 'PC-dell \ dell' due to the execution of a trigger name.
The context of the database has changed * and is now 'C: \ USERS \ DELL \ DOCUMENTS \ VISUAL STUDIO 2010 \ PROJECTS \ AKECHA \ AKECHA \ AKECHA.MDF'.
The language parameter is passed to French.
if I join this basis with the management studio, I can open and view my tables . but with visual studio I got the previous error :(.And I tried to drop the trigger,but he told me that there is no trigger connection_limit_trigger or no permission, I changed
the session id but I got the same error .
I ...
Go to the complete details ...