Hi,

Thanks for your quick response. Could you please help me in writing this script as I am new to this coding stuff?….Thank you in advance..

Hi Camele, Would you mind telling how did you get this Query plan ? I meant the method of getting this plan as i am fairly new to this one...

Try one thing...just change the competibility mode to 100 (SQL2008) since you are using sql 2008 and then try to shrink the file

Check if you have correct server name mentioned in the connection string? is it default instance or Named instance? If it is default then you just enter the server...

Well..SQLGuru..first of all i would like to thank everyone who responded to my question and secondly..i was just trying to get some expert advice and was not trying to waste...

Thank you for your response. Well. basically they will be pulling data from SQL and putting into DB2 so we were planning to create a replica of that prod sql...

Thank you guys...that was really helpful!!

i got the error even while execution and also parsing the query..not sure how it worked for you

Thank you guys for your quick reply if i run my script (Db creation and Table Creation) together, I get an error but if I run DB creation and Table...

Thank you for your reply. I tried all of the things mentioned in the doc already but for some reason that Append query option is not enabled for me.

Thank you so much for your response and the explaination. That helped me alot

Thank you so much..that is exactly what i was looking for !!!! the only question i have is, Will that work on a null column ?

Thank you so much..that was really a great explaination

I am sorry ..i did not include the complete Table Def earlier ..Please find the info below

Addres --- varchar(30) --- Not Null

Data --- bit (1)...

Thank you for your quick reply. Please find below the table Def

Addres ----- varchar

Data ...