jwiesman (9/22/2016)
Phil,Hi.
First off, thank-you for helping.
Your 2nd to the last reply got truncated..... There was no link... it was just:
You might find this helpful.
------------------------------------------------------------------------
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.
When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
I tried your suggestion:
EXEC sys.sp_spaceused @oneresultset = 1
Unfortunately, I still get the same error message.
I'm using Visual Studio 2010 against a 2012 SQL Server instance
I reviewed your posts. I do not see a link (or any link for that matter) with regards to @oneresultset
John
OK, try this instead. Worked for me on 2016 anyway.
EXEC sys.sp_spaceused @oneresultset = 1
with result sets
(
(
database_name sysname,
database_size varchar(50),
unallocated_space varchar(50),
reserved varchar(50),
data varchar(50),
index_size varchar(50),
unused varchar(50)
)
)
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.