Is it possible to create a Foreign Key from BIGINT to NUMERIC(19,0) in SQL Server 2005?
Posted on 2008-06-19
I have two tables.
TEST_KEY numeric(19,0) IDENTITY,
TEST_KEY BIGINT NOT NULL
I am trying to use SQL Analysis Server to create a relationship between those two tables but I get an error that the data types are different. Is there a setting to let SQL Server know that they are similar and to allow the relationship to be built?