Microsoft KB Archive/277882

= BUG: Cannot Use Cut, Copy, and Paste to Transfer Uniqueidentifier Column Values =

Article ID: 277882

Article Last Modified on 6/25/2004

-

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:   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)  Open SQL Enterprise Manager. Right-click table test, click Open Table, and then click Return All Rows. 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.

Additional query words: Identity Column, Cut and Paste, cut-and-paste, Enterprise Manager, Unique Identifier

Keywords: kbbug kbpending KB277882

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.