Please refer below link

http://www.sqlservergeeks.com/blogs/riteshmedhe/sql-server-bi/405/sql-getting-rid-of-unused-space-in-table

@raj thats excellent and thank you so much for posting on this article 🙂

Hi Srinivas,

I am not sure if this will be of any help. but you can check this article of mine.

http://www.sqlservercentral.com/articles/Automating+SQL+Server+Health+Checks/68910/

Hi Stanley,

I am a DBA and this will surely make my life easy. thanks a lot for sharing this information.

Lovely piece of work..

is it possible to drill down to object level, say particular user have xyz right on abc object. eg: user1 have execute permission on procedure1?

Thanks in advance!!!!!!

just a small thing make use of table variable instaed of temp tables. or local temp table

cool

lovely article thx

very helpful article. thx

nplace, thx this is awesome...

Vote Of Thanks!!!!!!!

Thanks for all the posts. I really appretiate and I hope that this article will be helpful for DBAs and make their life little easy.

Special thanks (For making...

Hey kinzent, I agree with you, its really dangerous allowing exection of any command line from SQL and thats the reason why SS2005 have disabled cmdshell by default. However its...

its really difficult to estimate exact execution time. it depends on lots of factors cpu, memory, number of jobs, databases... however if it is taking more than 30 seconds then...

@chava.sreekanth: try this script, should work.... i read post where the issues was fixed by reducing the daterange for section 5. Section 5 returns backup history for 1 month. this...