Why did they reject that option?

The only big overhead I see is the remember to change schema in 2 places rather than one.

Option z might be to create a db...

Glad to. I'd most likely turn it into a short article or script as well.

Thanks again.

Awesome.

One last question.. Got any links on how to configure the external tools so that I can link this script and make my own single click deploy function?

Linda Claes (1/18/2011)

---

Hi Ninja,

I indeed saw this behaviour before. Especially changing the obligatory parameters is causing me headaches. For that reason we have a custom reporting services script (.rss file)...

Another quick question for ya. Have you noticed in ssrs 2k5 that when you deploy to overwrite a report, the overwrite doesn't work or only works partially??

Any workaround...

Here's another idea that might require much less coding and QA.

How about copying the DDL of the tables involved and calling tblname_hist.

Then copy the forms in question (or even use...

And please post back the link here once you're done so we can vote on it (I've had this issue before and chose the recoding way. I would've loved an...

Good point. Also they can often suggest alternatives you had...

Are you able to do a simple select in the same excel file?

Windows 32 or 64 bit?

Sql 32 or 64 bit?

Are you able to do a simple select in the same excel file?

How about adding a computed column and index it? Index view?

That was doing a good job in 2003. I have not tried it since so maybe it can help you out.

There's a free trial so you should have enough...

The only thing I ever saw was a "best guess" script. It was matching the tables by finding columns with the same name and IIRC data types.

Now that will...

Thanks for the help.

And the least I can say is WOW that's screwed up.

However I was able to get myself out of it with this "simple" expression :...

add this to your where clause :

AND starttime >= DATEADD(n, -30, GETDATE())

Of course it might also make good sense to to check on the endtime instead...