How to verify integrity or violations in SQL Server database?

Question

I created an application to run in the background to back up my SQL Server database using the class Backup of Microsoft.SqlServer.Management.Smo.

I would like to add to this backup tool something that can verify the integrity of the bank or if it has an error. I know that there is the possibility to do via SQL script and have it executed, but I wish to do it via code, perhaps taking advantage of the use of Smo.

Answer 1

Murilo, I believe that what you are looking for is the Checktables methods, try this: https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.database.checktables.aspx