(Jayaram Krishnaswamy) The scenario is one of creating a DTS package that populates a table in an MS Access database from an SQL Server database on a schedule. The scheduling is to be carried out by creating an SQL Job. MS Access is often used for creating reports, and this scheduling makes it e

Consider the following scenario. In Microsoft SQL Server 2000 Service Pack 4 (SP4), you perform one of the following tasks: • You use the sp_addalias procedure to add an alias in the user database. • You use the sp_dropalias procedure to remove an alias from the user database.

(lintom) This article explains how you can easily truncate a transaction log file without knowing the logical log file name. The code explains a very easy way to truncate the transaction log file by looking into the sysfiles table.

(Brian Walker) Here I will describe two simple routines. In the first, the SQL code creates a system stored procedure named sp_FixTables, which performs a specified operation on a specified set of tables. The second is a system stored procedure named sp_FixObjects, which performs a specified operati

In Microsoft SQL Server 2000, when users connect to an instance of SQL Server by using a network packet size that is larger than 8,060 bytes, an error message that is similar to the following may be logged in the SQL Server error log: WARNING: Failed to reserve contiguous memory of Size=

(Jay Nathan) Data cleansing is an important task for data warehouse specialists, database administrators, and developers alike. Deduplication, validation, and householding techniques can be applied whether you are populating data warehouse dimensions, integrating new data into an existing transactio

In Microsoft SQL Server 2000 Service Pack 4 (SP4), you perform one of the following tasks: • You use the sp_addalias procedure to add an alias in the user database. • You use the sp_dropalias procedure to remove an alias from the user database.

(James Crowley) SQL statements are used by Access, ADO, Oracle, Informix, and not suprisingly, MS SQL server. In short, if you use databases, be it in VB, ASP, FoxPro, Access or anything else, at some stage you will need to know SQL. SQL, or Structured Query Language gives you complete control over

(Scott Mitchell) Every couple of weeks or so tech news sites like News.com or ZDNet tell an increasingly common tale – some big name company’s databases have been hacked, resulting in the hackers discovering oodles of personal information about the company’s customers. If you build public-facing

In Microsoft SQL Server 2000, when you run an UPDATE query and a SELECT query at the same time, the UPDATE query blocks the SELECT query. You experience this problem when you run a SELECT statement that uses the TOP clause and the READPAST locking hint.