The syntax of the command is
DBCC writepage ({ dbid, 'dbname' }, fileid, pageid, offset, length, data)
what I only know is that this command can change the structure of data page,it replace data in data page,
and it may cause exception when i scan the table after executed dbcc writepage command
the error message is:Could not continue scan with NOLOCK due to data movement
I want to know what is the purpose that sqlserver provide "DBCC WRITEPAGE" command and how to use it.
could anyone give me a particular introduction to dbcc wirtepage command?
I can't find any information about it in internet.
Thanks.
It's an undocument command that you should only use when you know what you are doing, as you can very easily corrupt the database when you use it incorrectly.Thanks,
No comments:
Post a Comment