I think if I were you I would create a new database on your Enterprise server in a form that can be restored on your Standard version.

With that...

Sean;

You are ahead of me with your post. I just got finished formatting the code as well. At first glance, not only the multiple execution paths,...

I would say it all depends on how many DTS packages there are.

1) If there are a few then consider either a migration tool or recreate them in SSIS

2) If...

Here is a clear example where bad coding practices continue to propagate. It's MOROFFs like this that give a bad name to DBAs....

Kurt

I had it somewhat different, maybe too complex:

;with which_col_a_cte (col_a, col_d, col_e) on (

select s.col_a, d.col_d, d.col_e

from destination d inner join

source s...

db_name()

This will give you the current database name. But not really sure how you want to utilize this. You may need to resort to scripting out the maintenance...

The first thing that comes to mind is to create an SSIS ETL package that loads your reporting database. You can then have greater granularity of what gets loaded...

You brought up an interesting point. I have seen where badly written SQL has been masked by the never ending upgrading of hardware, faster processors, more memory & faster...

I don't use SP_executeSQL often... but I'm guessing that if you declare the @tblAmount table in the @parameters variable instead of the SQL string (@lStr) it may work.

Kurt

Are you getting the same error? Which table is it complaining about? @tblAmount?

Kurt

Is it possible to have a share on your receiving database server for the logs instead of using the administrative share?

Kurt

I found this on MSDN:

You are using $ share which will be accessible by administrators, so make sure your service account is added to Local administrators group of both the...

Did you verify that your logshipping folder didn't go away? I've had that happen to me.

Kurt

Is it possible that...

I have found that unless I'm dealing with a VLD I can create a maintenance plan to reindex all of the databases. Once a database reaches the VLD size...