> 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?

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns971CF1DF5601EYazorman@127.0.0.1...
> (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