0
votes
2answers
371 views

SQL: Find Last Integrity Check Date

Is there a way to check when was the last integrity check run for each database? I know when the service startup it checks for these values, so they exist, and they are probably writen on the ...
0
votes
1answer
257 views

Why does DBCC CHECKTABLE report errors on non-existent pages?

When I run DBCC CHECKDB, I get a slew of error messages like this: Table error: object ID 2020918271, index ID 1, partition ID 72057594196590592, alloc unit ID 72057594190233600 (type In-row ...
0
votes
1answer
471 views

Best way to add a new non-nullable column?

I'm a web developer, with admin rights on our SQLServer, and I need to add a non-nullable integer column (foreign key) to an existing table. I'm looking for the best way to create this column and ...