So there are other triggers on the table? Please will you post the definitions for them?

John

Have a look at this page. Your trigger is INSTEAD OF UPDATE, but you're doing an INSERT.

John

When you use xp_cmdshell, the command runs in the context of the SQL Server service account. There are two things you could try: make sure that the folder that...

Do what I did and type "cluster command line" into your favourite search engine.

Or just guess - the command line utility is actually called "cluster". But you'll still need...

Tables don't perform - queries do. But make sure you have the correct indexes and statistics set up on the tables, and that those indexes are maintained and statistics...

That's interesting. What was your answer?

John

OK, I think what I'm about to say is right, but you may want to check it. When you run a job as a login that's a member of...

Sorry, but I'm lost now. Are we talking about sysadmin on ssisadmin (never heard of that)? What do you mean by "it leaves the network drive"? Could...

No, the table names won't display. If you do SELECT * FROM MyTable, that shows you everything in the table, but it doesn't return the name of the table....

You need to monitor the SQL Server Agent service at OS level using something like SCOM.

John

No. The query that you posted above, run it every five minutes and insert the results into your audit table. Bear in mind that if a database is...

Lokesh

Try dumping the results of your query into an audit table every five minutes. You'll want to test and plan carefully so that you don't end up using lots...

[font="Courier New"]SELECT name FROM sys.databases[/font] will solve the problem you describe, although I can't help suspecting that your requirement is somewhat more complex than that. You can use a...

I don't know what's going on, then. Try running a Profiler trace to see what's happening in the background when you modify the job.

John

What happens if you create a new login and make it a member of SQLAgentOperatorRole in msdb?

John