|
|
Posted by Daniel Manes on 02/17/06 20:23
I've been trying to copy tables from a linked server to a SQL Server
Express database. Express seems to have no direct/automatic way to do
it, so I've been looking into doing this by hand (i.e., with a T-SQL
procedure).
I've discovered some system stored procedures that seem relevant (like
sp_tables_ex and sp_columns_ex). But they're procedures, not
table-valued functions, so I'm not sure if I can actually do anything
with the data they return.
If I could get to the data, I thought maybe I could use a cusor and a
while loop to recreate the tables in Express.
Is this crazy?
Really could use some advice on this.
Thanks,
-Dan
Navigation:
[Reply to this message]
|