July 23, 2006 at 10:47 pm
Hi.
I have done a google, but have come back empty handed, so I'd tought I'd turn to you guys to help me out on this one.
I have a SQL SERVER 2000 - 8.00.923, with some 20 databases on it. The problem is that every time we reboot this server, schema_ver in sysobjects is updated on every table in every database on the whole server. Again, this only applies to the tables.
This feature is something I would like to get rid of as we are running an audit report. Does anyone have any idea where to look?
Regards,
Martin
July 24, 2006 at 9:54 am
That is probably not the only time! If you use sp_recompile, it, via the DBCC LockObjectSchema() function, will update both sysobjects.base_schema_version and sysobjects.schema_ver. It wouldn't surprise me that it also occurs on other occassions.
I don't know if there is a way to defeat that behavior but would suggest using something other than sysobject's version data.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply