sql2000常用命令OSQL

广告：

sqlcmd -E

附加数据库

osql -E -Q "sp_attach_db @dbname = N'drdata', @filename1 = N'D:\WD-Acquire\db\db_wdfpd\DrData200.mdf', @filename2 = N'D:\WD-Acquire\db\db_wdfpd\DrData_log200.ldf'"

osql -S servername -U username -P password -Q "sp_attach_single_file_db @dbname = N'MyDatabase', @physname = N'D:\Data\MyDatabase.mdf'"

显示数据库：

osql -S <服务器名> -E -Q "SELECT name FROM master..sysdatabases WHERE name NOT IN ('master', 'model', 'msdb', 'tempdb')"

osql -S <服务器名> -U <用户名> -P <密码> -Q "SELECT name FROM master..sysdatabases WHERE name NOT IN ('master', 'model', 'msdb', 'tempdb')"

广告：