How to run checkdb on all databases ?
Posted by Karthick P.K on July 15, 2010
EXEC sp_MSforeachdb 'DBCC CHECKDB(?)'
Thanks
Karthick P.K
MSSQLWIKI
Karthick P.K on SQL Server
Karthick P.K
Subscribe
Visits
SQLSERVERSCRIBBLES.COM- Integration Services server cannot be configured because there are active operations. Wait until there are no active operations, and then try to configure the server again May 26, 2015
- SQL Server setup fails with “Failed to retrieve data for this request” February 25, 2015
- The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication. October 15, 2014
- Sp_rename fails : Either the parameter @objname is ambiguous or the claimed @objtype (object) is wrong. May 9, 2014
- SSIS package fails with out of memory errors December 3, 2013
- Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID ‘ ‘) online (Error code 5018). November 17, 2013
- SQL Server cluster installation checklist October 30, 2013
- PREEMPTIVE_OS_AUTHORIZATIONOPS waits in SQL Server September 26, 2013
- SQL Server Backup compression August 25, 2013
- Types of isolation levels in SQL Server August 16, 2013
- SQL Server database snapshot July 10, 2013
- How to create table with filestream column and Insert data July 9, 2013
- How to enable and configure Filestream in SQL SERVER 2008 / 2012 July 9, 2013
- How to import/Export data in SQL Server July 5, 2013
- Create script for all objects in database with data July 4, 2013
- Steps to enable Alwayson in SQL Server 2012 July 3, 2013
- How to create database mirroring July 1, 2013
- How to create log shipping in SQL Server June 30, 2013
- HOW TO INSTALL SQL Server CLUSTER IN HYPER-V June 28, 2013
- How to create merge replication in SQL Server June 28, 2013
MSSQLWIKI 
Leave a Reply