First, thank the moderator.
The following are the found command-line programs that can be used:
Directory of C:\Program Files\Microsoft SQL Server\80\Tools\Binn
uncol.exe odbccmpt.exe cdw.exe itwiz.exe wiztrace.exe
profiler.exe isqlw.exe dtsrun.exe sqlftwiz.exe dcomscm.exe
osql.exe bcp.exe isql.exe dtswiz.exe sqlmangr.exe
scm.exe rebuildm.exe cnfgsvr.exe svrnetcn.exe dtsrunui.exe(=dtsrun.exe)
sqladhlp.exe
21 File(s) 2,299,448 bytes
0 Dir(s) 8,476,901,376 bytes free
==================================================
Usage: odbccmpt <name of the executable file>
Only one option per ODBCCMPT execution allowed.
Examples how to enter compatibility flag:
odbccmpt APPLICATIONX /T
odbccmpt APPLICATIONX /v:6
Example to remove compatibility flag:
odbccmpt APPLICATIONX /T /d
==================================================
Usage: itwiz -D database-name {-i workload-file | -t workload-table-name} -o script-file-name
==================================================
Usage: dtsrun /option ] ...
Options ("/?" will display this screen; "-" can be used instead of "/"):
Package retrieval:
/~S server name
/~U username
/~P password
/E <Use trusted connection, do not use /U /P>
/~N package name
/~M package password
/~G package Guid string
/~V package version Guid string
/~F structured storage UNC file name (if /S is also specified, it will be overwritten)
/~R knowledge base database name <If blank, use default value; load package from knowledge base database>
Package operation (override storage package settings):
/~A global variable name: typeid=value <Can reference the entire string (including name: typeid)>
/~L log file name
/~W Write completion status to Windows event log <True or False>
DTSRun operation (execute package by default):
/!X <Do not execute; retrieve package to /F file name>
/!D <Do not execute; remove package from SQL Server (cannot be removed from storage file)>
/!Y <Do not execute; output encrypted command line>
/!C <Copy command line to Windows clipboard (can be used with /!Y and /!X)>
Note:
~ is optional; if present, the parameter is hexadecimal text (0x313233...) composed of encrypted values
The blank area between command switches and values is optional
The blank area embedded between each value must be enclosed in double quotes
If an option is specified multiple times, the last one takes effect (unless /A is specified multiple times)
==================================================
sqlfwiz.exe
n=Use Windows authentication
s=Server name
u=Username
p=Password
d=Database name
==================================================
Usage: osql
disable commands ]
<EOF> batch
Automatic console width adjustment
Wide messages
Default error level is — 1 vs 1
==================================================Usage: bcp {dbtable | query} {in | out | queryout | format} datafile
==================================================isql: unknown option ?
usage: isql
<EOF> batch processing
Auto console width scaling
Wide messages
default errorlevel is -1 vs 1
==================================================sqladhlp -i to install the service with optional decimal Locale ID, default 1033
sqladhlp -r to remove the service
============================================
房东说：这娃是个好孩子！
