Is your splitter function used inside the proc on the @City parameter?

I went looking for that option a while back and couldn't find it either. 🙂

Well you might be able to do that (select *) for inserts, if the column order is the same in both tables.

I don't think you can for updates though.

Using an after insert, update trigger will probably be your best bet.

No need for a delete trigger as you're not passing on deletes 🙂

I used a script to create the linked server rather than the GUI, if that helps.

Mind if I ask what connection string you're using?

Thanks

Hmm not good! Maybe wait for SQL 2015? :hehe:

Could it be corruption in the install media itself?

Hi, you'll need to kill them from the MySQL side.

Hmm, using IN @parameter works in SQL 2008, in 2005 you may need to write a function to delimit the parameter into a proper list.

e.g. I think the report...

If you check the Allow multiple values check box in the parameter properties the drop down should become a multi-select list 🙂

I bypassed SQL 2005 but 2008 also has an allow blank value checkbox, have you ticked that?

I think that's BIDS caching again -I think you need to exit the report, resave, and then try running it again.

You shouldn't see that behaviour in a deployed report 🙂

Hmm, think I'd create another...

IIRC BIDS caches results locally. There is a way to make it run a fresh set but I forget how!

You can force it by deleting the cached data from the...

No worries, done it plenty of times myself 🙂

Your set statements are just setting your paths to e.g. '@data_file_path@restore_as@mdf_extension'

Drop all the ' from them and you should be ok.