For the sake of completeness, I'd mention another method to store hierarchies in the database - the path model which is similiar to the adjancey model, in that each node...

Eric is right -

Full database backups without copy_only don't break a log chain, they zero out the DCM so that differential backups can't be used with previous full database...

If you use parameterized dynamic sql in the stored procedure, it shouldn't differ from the query within the report.

What I'd try is dump the SSRS parameters, do it with...

Hi,

You forgot to mention that using the output clause within UPDATE and DELETE statements can result in process blocking and even deadlocks.