August 22, 2017 at 6:56 am
Does anyone have a reference to the columns (and preferably datatypes) in the output of the different versions - or at least 2008R2 upwards?
ta
Andrew
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
August 22, 2017 at 7:18 am
Not sure what you're asking for. What columns? Are you referring to system db tables? If so, which ones? Or, stored procedures? Please help us help you. 🙂
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 22, 2017 at 7:20 am
Wow! I need to not post until I've had more coffee!!!
Sorry about that!! I now see what you're asking for--it's in the title of your post. UGH! More coffee!!!
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 22, 2017 at 7:27 am
Okay...now I've had more coffee. The answer can be found here: https://www.mssqltips.com/sqlservertip/2325/capture-and-store-sql-server-database-integrity-history-using-dbcc-checkdb/
It shows the data types of the returned fields in DBCC CHECKDB WITH TABLERESULTS when creating a table to port those results into. I executed the dbcc command in SQL 2014, and the data columns are the same as in the above article, which was done in SQL 2008.
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 22, 2017 at 7:52 am
For the different versions (since columns changed) - this article has the columns for versions before 2012 and the later script has the changes for SQL Server 2012 and above:
DBCC CheckDB with queryable result
Sue
August 31, 2017 at 6:58 am
Thanks folks, your help is greatly appreciated
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply