BUG: Cannot Use Cut, Copy, and Paste to Transfer Uniqueidentifier Column Values (277882)


The information in this article applies to:

  • Microsoft SQL Server 7.0 Service Pack 2
  • Microsoft SQL Server 7.0 Service Pack 3
This article was previously published under Q277882
BUG #: 58237 (SQLBUG_70)

SYMPTOMS

In SQL Enterprise Manager, when you attempt to use the Cut, Copy, and Paste commands to transfer values from a uniqueidentifier column in one table to a uniqueidentifier column in another table, or to the same column in the same table, you may receive the following error:
The value you entered is not consistent with the datatype or the length of the column.

WORKAROUND

There are two ways to work around this problem:
  • Use T-SQL INSERT or UPDATE statements.
  • Use SQL Server 2000 Enterprise Manager to transfer uniqueidentifier values for tables in SQL Server 7.0.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

To reproduce this problem on SQL Server 7.0 SP2, follow these steps:
  1. Create a table by using the following code:
    USE pubs
CREATE TABLE test(col1 int,col2 uniqueidentifier default newid())
INSERT INTO test(col1) VALUES(1)
INSERT INTO test(col1) VALUES(2)
  2. Open SQL Enterprise Manager.
  3. Right-click table test, click Open Table, and then click Return All Rows.
  4. Highlight the col2 value in the first row. Copy the system-generated value in the first row under column 1, paste it into an empty row, and then press ENTER.
NOTE: The problem can be reproduced only when using SQL Server 7.0 Client tools with SP2 or SP3.
Modification Type:MajorLast Reviewed:6/25/2004
Keywords:kbbug kbpending KB277882
©2004 Microsoft Corporation. All rights reserved.