Posted by Erland Sommarskog on 11/29/05 00:48

(kharless@qwest.net) writes:
> If I use a "select into" to clone a table, all attributes are created
> correctly, however, if I use the same statement across a linked server,
> my identity column loses its IDENTITY specification.
>
> Is this a known issue or basic functionality of using "select into"
> with linked servers?

I don't know if it's documented, but it makes sense. With a linked table,
SQL Server has knowledge about metadata in a more generic format. That
linked server could be something radically different from SQL Server,
for instance Oracle.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL errors, trapping in Server Agent
• Prev in forum: Re: Format() Function in MS SQL
• Thread view: Re: Select into / Linked Server / Missing IDENTITY attribute

[Reply to this message]