Post reply

alter db_id

  • October 6, 2008 at 12:31 am

    #213704

    Hi,

    can you alter the database ids of a database? I am getting an issue with replaying a trace on a test server and someone suggested to make the database id the same as the machine I got the trace from

    error is

    Replay Internal ErrorFailed to set proper user name for the connection

  • October 6, 2008 at 7:10 am

    #881076

    No.

    You can detache and reattach the DB and it may get a different database ID, but no way to set which one it gets.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 7, 2008 at 7:36 am

    #881636

    You could save your trace to a table and then update the db_id column in the table. Then open up the trace table in profiler and replay your trace on your test server.

    Travis

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

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