When you set up a publication in Microsoft SQL Server 2000, and then you try to run the Snapshot Agent, the Snapshot Agent fails. When this problem occurs, the following 3902-based error message may be logged in the Distribution Agent log: The COMMIT TRANSACTION request has no corresponding BEGI

(Don Schlichting) Locks are the mechanism databases use to control problems that may arise from simultaneous multi-user access. Some common issues locks try to manage include; what happens when two users try to change the same piece of information at the same time – who wins? Or user one tries to re

In Microsoft SQL Server 2000, the ClusterName value and the ClusterIpAddr value are in the following registry subkey: HKEY_LOCAL_MACHINESoftwareMicrosoftMSSQLServerCluster When the ClusterName value is longer than the ClusterIpAddr value, SQL Server 2000 may load an incorrect certificate.

Jamie MacLennan shows some of the advanced data mining technology in SQL Server 2005 Analysis Services. See examples of data mining-powered applications, plus an overview of how to use the tools provided with SQL Server 2005 to create and explore the data mining models used by those applications.

(Kevin Kline and Baya Pavliashvili) SQL Server has become more self-maintaining with each new release, but the principle “better safe than sorry” still stands: Solid database administration involves performing regular maintenance on system and user databases so that you fix problems before your user

When you use SQL Query Analyzer to debug a stored procedure in Microsoft SQL Server 2000 Service Pack 4 (SP4), an access violation occurs in the Mssdi98.dll file. Additionally, SQL Server crashes. You experience this problem when the following conditions are true: • You are in the single step mo

Historic London, home of Buckingham Palace, Big Ben and the Tower of London, is the ideal setting for a conference built on clarifying the facts about analytics and business intelligence. Industry experts team up with ProClarity customers and partners to arm you with the vision and insight necessary

(Sheel Gohe) Application that Looks at an MS SQL SERVER Database. Pulls the Tables from that Databse and Generates a Class File for the selected Table. This class file generates SQL for all the DML operations based on selected criteria. The criteria can be defined through a seprate criteria class.

In Microsoft SQL Server 2000 Analysis Services, you may experience an access violation or data corruption when you try to merge partitions when lazy processing is occurring.

(Scott Mitchell) Last week’s article, Maintaining Database Consistency with Transactions, looked at what, exactly, transactions are and how they can be used to guarantee consistency in a database when issuing commands that modify multiple tables. Specifically, transactions ensure that a set of modif