How to Use create table to create a table on the remote SQL2000 database server (known IP address, account)

Solution:
1. query analyzer to log on to the remote server to create a table

2. the logon method remains unchanged. log on to the local SQL Server directly, and then use the following method to create a table on the linked server.

Create a connection method such as (use the linked server to execute the stored procedure on the remote database)

Select * From openquery (srv_lnk, 'set implicit_transactions off;
-- Table creation statement
Create Table tempdb. DBO. Tb (a int)
; Select status = @ error -- returns whether the table is successfully created.
')
Note:
Srv_lnk ------- Link