Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

UNIQUEIDENTIFIER

Discussion in 'Development' started by abursh, Jul 15, 2015.

  1. abursh

    abursh New Member

    I have MSSQL 2008 installed (Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1)
    In that evironment I have two DB.
    Every DB contains a table with uniqueidentifier column.
    When I tryed using MSSQL MANAGEMENT STUDIO -EDIT TOP 200 ROWS copy in unique column's cell
    value that I found as an example of right value '6F9619FF-8B86-D011-B42D-00C04FC964FF' (I found it here: https://technet.microsoft.com/en-us/library/ms190215(v=sql.105).aspx) in one table I succeed to do it, but in the second table which another DB created in the same MSSQL I got error message about 32 digit limit violation. I can' t understand what 's going on - to my mind I defined 2 columns in those 2 tables absolutuly identically. Pleas, if somebody can explain what's wrong - I will be very grateful
  2. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    You'd have to provide us with the details of how the databases were created, preferably the actual script.

Share This Page