SQL Server Performance Forum – Threads Archive

Cannot Manage Triggers

Here is the problem I am having. In a SQL Database using T-SQL I can do anything I want with triggers however in the enterprise manager I cannot. Whenever you select the table | right click | all task | manage triggers the trigger property box does not display nor does it create an error message. I have checked the updates and patches. They are ok. SP3a (SQL-Server 2000)
I have reinstalled enterprise manager.
Any idea of what could cause this and any fixes? Thanks

Check the registration settings of the server in EM: under which account are you logging on to the server? This account probably does not have sufficient privileges.

I am logging on as the SA. It is running in mixed mode SQL/Windows authencation. I am logged onto the server as the administrator.

How about from other PC with EM?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Probably some kind of mismatch with the client tools, try from another client’s machine. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I am getting with my client now too try this. This has me really puzzled. I have never seen anything like this! Thanks for the responses.

PLease specify the edition of SQL server used. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

SQL Server 2000 Enterprise Edition

]]>