Thanks Phil

Yes

have a large Table having Identity column as Int and value has neared the max value so need to make the identity column as BigInt

Thanks applied this change suggested and its working fine.

Thanks for your Inputs

Thankyou for the suggestion.

Thanks for the input.

Thanks for the suggestion applied this suggestion and its working fine.

Creating a Temptable called #DynamicMaster

This issue happening in prod environment ,but not in staging and local development environment, is there any setting for clearing tempdb cache of sql server

Yes the Dynamic Table is created and processed with required data and returned

ya same data on both environments

while i execute the Procedure A which internally calls procedure C in which a dynamic table called DynamicMaster is generated with a dynamic column added to  it Called Distance the...