Undocumented SQL Server 2017 Database Engine Stored Procedures SQL Server 2017 supports the following useful undocumented database engine stored procedures: sp_bcp_dbcmptlevel sp_objectfilegroup sp_MSforeachdb sp_MSforeachtable sp_MSindexspace sp_MStablespace sp_bcp_dbcmptlevel The sp_bcp_dbcmptlevel stored procedure is used to get the database compatibility level for the specified database. Syntax sp_bcp_dbcmptlevel [ @dbname = ] ‘dbname’ Arguments [ @dbname = ] ‘dbname’ The database name to...
Tag: sp_MSindexspace
Useful Undocumented SQL Server 2016 Stored Procedures (Part 1)
Useful Undocumented SQL Server 2016 Stored Procedures (Part 1) SQL Server 2016 supports the following useful undocumented stored procedures: sp_MSforeachdb sp_MSforeachtable sp_MSindexspace sp_MStablespace sp_readerrorlog sp_MSforeachdb The sp_MSforeachdb database engine stored procedure is used to perform the same actions for all databases. Sometimes, you need to perform the same actions for all databases. You can create cursor for this purpose, or...
Six Undocumented SQL Server 2014 Database Engine Stored Procedures
Six Undocumented SQL Server 2014 Database Engine Stored Procedures SQL Server 2014 supports the following useful undocumented database engine stored procedures: sp_bcp_dbcmptlevel sp_MSforeachdb sp_MSforeachtable sp_MSindexspace sp_MStablespace sp_objectfilegroup sp_bcp_dbcmptlevel The sp_bcp_dbcmptlevel database engine stored procedure is used to get the database compatibility level for the specified database. Syntax sp_bcp_dbcmptlevel [ @dbname = ] ‘dbname’ Arguments [ @dbname = ] ‘dbname’ The […]