(kh******@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,
es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx