Conversion from 'uniqueidentifier' to 'int' is not supported on the connected database server

sql-server uniqueidentifier ssms
I'm busy coding picture I'm busy coding · Feb 25, 2013 · Viewed 25.2k times · Source

I'm about to migrate my database from using old membership to the one included in mvc4, which uses int instead of guid.

When changing the type I get following error:

Conversion from int to uniqueidentifier is not supported on the connected database server.

How can I change UserId to int via SQL Server Management Studio?

Answer

Muhamed Shafeeq picture Muhamed Shafeeq · Aug 30, 2013

First Change Data Type to any other supported Type like varbinary or anything. then you can convert from that to what you want.

Related questions

Convert NULL to empty string - Conversion failed when converting from a character string to uniqueidentifier

Using SQL Server 2005 how do I get the below statement or rather the output as i want it to be. SELECT Id 'PatientId', ISNULL(ParentId,'') 'ParentId' FROM Patients ParenId is a uniqueidentifier that allows NULL, but seems that query …

Read More
How to generate and manually insert a uniqueidentifier in sql server?

I'm trying to manually create a new user in my table but impossible to generate a "UniqueIdentifier" type without threw an exception ... Here is my example: DECLARE @id uniqueidentifier SET @id = NEWID() INSERT INTO [dbo].[aspnet_Users] ([ApplicationId] ,[UserId] ,[UserName] ,[…

Read More
Turn off IDENTITY_INSERT for Dataset insert

I am using a dataset to insert data being converted from an older database. The requirement is to maintain the current Order_ID numbers. I've tried using: SET IDENTITY_INSERT orders ON; This works when I'm in SqlServer Management Studio, …

Read More