Sqlserver 2016 Better sp_spaceUsed

SQLServer分享 2021-04-29

480

When running sp_spaceused for years, I have gotten results like this:

This gives me two result sets, which are hard to manage.

On my new SQL Server 2016 instance, how can I get all of this data into a single result set in the easiest way possible?

Use the @oneresultset parameter set to 1

The sp_spaceused procedure has a parameter, @oneresultset, which will return a single result set when set to 1.

Ref: Sp_spaceused - https://msdn.microsoft.com/en-us/library/ms188776.aspx

文章转载自SQLServer分享，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。