What is the exact error you are getting? I have basically copied and pasted your code into an existing report and run it without issue.

I have not tested it or really researched it, but odds are the trigger is firing using the ownership chain so you are getting DBO. LoginName in profiler is...

I don't know a way to tell other than from data. Of course you may be stuck because your host may only do nightly full backups so Monday night...

If you were to place a clustered index on ParentID you would get more page splits and have slower inserts/updates because the entry would have to be inserted into the...

Have you done any troubleshooting at the database level with sp_who/sp_who2 to see if there is blocking?

Does it happen to the same users every time for every report?

Does it happen...

Okay, I wasn't clear that you wanted to implement this using triggers. Your triggers would have to go on the tables in the source db and implementing this way...

Where it gets tricky is do you want to have the ability for the users to parameterize those queries? How do you handle parameters?

I know I can be a...

Can you explain what you need to do? Sql Server works best with sets and recursion is typically a row by row operation. My guess is that there...

I have typically avoided using bit fields, but don't rule them out. I believe your developer is right in regard to #1. Because of teh lack of selectivity...

Since both databases are on one server then they will contend for server resources (memory, cpu, network, tempdb, etc...), but locking in one will not affect locking in the other,...

Are logging onto the server using the SQL Server Service account? With SQL Server 2005 there should not be a need to logon to the server using the SQL...

With 2005 DDL triggers you could use a Server scoped trigger on Create Database to create a job to backup that database. I have not done this, but it...

Sorry, my bad. The first paramter, d, needs to be either without any quotes or in double-quotes.

Grant,

All good points and mostly ones I have heard and made before. Having been mostly a Hybrid SQL DBA\Developer in small shops I have not encountered nHibernate, but...

I avoid providing Salary Information as much as possible. Having provided it once cost me job because the company thought they could get me cheaper than someone else because...