"kiran" <kiran.gazz@gmail.com> wrote in message
news:1157536308.281362.318480@d34g2000cwd.googlegroups.com...
> Hi all,
> I have a small problem. I want to create a table Say
> "tab1" from Server A into Server B. I dont want to copy the whole
> table.I just want a "create table" String which is derived from tab1 of
> server A. I want this to be simple.
> Is there any soln.
> Thanks,
> Kiran G
>

Arnie Rowland wrote:
> The simplest method is to use Query Analyzer. In the object Explorer, keep
> expanding until you get down to the table, and then [Right-Click] on the
> table and select [Script Object to file as...], [ CREATE]. (or window, or
> clipboard.)
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
>
> "kiran" <kiran.gazz@gmail.com> wrote in message
> news:1157536308.281362.318480@d34g2000cwd.googlegroups.com...
> > Hi all,
> > I have a small problem. I want to create a table Say
> > "tab1" from Server A into Server B. I dont want to copy the whole
> > table.I just want a "create table" String which is derived from tab1 of
> > server A. I want this to be simple.
> > Is there any soln.
> > Thanks,
> > Kiran G
> >