daily pastebin goal
4%
SHARE
TWEET

Untitled

a guest May 16th, 2018 83 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Message 8997)  Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. [SQLSTATE 01000] (Message 8997)  Service Broker Msg 9667, State 1: Services analyzed: 3. [SQLSTATE 01000] (Message 8997)  Service Broker Msg 9668, State 1: Service Queues analyzed: 3. [SQLSTATE 01000] (Message 8997)  Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0. [SQLSTATE 01000] (Message 8997)  Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0. [SQLSTATE 01000] (Message 8997)  Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0. [SQLSTATE 01000] (Message 8997)  Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0. [SQLSTATE 01000] (Message 8997)  DBCC results for 'sys.sysrscols'. [SQLSTATE 01000] (Message 2536)  There are 1295 rows in 18 pages for object "sys.sysrscols". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysrowsets'. [SQLSTATE 01000] (Message 2536)  There are 170 rows in 2 pages for object "sys.sysrowsets". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysclones'. [SQLSTATE 01000] (Message 2536)  There are 0 rows in 0 pages for object "sys.sysclones". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysallocunits'. [SQLSTATE 01000] (Message 2536)  There are 201 rows in 3 pages for object "sys.sysallocunits". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysfiles1'. [SQLSTATE 01000] (Message 2536)  There are 2 rows in 1 pages for object "sys.sysfiles1". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysseobjvalues'. [SQLSTATE 01000] (Message 2536)  There are 0 rows in 0 pages for object "sys.sysseobjvalues". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysmatrixages'. [SQLSTATE 01000] (Message 2536)  There are 0 rows in 0 pages for object "sys.sysmatrixages". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.syspriorities'. [SQLSTATE 01000] (Message 2536)  There are 0 rows in 0 pages for object "sys.syspriorities". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysdbfrag'. [SQLSTATE 01000] (Message 2536)  There are 13 rows in 1 pages for object "sys.sysdbfrag". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysfgfrag'. [SQLSTATE 01000] (Message 2536)  There are 0 rows in 0 pages for object "sys.sysfgfrag". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysdbfiles'. [SQLSTATE 01000] (Message 2536)  There are 2 rows in 1 pages for object "sys.sysdbfiles". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.syspru'. [SQLSTATE 01000] (Message 2536)  There are 13 rows in 1 pages for object "sys.syspru". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysbrickfiles'. [SQLSTATE 01000] (Message 2536)  There are 31 rows in 4 pages for object "sys.sysbrickfiles". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysphfg'. [SQLSTATE 01000] (Message 2536)  There are 1 rows in 1 pages for object "sys.sysphfg". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysprufiles'. [SQLSTATE 01000] (Message 2536)  There are 2 rows in 1 pages for object "sys.sysprufiles". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysftinds'. [SQLSTATE 01000] (Message 2536)  There are 0 rows in 0 pages for object "sys.sysftinds". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysowners'. [SQLSTATE 01000] (Message 2536)  There are 16 rows in 1 pages for object "sys.sysowners". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysdbreg'. [SQLSTATE 01000] (Message 2536)  There are 13 rows in 1 pages for object "sys.sysdbreg". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysprivs'. [SQLSTATE 01000] (Message 2536)  There are 2363 rows in 17 pages for object "sys.sysprivs". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysschobjs'. [SQLSTATE 01000] (Message 2536)  There a...  The step failed.
  2.    
  3. declare @DB_Name varchar(255),
  4.     @sql nvarchar(max)
  5.  
  6.     declare c cursor local for
  7.  
  8.     SELECT name FROM master.dbo.sysdatabases
  9.  
  10.     open c
  11.     fetch from c into @DB_Name
  12.  
  13.     While @@FETCH_STATUS = 0
  14.     begin
  15.  
  16.     set @sql = 'Use ' + @DB_Name + ' DBCC CheckDB'
  17.  
  18.     print @sql
  19.     exec sp_executesql @sql
  20.  
  21.     fetch next from c into @DB_Name
  22.  
  23.     end
  24.  
  25.     close c
  26.     deallocate c
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top