---

About Us	DTS export varchar fields to a .txt and they are truncated to 255 characters. What is the reason?
DTS is stored in SQL Server and not opening. How to open it?	Found Error: 831, Severity: 20, State: 1 with message “Unable to deallocate a kept page” in SQL 2005
Guide to install SSIS 2008	Home
How to access/restore a previous version of DTS?	How to archive more than six SQL server errors logs before recycling?
How to automatically find when SQL Server (2008) was last started?	How to bring litespeed central and local repository in sync?
How to change DTS package's owner?	How to change SQL Server Error Log/SQL Agent log location/path?
How to compare/sync data between two tables?	How to control the order of task/workflow execution in DTS?
How to copy DTS packages from one SQL Server to another?	How to create a database snapshot?
How to create a script to create database snapshot automatically using TSQL?	How to determine the version of SQL Server?
How to drop a database snapshot?	How to find backup history of a SQL 2000 database?
How to find if SQL Server buffer pool has a tendency of grow or shrink?	How to find maximum number of workers that can be created?
How to find number of buffers needed by Buffer Pool?	How to find number of virtual log files in a database’s physical log file?
How to find out how much a SPID rolled back or how much time is remaining to complete rollback?	How to find out the port SQL Server is listing/using using TSQL/Code?
How to find restore history of a specific database?	How to find snapshot isolation level of a database?
How to find SQL Server Error Log location/path?	How to find tables with most reads for a database?
How to find tables with most writes for a database?	How to find the buffer pool that are directly accessible in the process of SQL Instance?
How to find the number of schedulers in the SQL Server?	How to find the OS Priority class of the SQL Server machine?
How to find the total committed physical memory in buffer pool of SQL Server machine?	How to find the total physical memory of the SQL Server machine?
How to find the total virtual memory of the SQL Server machine?	How to find top 10 resource consuming queries?
How to find top 100 stored procedures by execution count for a database?	How to find top 20 stored procedures ordered by CPU pressure for a database?
How to find top 20 stored procedures ordered by logical reads (memory pressure) for a database?	How to find top 20 stored procedures ordered by logical reads (read I/O pressure) for a database?
How to find top 20 stored procedures ordered by physical reads (read I/O pressure) for a database?	How to find uptime of the host OS using SQL Server?
How to find what task DTS is executing?	How to find when SQL Server started if this information is not available in SQL Log?
How to find who accessed SQL Server?	How to fix error message: SQL SERVER – Fix: Error: 18452 Login failed for user ‘(null)’ ?
How to give permission to someone to use SQL Server Activity Monitor or to use DMV?	How to identify if there is a CPU bottleneck?
How to increase Security for DTS Packages?	How to insert data to a table from another table programmatically (using TSQL)?
How to kill a negative SPID (like SPID -2) in SQL Server?	How to kill all users from a database?
How to log a DTS execution?	How to mark a task as completed before it executes?
How to migrate SQL Server 4.2 to 2000/2005?	How to monitor command execution progress (in percentage) in SQL Server?
How to monitor how much restore is completed of a Database?	How to move Master to another drive?
How to move TempDB to another drive?	How to physically move a table to another location?
How to read the error file generated by a DTS?	How to resolve “OLE DB error: OLE DB or ODBC error: Timeout expired; HYT00.”?
How to resolve Error = -2147467259 (80004005) in SQL Server’s log/job failure history?	How to resolve Error: 1006 (3EE); Provider Error: 1006 (3EE) in SQL Server’s log/job failure histo
How to resolve Error: 3041, Severity: 16, State: 1 reported in SQL Server Log?	How to resolve failure like “Cannot create or update statistics on view "<Table/View Name>" ?
How to resolve if we get GetSQL2005BlockingSPIDs.vbs : Cannot login to database ?	How to restore a database from a snapshot?
How to restrict client’s logins attempts by IP Address?	How to see the backup history of a Database?
How to see when data of a table is last updated?	How to shrink database log to as small a size as possible?
How to write SQL Server logs in a table automatically/programmatically?	KB - Monitoring
KB – SQL Server DTS/Integration Service	KB – SQL Server General Administration
KB - SQL Server Installation and Migration	KB – SQL Server Script (TSQL)
KB – SQL Server Security	Knowledge Bits
Privacy Statement	Terms of Use