Finally, I restarted my machine and script is working now as expected. My server collation is Chinese_PRC_CI_AS. Thanks!!!

I created the different table in SQL2008R2 -

CREATE TABLE mydatabase.dbo.Test_New ( name1 varchar(10), name2 varchar(10), name3 VARCHAR(100)...

Lowell, I can also see the correct output in SQL2012 but not in SQL2008R2.

Below output is from SQL2012 on same SSMS instance. I did not use any other instance of...

Thanks Lowell. I changed the settings as you suggested.

As you see above, my table lengths is less than 8000 bytes. After changing it to 8192 bytes, I am getting...

I downloaded the script from http://www.stormrage.com/SQLStuff/sp_GetDDL_Latest.txt, it does not work on SQL2008 R2. It does not print all the columns of the below table.

CREATE TABLE dbo.Test1...

it does not work on SQL 2008 R2. Is there any other working version available ?