Try this

SELECT convert(varchar, convert(datetime, Date), 111)

+ ' ' + substring(Time, 1, 2)

+ ':' + substring(Time, 3, 2)

From TableName

If you need more examples on data conversions...

Can you post the schema of the table and few records in it.

Do this ...Select 1.0/6

If you are a sysadmin you dont need any extra permissions but if you are not you need View Server State permission.

Thanks for bringing that up because I dont see that in our process. I am going to...

The message in the log wasn't that the page had been repaired. It said 'requesting page from mirror'. Hence it's starting a repair. No guarantee how long before it's finished....

It does have 980 files. Hence we run CheckDB on tables periodcially over the week.

As for auto repair, not sure why. Could be that the checkDB was the first indication...

Thanks for the suggestions Gail.

The other possibility, which is terrifying, is that the backup used to create the mirror already had the damage in, so the mirror's page is also...

I saw the following message in the logs indicating DB Mirroring did try to fix the page. May be it can only fix certain types of pages.

Database mirroring successfully repaired...

Thanks Gail. We do have Enterprise Edition so Page Restore does make sense. We have never done this in our company. Can you please share any good resources that talk...

We cannot use RESTRICTED_USER , database has to be in single user mode to run dbcc checkdb with...

Thanks Ninja. We are hoping that since it is 4 consistency errors it will not affect a lot of records. This is a huge database (around 3 TB) so we...

This is one of the messages when I ran CheckTable

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (TableName).

Since it is just 4 consistency errors...

I even tried to pause the mirror and that didnt work. I am trying to find another way to do that without breaking the mirror. This is a huge database...

Try using DatePart function to seperate the Month and Year from date column.