Post reply

schema_ver in sysobjects updated on reboot

  • July 23, 2006 at 10:47 pm

    #169763

    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

    #651118

    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 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply