各位大虾请指教(50分)

1.我有已经建好了一个sql server7的数据库,我要把它复制到另一个SERVER中去请问怎解决?
2.delph中用SQL语句怎样建一个含有日期型字段的表；

tbatchmove?

2: Query1.SQL.Add('create table 表名 (字段名 Date)')';

将数据库文件拷贝出来，用SQL SERVER 的命令重建数据库。

使用Dump与Load.或者使用Replication.呵呵，Ms SQL我不熟的说。

把*.mdf和*.ldf
拷到另一个Server上

然后运行系统存储过程
sp_attach_db

语法
sp_attach_db [@dbname =] 'dbname',
[@filename1 =] 'filename_n' [,...16]

Arguments
[@dbname =] 'dbname'
Is the name of the database to be attached to the server. The name must be unique. dbname is sysname, with a default of NULL.
[@filename1 =] 'filename_n'
Is the physical name, including path, of a database file. filename_n is nvarchar(260), with a default of NULL. There can be up to 16 file names specified. The parameter names start at @filename1 and increment to @filename16. The file name list must include at least the primary file, which contains the system tables that point to other files in the database. The list must also include any files that were moved after the database was detached.
Return Code Values
0 (success) or 1 (failure)

时间太久，强制结束。 wjiachun