can you post your code and some dummy values

Ok, thanks.

Ok, thanks. Are there any techniques to get around this?

Which instance is your subscriber? 2005/2008?

If you have had to sync the subscriber environment with your publisher and your the work you have done is on the...

Is the string always consistent, if so you can use substring. i.e SELECT SUBSTRING('HELLO WORLD',4,5)

Result 'LO WO'

If you are running SQL Enterprise edition you could use the data compression feature.

Hi, for the email step have you updated the network connection? That might be forcing the connection to the old instance. You may also want to try and create the...

Are you looking at the agent job history to work out if the job completed successfully, because it may confirm that its completed successfully if it was able to send...

I know this may sound a little primitive but have you checked your junk mail, as this always seems to happen with me! 🙂

Hi there - thanks to everyone for their input on this.

After numerous calls with our hosting partners I can confirm that it was in fact a problem with...

Thanks Grant - I have actually started another thread on the limitations to see if there are any more. Looks like I'm going to be taking a hybrid approach...

Ok, great. Thanks for explaining.

There seems to be a lot of considerations which impacts whether or not in-memory processing is worth the amount of effort that is...

Or use the undocumented EXEC sp_MSforeachdb command...

http://www.mssqltips.com/sqlservertip/1414/run-same-command-on-all-sql-server-databases-without-cursors/

Thanks for this. I am learning that its not as straight forward however the link you provided just covers off creating in-memory tables from scratch. Do you...

Great, thanks for your help on this.

I spoke to our hosting company and they mentioned that Redgate would not be able to compress the file but it would...