Oh. I didn't know you were trying to move multiple databases into a single database. That wasn't mentioned previously.

If you are trying to build a mechanism to sync...

Good.

With reports that have parameters, I tend to code for parameter sniffing as a precaution. I have run into this problem too often with reports.

Create the time column with a default constraint for your timestamp.

You can't mix the select and Exec in the insert statement like that.

Even taking the DDL from the dev/test server...

The stored proc is expecting the report to pass a parameter that you are not passing. Add a parameter, then add that parameter to the proc data source.

As Daniel said, this sounds like parameter sniffing. Fixing for that should help.

You possibly have another parameter that is dependent on that parameter.

Or, do you have any subreports that may have that parameter?

blackndeye:-D

straight forward except the small typo.

monocle

Have you checked the tooltip property on tablix1?

Another option is to use CMS.

You can deploy a script to an entire set of servers at once that way.

I have seen some places develop there own deployment tool via...

Verify that you are trying to copy the correct data files for the database you detached. If the files are correct, then verify the permissions on the files individually.

Using SSIS to move the data or the Data import can do it for you.

Alternatively, you could backup the databases and restore to a 2005/2008 server first - upgrade the...

Fire