Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Mar 2, 2004

Microsoft SQL Server 2000 command line utilities (Part 2) - Page 2

By Alexzander Nepomnjashiy

Sqlagent - Sqlagent is used to start the SQL Server Agent service from the operating system command prompt. It should be run manually, from a command prompt, for diagnosing SQL Server Agent purposes only.

The Sqlagent utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

Sqldumper - Sqldumper generates a "dump-on-demand" file for any Microsoft Windows application. For example, Microsoft PSS might ask you to run this program to generate a dump file (a mini-dump file or a full dump file) for debugging an application problem. Sqldumper was first introduced in Microsoft SQL Server 2000 Service Pack 3.

The Sqldumper utility is installed to the \Program Files\Microsoft SQLServer\80\Com directory by default.

Sqldiag - Sqldiag is a utility used for report generation and collection of diagnostic information on database server / operating system configuration parameters. Sqldiag gathers the information, even if Microsoft SQL Server 2000 services are stopped. The report generated by Sqldiag contains the following information:

  • Complete dump of all SQL Server error logs;
  • Registry information, related to SQL Server;
  • SQL Server system dll versions;
  • Output, generated by: 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);
  • Info about the last 100 user's queries.

The Sqldiag utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

Sqlftwiz - Sqlftwiz is a command prompt utility that allows the Full-Text Indexing Wizard to be executed from a command prompt. The Full-Text Indexing Wizard is used to define full-text indexing on Microsoft SQL Server text-based columns.

The Sqlftwiz utility is installed to the \Program Files\Microsoft SQL Server\80\Tools\Binn directory by default.

Sqlmaint - Sqlmaint is a maintenance utility. Sqlmaint performs a set of tasks, specified by the DBA, on one or more databases (for example backup databases, update statistics, rebuild indexes, DBCC check).

The Sqlmaint utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

Sqlmangr - Sqlmangr is the executable for SQL Server Service Manager. It is used to start, pause, stop, and check the state of local and remote SQL Server instances.

The Sqlmangr utility is installed to the \Program Files\Microsoft SQL Server\80\Tools\Binn directory by default.

Sqlservr - Sqlservr is used to start, stop, pause, and resume a Microsoft SQL Server instance from a command prompt. Most often, this utility is used to start SQL Server with a trace flag or temporarily override the default SQL Server startup options.

The Sqlservr utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

Svrnetcn - Svrnetcn is the executable for SQL Server Network Utility. IT is used for configuring and permitting to use (enabling or disabling) a particular network protocol for an existing instance of SQL Server 2000 or MSDE 2000.

Svrnetcn is installed to the \Program Files\Microsoft SQLServer\80\Tools\Binn directory by default.

Textcopy - Textcopy is used for moving large arrays of text and binary data to (or from) text / image data type column(s) / row(s) and operating system files. This is an undocumented utility--(try to run it with /? switch - to receive a set of command line parameters that it accepts). An example of Textcopy usage can be found in Pubimage.bat and Pubtext.bat files, (both files are located in %sqlroot%\install folder).

The Textcopy utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

Vswitch - Vswitch is used for switching between SQL Server 2000 and SQL Server 6.x (6.0, 6.5) default instances. 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 2000 registry key and then moves the desired version information (6.x or 2000) to the MSSQLServer entry. Additionally, it changes the PATH statement to reflect the SQL Server root directory.

The Vswitch utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

Wiztrace - Wiztrace is the executable for the Index Tuning Wizard workload generator. It is used internally by the Index Tuning Wizard.

The Wiztrace utility is installed to the \Program Files\Microsoft SQLServer\80\Tools\Binn directory by default.

Xpadsi - Xpadsi is the SQL Server Active Directory (AD) registration program. A search for additional info (SQL Server Books OnLine, Microsoft Technet, MSDN) did not yield any useful information. It seems that this utility does not require any command line parameters and is used internally by the SQL Server setup program.

The Xpadsi utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

This two-part article has introduced tools hidden in every SQL Server 2000 installation, with the primary focus being an introduction to the SQL Server command line utilities.

» See All Articles by Columnist Alexzander Nepomnjashiy



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date