I was not able to get your Question ... Can you elaborate

Hi Gain,

We can not use any open Tools because of IP Issue as you know, Can you please suggest if you are aware of using some other technique to Retrieve...

Finnally Was able to Fix the Issue.

Reason: The Account (Domain Account) used for Creating the Proxy, was not having Admin right.

Because of which if the Execel file Size is more...

Hi Friends,

I saw one issue with respect to the GET_DDL Script, issue is that NVARCHAR Data columns are Created with Double the Data Size of teh Actual Defined Size.

Can you...

Found Some Answer which is Explaining teh Casue but Defeting the Purpose Max Length Column in the Sys.all_columns:

The value from sys.all_columns shows to you a size in bytes, while when...

Thanks Paul,

But the Query / Columns in All_Columns is meant to show the Size of the Column and not the Size,

I that case the Size is defined as 100, should...

Hi Friend thanks,

But my issue is not with the Size of Index, but with the retrival Time.

Table wil be loaded with around 5,00,00,000 Records and will be Queried by one...