Re: How to programmatically refresh linked tables

On 26 Apr 2007 22:15:59 -0700, bubbles <bubbles.one@xxxxxxxxxxx> wrote:
Big snip
No, users will not be expected to modify the design.

The tables will be added dynamically at the SQL Server end when new
products
comes into existance -- this product info is pulled from another
remote server
periodically. When new products come into existance in the remote
server,
a TSQL statement will create the new tables.

That is why I am trying to find a way to link these tables
programatically, without
user intervention.

Do the new tables have the same number of fields with the same names and in the
same sequence as the existing tables?
Are the names of the new tables predictable?

Chuck
--
.

Relevant Pages