Thanks, I did read that article earlier. The linked server doesn't have any connectivity issues when used directly, it's only through using the EXECUTE AS clause that problems begin....

Run a trace against your db server and the CPU column will show CPU resources consumed. The textdata column will show what is being executed and you should be...

Run SELECT @@version

then cross-reference with the following build list:

http://www.sqlservercentral.com/articles/Administration/2960/

How do I delete this duplicate post? I've tried clicking on "Delete" but that doesn't seem to work. Is there a delay? Does the delete need to...

You need a foreign key on the child table with ON DELETE CASCADE.

There are many databases without triggers!

From MSDN: "DML triggers are frequently used for enforcing business rules and data integrity."

http://msdn.microsoft.com/en-us/library/ms189799(SQL.90).aspx

You could use a trigger that rolls back any inserts that would break your business rule.

Thanks for the replies. The problem was that the user's login was mapped to the dbo user. Although the user didn't have an individual login to the server,...

How do I see how much memory these connections are using?

No, but looking at the .sch files which have ANSI PADDING set to off, they are all for tables that have no character columns. If a table has a...

Thanks for the suggestion. I've tried disabling all triggers but still get the same error.

I searched for *.rdl files and none were returned.

Thanks for the link. So where does SQL Server store these report definitions?

I can open the packages no problem but I was looking for which system views store the information of each step that they contain. I can't find anything.

Yes, it will execute. Try it out and you'll see it in task manager.