Feedback:

Database GUID

How about a miscellaneous SQL scalar function DATABASEID() with the same parameters as NEWIDSTRING() that returns a read-only GUID stored in the .ADD file upon creation or restore. Against a free table connection, NULL would be appropriate.

This would facilitate identification of database replicas.

A database restore should always generate a new GUID to avoid creating indistinguishable replicas, although an optional restore parameter to prevent a new GUID might be appropriate. Of course a database could be copied, but this is difficult to detect and probably would not be used to create a new replica.

1 vote
Vote 0 votes Vote Vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service

    You'll receive a confirmation email with a link to create a password (optional).

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Rodd GrahamRodd Graham shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service

      You'll receive a confirmation email with a link to create a password (optional).

      Signed in as (Sign out)
      Submitting...

      Knowledge Base and Helpdesk