Microsoft SQL Server 7.0 Administrative Command Line Utilities (Part 2)


Now we continue covering Microsoft SQL Server command line utilities as started in Part 1 of this article. Let’s jump right in …

Replupd – Part of the SQL Server replication subsystem, Replupd is used for
transferring replication parameters from previous versions of SQL Servers (v6.x).

Scm – A utility used to start/stop SQL Server and/or Microsoft Data Engine (MSDE) services from a command prompt or a batch file (similar
to using net start and net stop commands). Note, that the Scm utility can only be used with services installed by SQL Server.

Snapshot – The Replication Snapshot Agent utility configures
and starts a replication Snapshot Agent, which prepares snapshot files
of published tables and stored procedures, stores the files on the Distributor
and records information about the synchronization status in the distribution
database.

Sqlagent – This utility is used for starting the SQL Server Agent service from your operating
system command prompt. sqlagent should be run from the command prompt
only when diagnosing SQL Server Agent issues (SQL Server Agent should normally be run from the SQL Server Service Manager or by using SQL-DMO
methods in an application).

Sqldiag – A tool that can be used for reports generation and collecting diagnostic
information on current database server/Windows NT configuration parameters.
Sqldiag gathers information even if Microsoft SQL Server 7.0
services have stopped. Hardware and software information about operating system
configuration can be saved in the < Windows_NT_Server_NetBIOS_Name
>.txt
file report as generated by Sqldiag. A Sqldiag diagnostic report
contains the following information:



  • A complete dump of all Microsoft SQL Server 7.0 event logs;


  • Registry “keys” information relating to Microsoft SQL Server 7.0;


  • Microsoft SQL Server 7.0 system DLL libraries version information;


  • Output generated by the following SQL Server stored procedures: sp_configure, sp_who,
    sp_lock, sp_helpdb, xp_msver
    and sp_helpextendedproc;


  • Information about all system processes (master..sysprocesses);


  • Information about all user processes and connections (including Input
    buffer SPIDs
    and Dead locks);


  • Information about operating system parameters (including reports about:
    OS version, Video display, Drivers, DMA, Memory, Services, IRQ and ports,
    Devices, Environment
    and Network);


  • Information about the last 100 user queries executed.

Sqlftwiz – A command prompt utility that allows the DBA to execute the Full-Text
Indexing Wizard. The Full-Text Indexing Wizard is used to define
full-text indexing on Microsoft SQL Server text-based columns. The Full-Text
Indexing Wizard also creates or modifies population schedules that determine
when the information stored in the full-text catalog is updated.

Sqlmaint – A maintenance utility that performs a specified
set of tasks as specified by the DBA on one or more databases (for example, backup databases,
update statistics, rebuild indexes, DBCC check, etc.). All database maintenance
activities generate a report that can be sent to a designated text file,
HTML file, or e-mail account.

Sqlservr – A utility used to start, stop, pause, and continue
Microsoft SQL Server from an operating system command prompt.

Textcopy – A utility for copying large arrays of text and binary
data to Text and Image data type fields. This undocumented utility (run
it with the /? option to receive a set of acceptable command line parameters). The example of usage Textcopy command can be found in Pubimage.bat and Pubtext.bat files (both files are located in the %sqlroot%install
folder).

Vswitch – A utility for switching between SQL Server 7.0 and SQL
Server 6.x as the active version of SQL Server. Microsoft SQL Server 7.0
can be installed alongside SQL Server 6.x on the same computer, but only
one version can be active at a time. To switch from one version to the
other, use the Microsoft SQL Server-Switch application on the Start menu
or run Vswitch.exe in the %sqlroot%Binn directory.

The utility does not allow both versions of SQL Server to be run simultaneously,
and it is only intended to be used during the migration phase, not in daily
production. The utility copies the current registry value to either the
MSSQLSERV6.x or 7.0 registry key and then moves the desired
version information (6.x or 7.0) to the MSSQLServer entry. Additionally,
it changes the PATH statement to reflect the Mssql or Mssql7 directory.

Wiztrace – The Index Tuning Wizard workload generator.

Xfragent – A transfer agent that is part of the SQL Server replication
subsystem. Xfragent is used for transferring some or all objects from one database
to another. Transfers can be started immediately or can be  scheduled
to occur either once or on a recurring basis.




See All Articles by Columnist
Alexzander Nepomnjashiy

Alexzander Nepomnjashiy
Alexzander Nepomnjashiy
I am a Microsoft SQL Server Database Designer for Neo-Systems North-West - a security services, consulting, and training company. I have over eight years of experience in the IT field. I am currently working on several projects which involve the deployment of Microsoft Windows NT Server/Microsoft SQL Server within an enterprise business/financial environment. My typical role in these projects includes extending and improving our clients' corporate ERP systems to manage retail sales data, predict market changes and calculate trends for future market situations (DSS, OLAP). Also among my responsibilities are the design and administration of Microsoft SQL Server 7.0/2000 databases. I am available to work on a contract basis for the following types of projects: - Technical authoring, including books, articles, and white papers; - Network and systems design and analysis; - Database and software development and analysis; - Short-term consulting projects. I hope you find these articles useful. If you have any ideas for future articles (in a field of Microsoft SQL Server databases design, administration, performance optimization), or if you have anything to say about the ones below, please do not hesitate to contact me! Feel free to forward these articles to all interested associates. Thank You!

Latest Articles