Creating a table from one server to another

I have two server Server1 and Server2
I need to create a table in Server2 from Server1
I do have a linked server
please advice how this can be done
Thanks
samay
The quickest and easiest way is to use DTS.
In SEM, expand your database node.
Right-click on the database you wish to import the table to. Choose
All-Tasks, Import Data.
Follow the wizard through. You can import just the table structure, or both
the structure and the data.
Note: If you just want the structure, using the Query Analyzer, find the
table in Server1, right-click and have it create the CREATE statement for
you. Copy and paste that statement in the query analyzer (choose the
appropriate database and server *before* you run the script.
Rick
RICHARD SAWTELL
"KritiVerma@.hotmail.com" <KritiVermahotmailcom@.discussions.microsoft.com>
wrote in message news:BC2D8A71-94FE-41CC-A96A-AC6B8A040595@.microsoft.com...
> I have two server Server1 and Server2
> I need to create a table in Server2 from Server1
> I do have a linked server
> please advice how this can be done
> Thanks
> samay
>
|||Number of options available..... I'd use DTS
"KritiVerma@.hotmail.com" <KritiVermahotmailcom@.discussions.microsoft.com>
wrote in message news:BC2D8A71-94FE-41CC-A96A-AC6B8A040595@.microsoft.com...
> I have two server Server1 and Server2
> I need to create a table in Server2 from Server1
> I do have a linked server
> please advice how this can be done
> Thanks
> samay
>
|||I am using the Script to backup data. and I was wondering if instead of 1st careting a table in Server2 and then the calculated script if i can create atable + insert the required records in it in one script.Is this posiible
PLease advice
2....another Question
Right now I am creating a tabl in server 2 and updating it from Server 1
and when i try to Update the Server2 Table A it gives me this Error
Could not open table "LinkedServer."TABLEA"' from OLE DB provider 'SQLOLEDB'. The provider could not support a row lookup position. The provider indicates that conflicts occurred with other properties or requirements.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IOpenRowset::OpenRowset returned 0x80040e21: [PROPID=DBPROP_BOOKMARKS VALUE=True STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_COMMANDTIMEOUT VALUE=600 STATUS=DBPROPSTATUS_OK], [PROPID=Unknown PropertyID
VALUE=True STATUS=DBPROPSTATUS_OK], [PROPID=DBPROP_IRowsetLocate VALUE=True STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_IRowsetChange VA...
Please advice
"Simon" wrote:

> Number of options available..... I'd use DTS
> "KritiVerma@.hotmail.com" <KritiVermahotmailcom@.discussions.microsoft.com>
> wrote in message news:BC2D8A71-94FE-41CC-A96A-AC6B8A040595@.microsoft.com...
>
>
|||Yes, if you want to do it that way. Build the empty table and then refer
to the populated table
from the linked server.
"KritiVerma@.hotmail.com" <KritiVermahotmailcom@.discussions.microsoft.com>
wrote in message news:739516F9-E466-4DDE-8866-AD73BBB5E29D@.microsoft.com...
> I am using the Script to backup data. and I was wondering if instead of
1st careting a table in Server2 and then the calculated script if i can
create atable + insert the required records in it in one script.Is this
posiible
> PLease advice
> 2....another Question
> Right now I am creating a tabl in server 2 and updating it from Server 1
> and when i try to Update the Server2 Table A it gives me this Error
> Could not open table "LinkedServer."TABLEA"' from OLE DB provider
'SQLOLEDB'. The provider could not support a row lookup position. The
provider indicates that conflicts occurred with other properties or
requirements.
> [OLE/DB provider returned message: Multiple-step OLE DB operation
generated errors. Check each OLE DB status value, if available. No work was
done.]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IOpenRowset::OpenRowset
returned 0x80040e21: [PROPID=DBPROP_BOOKMARKS VALUE=True
STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_COMMANDTIMEOUT VALUE=600
STATUS=DBPROPSTATUS_OK], [PROPID=Unknown PropertyID VALUE=True
STATUS=DBPROPSTATUS_OK], [PROPID=DBPROP_IRowsetLocate VALUE=True
STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_IRowsetChange VA...[vbcol=seagreen]
> Please advice
> "Simon" wrote:
<KritiVermahotmailcom@.discussions.microsoft.com> [vbcol=seagreen]
news:BC2D8A71-94FE-41CC-A96A-AC6B8A040595@.microsoft.com...[vbcol=seagreen]