Sunday, September 21, 2008

List of all builds and patches after SQL2K5 SP2

http://support.microsoft.com/kb/937137/

Wednesday, August 13, 2008

How to clean SQL Server cache?

DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS

How to recompile all stored procedures in any user database?

--Recompile all stored procedures in the pubs database
--Clean up the display
SET NOCOUNT ON

--Determine the id of the pubs database
DECLARE @intDBID INTEGER
SET @intDBID = (SELECT dbid FROM master.dbo.sysdatabases WHERE name = 'pubs')

--Recompile the stored procedures
DBCC FLUSHPROCINDB (@intDBID)

Tuesday, July 29, 2008

Windows Server 2003 Resource Kit Tools

From Windows Resource Kit Help:

AcctInfo.dll
--------------------------------------------------------------------------------
Acctinfo.dll is a dynamic link library that, when registered on a computer, adds a new property page (Additional Account Info) to the user object Properties dialog box in Active Directory Users and Computers. This new property page displays information such as the date when a user's password was last set, the date when a user's password will expire, and the dates and times when a user last logged on and logged off.

ALDB
--------------------------------------------------------------------------------
Active Directory Load Balancing (ADLB) is a command-line tool load that balances the existing connection objects among Active Directory site bridgehead servers and enables replication time schedule staggering on a bridgehead server.

Admx.msi: ADM File Parser
--------------------------------------------------------------------------------
ADM File Parser (AdmX) is a command-line tool that enables an administrator to export Group Policy settings to a tab-delimited text file. The administrator can then use the text produced by ADM File Parser (AdmX) to find changes for the policy settings between different versions of the operating systems. AdmX is only for use with policies based on administrative templates.

Atmarp.exe: Windows ATM ARP Server Information Tool
--------------------------------------------------------------------------------
Windows ATM ARP Server Information Tool (AtmArp) is a command-line tool that assists network administrators and support personnel in troubleshooting the status of the Asynchronous Transfer Mode (ATM) Address Resolution Protocol (ARP)/multicast address resolution service (MARS).

Atmlane.exe: Windows ATM LAN Emulation Client Information
--------------------------------------------------------------------------------
Windows ATM LAN Emulation Client Information (AtmLanE) is a command-line tool that assists administrators in troubleshooting the status of the Asynchronous Transfer Mode (ATM) Local Area Network (LAN) Emulation client

Autoexnt.exe: AutoExNT Service
--------------------------------------------------------------------------------
AutoExNT Service (AutoExNT) is a service that allows you to start a custom batch file named Autoexnt.bat at startup without having to log on to the computer on which it will run.

Cdburn.exe: ISO CD-ROM Burner Tool
--------------------------------------------------------------------------------
ISO CD-ROM Burner Tool (CDBurn) is a command-line tool that allows the user to write (burn) data images from image files located on the hard drive to compact disc (CD) recordable (CD-R) and CD rewritable (CD-RW) media. The data image can be any kind of data, even raw data. This tool can also be used to erase CD-RW media.

Checkrepl.vbs: Check Replication
--------------------------------------------------------------------------------
Check Replication (CheckRepl) is a command-line tool that monitors replication and enumerates the replication topology for a given domain controller.

Chklnks.exe: Link Check Wizard
--------------------------------------------------------------------------------
Link Check Wizard (ChkLnks) is a GUI tool that scans all the link (shortcut) files on a computer to determine whether or not the shortcuts point to existing applications or documents. When Link Check Wizard does not find an associated application or document, the wizard lists that file as a dead link, giving you the option to remove it.

Chknic.exe: Check NIC
--------------------------------------------------------------------------------
Check NIC (ChkNIC) is a command line tool that checks network adapter of the local computer for Network Load Balancing (NLB) compatibility.

Cleanspl.exe: Spooler Cleaner
--------------------------------------------------------------------------------
Spooler Cleaner (CleanSpl) is a GUI tool that restores the print spooler to its original state. It deletes all print jobs, printers, printer drivers, and spool files on a specified local or remote server.

Clearmem.exe: Clear Memory
--------------------------------------------------------------------------------
Clear Memory (ClearMem) is a command-line tool that determines the size of the computer's physical memory, allocates enough data to fill it, and references the data as quickly as possible. ClearMem also accesses files to clear the cache. This reduces, to a minimum, the memory available to other processes. Then, the Clear Memory tool releases the allocated memory to restore normal system functions.

Clusdiag.msi: Cluster Diagnostics and Verification Tool
--------------------------------------------------------------------------------
Cluster Diagnostics and Verification (ClusDiag) is a graphical user interface (GUI) tool that provides administrators with an interface for performing diagnostic tests on a preproduction cluster and a log file interface that aids in troubleshooting cluster failures. ClusDiag can also generate various cluster-related reports from the information gathered during testing.

Clusfileport.dll: Cluster Print File Port
--------------------------------------------------------------------------------
Cluster Print File Port (ClusFilePort) is a tool that adds functionality to clustered print servers. ClusFilePort allows printers within a cluster to print to a file or redirect print jobs.

Clusterrecovery.exe: Server Cluster (MSCS) Recovery Utility
--------------------------------------------------------------------------------
Server Cluster (MSCS) Recovery Utility (ClusterRecovery) is a GUI tool that collects and stores information on a cluster to aid in recovering from the failure of a shared bus.

Cmdhere.inf: Command Here
--------------------------------------------------------------------------------
Command Here (CmdHere) is a shell extension that adds a CMD Prompt Here item to the context menu that is available when you right-click in the Folders (left) pane of Windows Explorer.

Cmgetcer.dll: Connection Manager Certificate Deployment Tool
--------------------------------------------------------------------------------
Connection Manager Certificate Deployment Tool (CMGetCer) is a tool that enables remote users who require secure virtual private network (VPN) access to enroll for certificates. Getting certificates installed on a client computer takes several steps. CMGetCer allows the administrator to automate the process of enrolling for the certificate and then downloading it to the client.

Compress.exe: Compress Files
--------------------------------------------------------------------------------
Compress is a command-line tool that can be used to create compressed copies of one or more files. These compressed files can be expanded with the Expand.exe - File Expansion Tool command.

Confdisk.exe: Disk Configuration Tool
--------------------------------------------------------------------------------
Disk Configuration (ConfDisk) is a command-line tool that helps to recover failed disks in a cluster.

Consume.exe: Memory Consumers Tool
--------------------------------------------------------------------------------
Memory Consumers Tool (Consume) is a command-line tool that is used in conjunction with functional tests and stress tests to verify that software applications can operate properly during low resource conditions. Consume is used to generate these low resource simulations. The Memory Consumers Tool is capable of consuming machine resources such as physical memory, page file memory, disk space, CPU time and kernel pool.

Creatfil.exe: Create File
--------------------------------------------------------------------------------
Create File (CreatFil) is a command-line tool that creates a blank file of a specified size, filled with space characters. This is useful for testing the behavior of tools, applications, and setup programs under conditions of low available memory on a hard disk.

Csccmd.exe: Client Side Caching Command Line Options
--------------------------------------------------------------------------------
Client Side Caching Command Line Options (CSCcmd) is a command-line tool that allows you to manage the client side caching (CSC) database.

Custreasonedit.exe: Custom Reason Editor
--------------------------------------------------------------------------------
Custom Reason Editor (CustReasonEdit) is a command-line and GUI tool that allows users to add, modify, and delete custom reasons used by the Shutdown Event Tracker on the Windows Server 2003 operating system.

Delprof.exe: User Profile Deletion Utility
--------------------------------------------------------------------------------
User Profile Deletion Utility (DelProf) is a command-line tool that can be used to delete user profiles on local and remote computers.

Dh.exe: Display Heap
--------------------------------------------------------------------------------
Display Heap (DH) is a command-line tool that displays information about heap allocation for user-mode processes or pool usage in kernel-mode memory. It also enables you to lock heaps, tags, stacks, and objects. DH allows you to identify the process for which you need to display information, and it allows you to identify the information that you need to display. The tool then writes formatted output to a text file.

Diskraid.exe: RAID Configuration Tool
--------------------------------------------------------------------------------
RAID Configuration (DiskRaid) is a command-line tool that enables configuration and management of redundant array of independent (or inexpensive) disks (RAID) storage subsystems.

Diskuse.exe: User Disk Usage Tool
--------------------------------------------------------------------------------
User Disk Usage Tool (DiskUse) is a command-line tool that scans a single directory, a directory tree, or an entire drive and reports the amount of space used by each user or all users.

Dnsdiag.exe: DNS Resolver Tool
--------------------------------------------------------------------------------
DNS Resolver Tool (DNSDiag) is a command-line tool that allows you to troubleshoot e-mail delivery problems caused by Domain Name System (DNS) issues.

Dumpfsmos.cmd: Dump FSMO Roles
--------------------------------------------------------------------------------
Dump FSMO Roles (DumpFSMOs) is a command-line tool that displays the operations master (also known as flexible single master operations or FSMO) roles target server's domain and forest. Using Dump FSMO Roles you can find the names of the domain controllers that are performing operations master roles.

Dvdburn.exe: ISO DVD Burner Tool
--------------------------------------------------------------------------------
ISO DVD Burner Tool (DVDBurn) is a command-line tool that allows the user to write (burn) Digital Video Disk (DVD) images from image files located on the hard drive to Digital Video Disk (DVD) media.

Empty.exe: Free Working Set Tool
--------------------------------------------------------------------------------
Free Working Set Tool (Empty) is a command-line tool that frees the working set of a specified task or process, making those page frames available for other processes.

Eventcombmt.exe: Event Comb
--------------------------------------------------------------------------------
Event Comb (EventCombMT) is a GUI tool that searches event logs on multiple DCs/Servers and collects EventID records matching the specified criteria.

Fcopy.exe: File Copy Utility for Message Queuing
--------------------------------------------------------------------------------
File Copy Utility for Message Queuing (FCopy) is a command-line tool that compresses files and folders to facilitate copying across local area networks (LANs) and wide area networks (WANs). Because it uses Message Queuing (also known as MSMQ), FCopy continues to copy files even if there are network problems. FCopy includes update options, which copy files only if they have been changed.

FrsFlags: File Replication Service Flags
--------------------------------------------------------------------------------
File Replication Service Flags (FrsFlags) is a command-line tool that enables and disables the Install Override feature of File Replication Service (FRS). It sets and clears the FrsFlags attribute of replica objects in Active Directory.

Getcm.exe: Get Connection Manager
--------------------------------------------------------------------------------
Get Connection Manager (GetCM) is a command-line tool that downloads a new Connection Manager profile from the Web or file share to the local system. GetCM is used in conjunction with the Connection Manager Administration Kit (CMAK).

Gpmonitor.exe: Group Policy Monitor
--------------------------------------------------------------------------------
Group Policy Monitor (GPMon) creates reports when policy settings are refreshed and displays the reports so an administrator can view them. Admnistrators can then check Group Policy object (GPO) stability and monitor policy replication

Gpotool.exe: Group Policy Verification Tool
--------------------------------------------------------------------------------
Group Policy Verification Tool (GPOTool) is a command-line tool that allows administrators to check Group Policy object (GPO) stability and monitor policy replication.

HLScan.exe: Hard Link Display Tool
--------------------------------------------------------------------------------
The Hard Link Display (HLScan) command-line tool displays hard links on an NTFS volume or in specified files or directories of the volume. Hard links are alternate logical names for a physical file.

Ifilttst.exe: IFilter Test Suite
--------------------------------------------------------------------------------
IFilter Test Suite (IFilttst) is a command-line tool that helps validate IFilter implementations for compliance with the IFilter specification. Follow the IFilter specification to create document filters for the Indexing Service in Microsoft products. The IFilter Test must be run on the local computer.

Ifmember.exe: User Membership Tool
--------------------------------------------------------------------------------
User Membership (IfMember) is a command-line tool that checks whether or not the current user is a member of a specified group. It is typically used in Windows logon scripts and other batch files.

Inetesc.adm: Internet Explorer Enhanced Security Configuration
--------------------------------------------------------------------------------
Internet Explorer Enhanced Security Configuration (InetESC) is a Group Policy template that will enhance the security configuration of Microsoft Internet Explorer.

Iniman.exe: Initialization Files Manipulation Tool
--------------------------------------------------------------------------------
Initialization Files Manipulation Tool (IniMan) is a command-line tool that enables you to add, delete, modify, or query sections or keys in an .ini file.

Instcm.exe: Install Connection Manager Profile
--------------------------------------------------------------------------------
Install Connection Manager (InstCM) is a command-line tool that installs the Connection Manager profile that you downloaded by using GetCM. InstCM is used in conjunction with the Connection Manager Administration Kit (CMAK).

Instsrv.exe: Service Installer
--------------------------------------------------------------------------------
Service Installer (InstSrv) is a command-line tool that installs and uninstalls executable services and assigns names to them.

Intfiltr.exe: Interrupt Affinity Filter
--------------------------------------------------------------------------------
Interrupt Affinity Filter (IntFiltr) is a GUI tool that allows you to change the CPU affinity of a device interrupt. Use IntFiltr to specify that a device's interrupt signal processing occurs on a specific set of CPUs. For multiprocessor systems, this can improve system performance.

Kerbtray.exe: Kerberos Tray
--------------------------------------------------------------------------------
Kerberos Tray (KerbTray) is a GUI tool that displays ticket information for a computer running the Microsoft implementation of Kerberos version 5 authentication protocol.

Kernrate.exe: Kernel Profiling Tool
--------------------------------------------------------------------------------
Kernel Profiling Tool (KernRate) is a command-line tool that is a CPU sample profiler. A sample profiler monitors performance and reports back to the user. KernRate reports on kernel and user-mode processes to provide information about CPU activity. Use KernRate to identify which processes are causing a CPU bottleneck.

Klist.exe: Kerberos List
--------------------------------------------------------------------------------
Kerberos List (KList) is a command-line tool that is used to view and delete Kerberos tickets granted to the current logon session. To use KList to view tickets, you must run the tool on a computer that is a member of a Kerberos realm.

Krt.exe: Key Recovery Tool
--------------------------------------------------------------------------------
Key Recovery Tool (KRT) is a GUI tool that enables a key recovery agent (KRA) with appropriate permissions to recover private keys from a Windows Server 2003 certification authority (CA).

Lbridge.cmd: LBridge
--------------------------------------------------------------------------------
LBridge is a batch file that assists in managing file replication between domain controllers in mixed-mode environments.

Linkd.exe: LinkD
--------------------------------------------------------------------------------
LinkD is a command-line tool that links an NTFS file system folder to a target object.

Linkspeed.exe: Link Speed
--------------------------------------------------------------------------------
Link Speed (LinkSpeed) is a command-line tool that displays the speed of the connection between computers on a network.

List.exe: List Text File Tool
--------------------------------------------------------------------------------
List Text File Tool (List) is a command-line tool that displays and searches one or more text files. Unlike other text display tools, List does not read the whole file into memory when you open it. It allows a user to edit a text file in a hexadecimal format. List is useful for displaying text or log files remotely, and for use on servers where administrators are concerned with degradation of system performance.

Lockoutstatus.exe: Account Lockout Status
--------------------------------------------------------------------------------
Account Lockout Status (LockoutStatus) is a combination command-line and GUI tool that displays lockout information about a particular user account

Logtime.exe: LogTime
--------------------------------------------------------------------------------
LogTime is a command-line tool that logs the start or finish of command-line programs from a batch file. This is useful for timing and tracking batch jobs such as mail-address imports.

Lsreport.exe: Terminal Services Licensing Reporter
--------------------------------------------------------------------------------
Terminal Services Licensing Reporter (LsReport) is a command-line tool that creates a report on licenses granted by Terminal Services license servers.

Lsview.exe: Terminal Services License Server Viewer
--------------------------------------------------------------------------------
Terminal Services License Server Viewer (LSView) is a GUI tool that displays information about all available Terminal Services license servers in the current domain and current site of the computer. It is useful for monitoring and logging the status of license servers.

Mcast.exe: Multicast Packet Tool
--------------------------------------------------------------------------------
Multicast Packet Tool (Mcast) is a command-line tool that can be used to send multicast packets or to listen for packets being sent to a multicast group address. Mcast is useful for testing multicast connectivity between computers on your network.

Memmonitor.exe: Memory Monitor
--------------------------------------------------------------------------------
Memory Monitor (MemMonitor) is a command-line tool that monitors the memory a process uses, and runs the process through a debugger when a given threshold is reached.

Memtriage.exe: Resource Leak Triage Tool
--------------------------------------------------------------------------------
Resource Leak Triage Tool (MemTriage) is a command-line tool that detects a possible resource leak on a running system.

Mibcc.exe: SNMP MIB Compiler
--------------------------------------------------------------------------------
SNMP MIB Compiler (MIBCC) is a command-line tool that compiles Simple Network Management Protocol (SNMP) Management Information Base (MIB) files. Use this tool when you want SNMP Management application program interface (API) to use a new or updated MIB.

Moveuser.exe: Move User
--------------------------------------------------------------------------------
Move User (MoveUser) is a command-line tool that changes the security of a user profile so that it can be associated with a different user account. Use MoveUser after moving a user to a different domain so that the user can keep the user profile associated with the original user account.

Mscep.dll: Microsoft Simple Certificate Enrollment Protocol
--------------------------------------------------------------------------------
MSCEP.dll is a dynamic-link library (DLL) that is a Certificate Services add-on Internet Service Application Program Interface (ISAPI).

Nlsinfo.exe: Locale Information Tool
--------------------------------------------------------------------------------
Locale Information Tool (NLSInfo) is a command-line tool that displays information about the locale settings for a computer.

Now.exe: STDOUT Current Date and Time
--------------------------------------------------------------------------------
STDOUT Current Date and Time (Now) is a command-line tool that reads standard input (STDIN) and then displays, on standard output (STDOUT), the current date and time followed by the STDIN.

Ntimer.exe: Windows Program Timer
--------------------------------------------------------------------------------
Windows Program Timer (NTimer) is a command-line tool that measures how long a program runs.

Ntrights.exe
--------------------------------------------------------------------------------
NTRights is a command-line tool that allows you to grant or revoke a right for a user or group of users on a local or remote computer.

Oh.exe: Open Handles
--------------------------------------------------------------------------------
Open Handles (OH) is a command-line tool that shows the handles of all open windows.

Oleview.exe: OLE/COM Object Viewer
--------------------------------------------------------------------------------
OLE/COM Object Viewer (OLEView) is a GUI tool that allows you to manage all Microsoft Component Object Model (COM) classes installed on your computer.

Pathman.exe: Path Manager
--------------------------------------------------------------------------------
Path Manager (PathMan) is a command-line tool that adds or removes components from system or user paths

Permcopy.exe: Share Permissions Copy
--------------------------------------------------------------------------------
Share Permissions Copy (PermCopy) is a command-line tool that copies share-level permissions (Full Control, Read, Change) from one share to another.

Perms.exe: User File Permissions
--------------------------------------------------------------------------------
User File Permissions (Perms) is a command-line tool that displays user access permissions for a file or directory on an NTFS file system volume.

Pfmon.exe: Page Fault Monitor
--------------------------------------------------------------------------------
Page Fault Monitor (PFMon) is a command-line tool that allows a developer or system administrator to monitor page faults that occur while an application is running. PFMon is especially useful for tracing hard and soft page faults because it shows the source of the fault.

Pkiview.msc: PKI Health Tool
--------------------------------------------------------------------------------
PKI Health Tool (PKIView) is an MMC Snap-in component that displays the status of one or more Microsoft Windows Server 2003 Certification Authorities that comprise a public key infrastructure (PKI).

Pmon.exe: Process Resource Monitor
--------------------------------------------------------------------------------
Process Resource Monitor (PMon) is a command-line tool that displays several measures of the CPU and memory use of processes running on the system. The PMon display appears in the command window. It is updated automatically every few seconds and requires no configuration.

Printdriverinfo.exe: Drivers Source
--------------------------------------------------------------------------------
Drivers Source (PrintDriverInfo) is a command-line tool that is used to collect information about printer drivers and is primarily used for support purposes.

Prnadmin.dll: Printer Administration Objects
--------------------------------------------------------------------------------
Printer Administration Objects (PrnAdmin) is a COM-based tool that provides large-scale, noninteractive control of printers, drivers, and ports on local and remote computers.

Qgrep.exe: Qgrep
--------------------------------------------------------------------------------
Qgrep is a command-line tool that is used to search a file or list of files for a specific string or pattern and return the line containing the match. QGrep also allows you to search multiple files and subdirectories.

Qtcp.exe
--------------------------------------------------------------------------------
Qtcp measures end-to-end network service quality. Qtcp sends a sequence of test packets through a network, then reports on the queuing delay experienced by each packet. Packets that do not arrive at the destination are recorded as dropped packets. This tool can be used on either a production network or a controlled test network.

Queryad.vbs: Query Active Directory
--------------------------------------------------------------------------------
Query Active Directory (QueryAD) is a command-line tool that is a Visual Basic script that submits a query to Active Directory.

Rassrvmon.exe: RAS Server Monitor
--------------------------------------------------------------------------------
RAS Server Monitor (RASSrvMon) is a GUI tool that monitors remote access server (RAS) activities in greater detail than the standard Windows tools allow.

Rcontrolad.exe: Active Directory Remote Control Add-On
--------------------------------------------------------------------------------
Active Directory Remote Control Add-On (RControlAD) is a tool that opens a Remote Desktop connection from Active Directory MMC snap-ins to computers running Windows 2003 Server or Windows XP Professional.

Regini.exe: Registry Change by Script
--------------------------------------------------------------------------------
Registry Change by Script (RegIni) is a command-line tool that allows you to add and modify keys and values in the registry by specifying a registry script.

Regview.exe: Registry Viewer Tool
--------------------------------------------------------------------------------
Registry Viewer Tool (RegView) is a command-line tool that allows you to view Group Policy Registry.pol files without applying them to the registry.

Remapkey.exe: Remap Windows Keyboard Layout
--------------------------------------------------------------------------------
Remap Windows Keyboard Layout (RemapKey) is a GUI tool that changes the layout of a keyboard by remapping the scan codes of the keys.

Robocopy.exe: Robust File Copy Utility
--------------------------------------------------------------------------------
This command-line tool simplifies the task of maintaining an identical copy of a folder tree in multiple locations, either on the same computer or in separate network locations. Robust File Copy Utility (RoboCopy) can provide time-efficient maintenance of mirror images of large folder trees on network servers separated by slow or unreliable wide area network (WAN) links.

Rpccfg.exe: RPC Configuration Tool
--------------------------------------------------------------------------------
RPC Configuration Tool (RpcCfg) is a command-line tool that configures Microsoft Remote Procedure Call (RPC) to listen on specified ports. It also displays the port settings and resets ports to the default settings.

Rpcdump.exe: RPC Endpoint Diagnostic Utility
--------------------------------------------------------------------------------
RPC Endpoint Diagnostic Utility (RCPDump) is a command-line tool that queries Remote Procedure Call (RPC) endpoints and reports on the status of RPC services on the system.

Rpcping.exe: RPC Ping
--------------------------------------------------------------------------------
RPC Ping (RPCPing) is a command-line tool that enables users to troubleshoot connection problems between computers involving remote procedure calls (RPCs). RPCPing works much like the Packet Internet Groper (PING) utility for TCP/IP connections, except that it tests RPC connectivity instead of IP connectivity.

RPing: RPC Connectivity Verification Tool
--------------------------------------------------------------------------------
This tool tests Remote Procedure Call (RPC) connectivity between RPC servers and clients on a network. RPC Connectivity Verification Tool (RPing) checks to see if RPC services are responding to RPC requests from client computers.

Rqc.exe: Remote Access Quarantine Client
-------------------------------------------------------------------------------
Remote Access Quarantine Client (RQC) is a tool that works as part of Windows Server 2003 Network Access Quarantine Control, which restricts remote access clients from full access to a network until they meet the requirements of the network.

Rqs.exe: Remote Access Quarantine Agent
--------------------------------------------------------------------------------
Remote Access Quarantine Agent (RQS) is a tool that works as part of Windows Server 2003 Network Access Quarantine Control, which restricts remote access clients from full access to a network until they meet the requirements of the network.

Setprinter.exe: Spooler Configuration Tool
--------------------------------------------------------------------------------
Spooler Configuration Tool (SetPrinter)is a command-line tool that is used to set configurations or states of local and remote printers, for an individual printer or for all printers on a print server

Showacls.exe: Show ACLs
--------------------------------------------------------------------------------
Show ACLs (ShowACLs) is a command-line tool that enumerates access rights for files, folders, and trees. It allows masking so that you can enumerate only specific access control lists (ACLs). ShowACLs works on NTFS file system partitions only.

Showperf.exe: Performance Data Block Dump Utility
--------------------------------------------------------------------------------
Performance Data Block Dump Utility (ShowPerf) is a GUI tool that loads and runs the dynamic-link libraries (DLLs) of installed performance counters on local and remote computers. ShowPerf then takes this data, unformatted, from the internal data buffers of performance counters, and displays it.

Showpriv.exe: Show Privilege
--------------------------------------------------------------------------------
Show Privilege (ShowPriv) is a command-line tool that displays the rights assigned to users and groups. ShowPriv must be run locally on the target computer or on a domain controller to display users and groups that have domain privileges.

Sleep.exe: Batch File Wait
--------------------------------------------------------------------------------
Batch File Wait (Sleep) is a command-line tool that causes the computer to wait for a specified amount of time.

Sonar.exe: FRS Status Viewer
--------------------------------------------------------------------------------
FRS Status Viewer (Sonar) is a command-line tool that allows administrators to monitor key statistics and status about members of a file replication service (FRS) replica set.

Splinfo.exe: Print Spooler Information
--------------------------------------------------------------------------------
Print Spooler Information (SplInfo) is a command-line tool that collects information from the print spooler and displays it.

Srvany.exe: Applications as Services Utility
--------------------------------------------------------------------------------
Applications as Services Utility (SrvAny) is a tool that enables 32-bit or 16-bit applications to run as services.

Srvcheck.exe: Server Share Check
-------------------------------------------------------------------------------
Server Share Check (SrvCheck) is a command-line tool that lists nonhidden shares on a computer and enumerates the access control lists (ACLs) for each share.

Srvinfo.exe: Remote Server Information
--------------------------------------------------------------------------------
Remote Server Information (SrvInfo) is a command-line tool that displays information about a server or workstation, including available disk space, partition types, and the status of services.

Srvmgr.exe: Server Manager for Domains
--------------------------------------------------------------------------------
Server Manager for Domains (SrvMgr) is a GUI-based tool that is used to manage Microsoft Windows NT version 4.0 or Microsoft Windows NT version 3.51 domains and computers.

Ssdformat.exe: System State Data Formatter
--------------------------------------------------------------------------------
System State Data Formatter (SSDFormat) is a command-line tool that creates a formatted copy of a system state data (SSD) log file

Subinacl.exe
--------------------------------------------------------------------------------
SubInACL is a command-line tool that enables administrators to obtain security information about files, registry keys, and services, and transfer this information from user to user, from local or global group to group, and from domain to domain.

Tail.exe: Tail
--------------------------------------------------------------------------------
Tail is a command-line tool that displays a user-specified number of the last lines of a text file, such as a log file, in a console window.

Tcmon.exe: Traffic Control Monitor
--------------------------------------------------------------------------------
Traffic Control Monitor (TCMon) is a GUI tool that allows you to view and set traffic control flows on different network adaptors.

Timeit.exe
--------------------------------------------------------------------------------
TimeIt is a command-line tool that records the time a specified command takes to run.

Timezone.exe: Daylight Saving Time Update Utility
--------------------------------------------------------------------------------
Daylight Saving Time Update Utility (TimeZone) is a command-line tool that updates the daylight saving information for the current time zone in the registry. In some countries and regions, the start and end of daylight saving time are changed every year, and there is no fixed start or end date. TimeZone allows you to adjust the start and end of daylight saving time so that the computer's time setting is automatically updated on the correct dates.

Tsctst.exe: Terminal Server Client License Dump Tool
--------------------------------------------------------------------------------
Terminal Server Client License Dump (TscTst) is a command-line tool that dumps the Terminal Services client license information present on the Terminal Services client. This license is the one that the client acquired while connecting to a Terminal Server.

Tsscalling.exe: Terminal Services Scalability Planning Tools
--------------------------------------------------------------------------------
Terminal Services Scalability Planning Tools (TSSCalling) is a suite of tools that assists organizations with Microsoft Windows 2003 Terminal Services capacity planning. They allow organizations to easily place and manage simulated loads on a server. This in turn can allow an organization to determine whether or not its environment is able to handle the load that the organization expects to place on it.

Uddicatschemeeditor.exe: UDDI Services Categorization Scheme Editor
--------------------------------------------------------------------------------
UDDI Services Categorization Scheme Editor (UDDICatSchemeEditor) is a GUI tool that provides an interface for creating and modifying UDDI Services–compliant categorization schemes.

Uddiconfig.exe: UDDI Services Command-line Configuration Utility
--------------------------------------------------------------------------------
UDDI Services Command-Line Configuration Utility (UDDIConfig) is a command-line tool that applies configuration settings from an XML document to UDDI Services components operating on a target computer, or it captures configuration settings from UDDI Services components and saves them to an XML document. You can use this tool to adjust any of the configuration

UddiDataExport.exe: UDDI Data Export Wizard
--------------------------------------------------------------------------------
UDDI Data Export Wizard (UddiDataExport) is a GUI tool that allows you to select entities, providers, or tModels hosted in a UDDI registry, and export their details to an XML file.

Usrmgr.exe: User Manager for Domains
--------------------------------------------------------------------------------
User Manager for Domains (UsrMgr) is a GUI tool that allows you to manage security for Windows NT version 3.51 or 4.0 domains, member servers, and client computers from a Windows Server 2003 computer.

Vadump.exe: Virtual Address Dump
--------------------------------------------------------------------------------
Virtual Address Dump (VaDump) is a command-line tool that creates a list containing information about the memory usage of a specified process. You can use VaDump to make sure virtual address space is not over-allocated.

Vfi.exe: Visual File Information
--------------------------------------------------------------------------------
This GUI tool uses a Cyclic Redundancy Checking (CRC) key to retrieve and generate file information. You can use this information for testing purposes to detect the files that have changed in different versions of applications or what the differences are between two seemingly identical computers. This information is also valuable for tracking different versions of resources that normally do not store version information.

Volperf.exe: Shadow Copy Performance Counters
--------------------------------------------------------------------------------
Shadow Copy Performance Counters (VolPerf) is a command-line tool that enables administrators to use System Monitor to monitor their shadow copies.

Volrest.exe: Shadow Copies for Shared Folders Restore Tool
--------------------------------------------------------------------------------
The Shadow Copies for Shared Folders Restore Tool (VolRest) is a command-line tool that searches for and restores previous file versions from file shares protected by the Shadow Copies for Shared Folders feature. VolRest allows administrators to browse or restore previous versions of one or multiple files stored on a server on which Shadow Copies for Shared Folders has been enabled. For example, from a single command line you can list or restore all the previous versions of your documents on a server.

Vrfydsk.exe: Verify Disk
--------------------------------------------------------------------------------
Verify Disk (VrfyDsk) is a command-line tool that checks the consistency and integrity of the file system (FAT or NTFS) on a specified volume. It creates and displays a status report for the volume based on the file system and also lists the errors on that volume, if any. However, if any errors are discovered, VrfyDsk cannot correct them; to correct these errors, run Chkdsk in fix mode.

Winexit.scr: Windows Exit Screen Saver
--------------------------------------------------------------------------------
Windows Exit Screen Saver (WinExit) is a screen saver that logs off the current user after a specified period of inactivity. In other respects, it is similar to other screen savers and can be configured and tested on the Screen Saver tab of the Display Properties dialog box in Control Panel.

Winhttpcertcfg.exe: WinHTTP Certificate Configuration Tool
--------------------------------------------------------------------------------
WinHTTP Certificate Configuration Tool (WinHTTPCertCfg) is a command-line tool that enables administrators to import certificates and their private keys for use on client computers.

Winhttptracecfg.exe: WinHTTP Tracing Facility Configuration Tool
--------------------------------------------------------------------------------
WinHTTP Trace Facility Configuration Tool (WinHTTPTraceCfg) is a command-line tool that enables an administrator to configure tracing features in Windows Hypertext Transfer Protocol (HTTP) Services (WinHTTP).

Winpolicies.exe: Policy Spy
--------------------------------------------------------------------------------
Policy Spy (WinPolicies) is a GUI tool that allows a user to view and refresh Group Policy settings applied to the current user account and local computer.

Wins.dll: WINS Replication Network Monitor Parser
--------------------------------------------------------------------------------
WINS Replication Network Monitor Parser tool is a DLL that parses Windows Internet Name Service (WINS) data from within Network Monitor, a feature of Microsoft Windows. This tool is useful as a way to view and troubleshoot network issues related to WINS replication.

Wlbs_hb.dll and Wlbs_rc.dll: Windows Load Balancing Server Network Monitor Parsers
--------------------------------------------------------------------------------
Windows Load Balancing Server Network Monitor Parsers (WLBS_hb and WLBS_rc) are tools that parse Network Load Balancing (formerly known as Windows Load Balancing Server, or WLBS) data from within Network Monitor.

Tuesday, July 22, 2008

SQL Server Replication

Q. How to verify if replication setup in SQL Server is working fine? Which log files to refer?

i) Verify replication is working fine by making some changes in publication/subscription.

Wednesday, July 16, 2008

Useful Windows Commands

msinfo32.msc
srvinfo (command line tool, list server information, products installed etc.)

SQL Tools Under Binn Folder

BCP (Bulk Copy)
DTA (Database Engine Tuning Advisor)
DTADBXFER
DTAEngine90
DTASHELL
OSQL (Sql Query Tool)
PROFILER90
RS
RSConfig
RSConfigTool
RSKeyMgmt
SQLCMD
SQLDiag
SQLLogShip
SQLMonitor