January 13, 2010 at 4:34 pm
i am getting below error if i try to create a login in sqlserver2005.
find the error as attachment.
January 15, 2010 at 6:36 pm
Check for a database trigger. The table ddl_log is generally created along with a database trigger in order to log database level changes. Yours is probably missing though the trigger is still there.
SELECT * FROM sys.triggers WHERE parent_class = 0
See example b here for the code often used for this trigger creation:
http://technet.microsoft.com/en-us/library/ms173781(SQL.90).aspx
January 15, 2010 at 6:58 pm
checking for a trigger is a good idea.
Have you tried to create other logins? Used other names?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply