Hi - Was wondering if there a program or Script or something that I can run against one of my DB's to see if it is corrupted - I don't want to fix it just yet but just want to find out if it is corrupt.
Thanks
DBCC CHECKDB:
There are multiple options to tweak its performance and depth of checking. There are also smaller CHECK options (CHECKTABLE, CHECKALLOC, etc.) that can be run independently if you need to minimize impact.
Suggest reading some of Paul Randal's articles first if you're new to DBCC CHECKDB: