Using MS SQL Server 2000 I'm trying to create a new table that will contain all table and fields from another table on a Linked Server.
CREATE TABLE INT_USER AS(select * from interaction.interaction.dbo.INT_USER);
I get the following error message:
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'AS'.
I can just run the select statement and return records.
Thanks for your help.