Post reply

How to track the object name changes?

  • July 15, 2005 at 6:39 am

    #66458

    Hi There,

    Can any one pelase help me to find out a way to track the Object's name changes?

    For example:

    If a view is created initially with a name v1 as follows:

    CREATE VIEW v1

    AS

    select * from Invoices

    from QueryAnalyzer. So, the physical name of the object is v1.

    Later using Enterprise Manager, if the object's name is renamed to v2 thereafter the view will be referred with the new name v2 by all the dependencies.(This dependencies will be maintained by the sysdepends system table. Even after object is renamed, the Object id remains the same, hence the dependency will still point to v2)

    Is there any way to query out the Object name changes/history?

    I faced this problem while migrating SQL objects from one instance to an other one ?

    Thanks & Regards,

    Geeth Ramesh.

  • July 15, 2005 at 6:53 am

    #574769

    You have to make some sort of audit tool that takes snapshots of the sysobjects table and extract that info yourself. There's no history kept for the objects.

Viewing 2 posts - 1 through 1 (of 1 total)

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