Thank you Gail Shaw and anthony for your quick response....

Thank you Gail Shaw,

Is there any article on that topic , Because as am having less hands on exp on that.

Thank you Gail Shaw....

Hi Mr.Jeff Moden thank you for ur response..

1. &2. PFA..

3.After 26 We inserted 155 rows of data,For that it is taking 30GB..

If I want to check which column is occupying...

Hi Shawn..

If we use this

"select name,modify_date from sys.objects where type='P/U/PK/FK/S/IT' order by modify_date desc"

we will get all the details like creation date,Update date...

Thank you Mr.Sasidhar n Mr.Mahesh..

Thanks a lot....

Thank you Mr.Shawn,

I ll do some RnD and let you know...

Hi Shawn thank you for your response,

In my db we are having around 60 Stored procedures(User defined ) ,in that yesterday some of the developers has updated some SP's ...

Hi Mr.Koen Verbeeck Sorry for the inconvenience ,

I have posted in 2012 but there i didn't get any replies so i just given the Link instead of writing the...

PFA...

And If i change the login type as admin then it is starting and working fine,

But if a user wants to connect the server means whether he can access...

Hi Gianluca Sartori Thank you for your reply..

Pls find the below error msg...

"SQL Server :request failed or the service did not respond in a timely fashion"

@Gail,

I am trying to Execute that particular Table like "select * from XXX" at that time it is taking time(aprx 30min)...

Thank you Mr.Ratheesh....

Thank you Gail for your Response,

Is there any alternate ways for that issue....

Sorry for that Avathar...pls dont mind....:-)

Thank you all for giving valuable Replies...