Viewing 15 posts - 1 through 15 (of 53 total)
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..
June 25, 2012 at 10:31 am
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...
April 23, 2012 at 9:41 am
Try one thing...just change the competibility mode to 100 (SQL2008) since you are using sql 2008 and then try to shrink the file
April 23, 2012 at 8:41 am
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...
April 17, 2012 at 8:25 am
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...
March 23, 2012 at 8:21 pm
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...
March 22, 2012 at 7:53 am
Thank you guys...that was really helpful!!
February 3, 2012 at 3:25 pm
i got the error even while execution and also parsing the query..not sure how it worked for you
January 30, 2012 at 10:06 am
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...
January 30, 2012 at 9:41 am
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.
January 24, 2012 at 5:02 pm
Thank you so much for your response and the explaination. That helped me alot
January 24, 2012 at 2:09 pm
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 ?
January 23, 2012 at 3:03 pm
Thank you so much..that was really a great explaination
January 20, 2012 at 7:12 pm
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)...
January 20, 2012 at 1:49 pm
Thank you for your quick reply. Please find below the table Def
Addres ----- varchar
January 20, 2012 at 1:28 pm