Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LAdesigner1
Starting Member
1 Post |
 Posted - 2011-06-22 : 23:29:20
|
| I was trying to test an interesting, but elaborate, Stored Procedure: "Check SQL Server database and log file size with this stored procedure" from the following website link:http://searchsqlserver.techtarget.com/tip/Check-SQL-Server-database-and-log-file-size-with-this-stored-procedure.I ran the 7-page code from the downloaded MS Word doc without any problems.Unfortunately, whenever I try to run the following command:USE master;EXEC dbo.sp_SDS;My SQL Server 2008 R2 returns the headers without any populated data. I am new to SQL Server, so I was wondering how best to achieve a populated result set similar to Figure 1, where ALL databases are listed after running the above command. I must be missing something... Any assistance would be greatly appreciated, as the original author, Richard Ding, does not have a valid/current email address.Please advise.Thank you. |
|
|
theboyholty
Posting Yak Master
226 Posts |
Posted - 2011-06-23 : 04:06:43
|
| Dunno mate. It works fine for me. The website does say that if you register then you can access an explanation of how it works so maybe try that.Its a cool proc though, when you get it working.---------------------------------------------------------------------------------http://www.mannyroadend.co.uk The official unofficial website of Bury Football Clubhttp://www.hollowtreewebdesign.co.uk - a web design company in its infancy |
 |
|
|
datosiva
Starting Member
18 Posts |
Posted - 2011-08-29 : 05:30:36
|
| Dear FrenzYes, the sp_sds works fine up to SQL2008 only.For SQL2008R2 its giving the empty value as LAdesigner1 said.Did anyone find the solution for SQL2008R2? Please share with us.Really appreciate.regardsshiva :) |
|
|
|
|
|
|
How does this elaborate Stored Procedure work?