I created a local fn and it works great. TY!
>>I am migrating data from 1 database to another with a different schema altogether and need to designate identity columns in the original. If I am in the new database and issue the following from a stored procedure where northwind is the original..
>>
>> select o.name , c.name AS [idcolumn]
>> from northwind..sysobjects o join northwind..syscolumns c
>> on o.id = c.id
>> and COLUMNPROPERTY(o.id, c.name, 'IsIdentity') = 1
>>
>>I get nothing, because apparently the COLUMNPROPERTY is bound to the local database. Is there a way to "tell" the system to use the northwind COLUMNPROPERTY?
>>
>>I know I can just issue a USE NORTHWIND before the query and then switch back if I use a standard script, but I would like to keep it in a procedure file.
>>
>>TIA
>
>You could create a user-defined function on the Northwind DB to get the value, then call the UDF while in your other DB. That wouldn't be too complex.
>
>The only other way I could think of would be to check the syscolumns table on the Northwind DB, but a UDF would be much easier to deal with.