What has happened (and I don't yet fully understand why but will discuss with our dev team) is that for example, we have an ID field on a table with...

Hi Jeff

It is because we have a situation where some tables appear to have id values less than the current identity value which will get auto generated on next insert....

could you not just do backup and restore ? Are they the same version of sql server ? If not, have you tested ?

Thanks Grant - I suspected as much !!!

Hi Grant

The settings for both servers are the same in regards

MAX DOP =0

COST THRESHOLD = 5

The faster box (2008r2) has 20Gb capped sql server memory and 24 CPU's

The slower sql2012...

That is fantastic - that has done exactly what I needed. I was so close with my own effort as well, but it looks like I got the syntax mixed...

Thanks Gail. I think I was getting confused with upgrading a sql2000 to sql 2012 which can't happen

More coffee needed !!!:-)

So I have altered the metadata to match the SSIS package datatype which is DT_STR. (ive altered the table column in sql server to type of varchar which should match...

I'm not really sure what I need to do to do that - shouldn't the package work now that I have converted the data type within the stored proc ?...

Phil

We made a change in the stored procedure which the package call and it now does a cast to the non unicode datatype (varchar) and this package is using the...

Thanks Gail - I wasn't sure if the log shipping backup job would break and I'd have to therefore recreate each backup job again.

Thanks for clearing that up.

🙂

Will we need to recreate the 15 minute log shipping backup job for every database on the server or will it just continue to take a...

ok thanks very much.

For TempDB, I'll often put them on the same drive if I'm short of independent drives, if for nothing else than to keep the TempDB load separate from the user...

ok thanks everyone - They tell me the data type hasn't changed, so im going to try and get the data type from the sql server base table changed from...