PowerShell.com
Library » Script Library » SQL Server » CheckDB-MSSQL-UsingADO

CheckDB-MSSQL-UsingADO

Previous | Next | View all files | View Slideshow
posted by Richard Giles
10-06-2008
Downloads: 423
File size: 1.8kB
Views: 1,661
Embed
CheckDB-MSSQL-UsingADO
  1. ## ===================================================================== 
  2. ## Title       : CheckDB-MSSQL-UsingADO 
  3. ## Description : Run a DBCC against specified server instance and database 
  4. ## Author      : Idera 
  5. ## Date        : 9/1/2008 
  6. ## Input       : -serverInstance <server\instance> 
  7. ##               -dbName <database name> 
  8. ##               -verbose  
  9. ##               -debug     
  10. ## Output      :  
  11. ## Usage            : PS> . CheckDB-MSSQL-UsingADO -serverInstance local -dbName master -v -d 
  12. ## Notes            : Adapted from Jakob Bindslet script 
  13. ## Tag            : SQL Server, ADO, CheckDB 
  14. ## Change log  : 
  15. ## ===================================================================== 
  16.  
  17. param 
  18. ( 
  19.    [string]$serverInstance = ".", 
  20.       [string]$dbName = "AdventureWorks", 
  21.     [switch]$verbose, 
  22.     [switch]$debug 
  23. ) 
  24.  
  25. function main() 
  26. { 
  27.     if ($verbose) {$VerbosePreference = "Continue"} 
  28.     if ($debug) {$DebugPreference = "Continue"} 
  29.     CheckDB-MSSQL-UsingADO $serverInstance $dbName 
  30. } 
  31.  
  32. function CheckDB-MSSQL-UsingADO($serverInstance, $dbName) 
  33. { 
  34.     trap [Exception]  
  35.     { 
  36.         write-error $("TRAPPED: " + $_.Exception.Message); 
  37.         continue; 
  38.     } 
  39.  
  40.     $cn = new-object system.data.SqlClient.SqlConnection( ` 
  41.         "Data Source=$serverInstance;Integrated Security=SSPI;Initial Catalog=$dbName"); 
  42.     $ds = new-object System.Data.DataSet "dsCheckDB" 
  43.     $query = "DBCC CHECKDB($dbName) WITH TABLERESULTS" 
  44.     $da = new-object "System.Data.SqlClient.SqlDataAdapter" ($query, $cn) 
  45.     $da.Fill($ds) 
  46.  
  47.     $dtCheckDB = new-object "System.Data.DataTable" "dsCheckDB" 
  48.     $dtCheckDB = $ds.Tables[0] 
  49.     $dtCheckDB | Format-Table -autosize ` 
  50.         -property Error, Level, State, MessageText, ` 
  51.                         RepairLevel, Status, DbId, ObjectId, ` 
  52.                         IndexId, PartitionId, AllocUnitId, File, ` 
  53.                         Page, Slot, RefFile, RefPage, RefSlot, Allocation 
  54. } 
  55.  
  56. main 
Filed under: , ,

Run a DBCC against a specified SQL Server instance and database

Concentrated Tech NSoftware Dell Compellent Sponsored by Idera and Concentrated Tech and NSoftware and Dell Compellent
Copyright 2011 PowerShell.com. All rights reserved.