Syntax error or access violation when using dbcc checkdb.

[Guest_imported]

When im trying to make a databaserepair in query analyser like this:

dbcc checkdb ('W3ATamroMedLab' {REPAIR_ALLOW_DATA_LOSS})

I get an error message:

[Microsoft][ODBC SQL Server Driver]Syntax error or access violation

What am i doin wrong?

 

[tlbroadbent]

Remove the braces {} around the option.

dbcc checkdb ('W3ATamroMedLab' REPAIR_ALLOW_DATA_LOSS)
Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes