In Microsoft SQL Server 2000, an access violation may occur that may cause the SQL Server process to exit. You experience this problem when you run a SELECT query and all the following conditions are true: • The NO_BROWSETABLE option is set to ON. • You use a SELECT statement that includes an i

Thirty-six new webcasts are Scheduled for June, covering such topics as Advanced Report Authoring, Analysis Services, Data Warehousing Enhancements in SQL Server 2005 and more.

(Rushi Desai) Today, we did a short presentation on Service Broker for a customer who is interested in using the Service Broker technology. Their current application uses a large backend SQL Server database that is accessed from several mid-tier servers. In one of their scenarios, requests are queue

When you try to install Microsoft SQL Server 2000 Reporting Services, you receive an error message that is similar to the following: Failed to find property in cache: InstalledInstances. failed to perform discovery on machine:ComputerName.

(Gregory A. Larsen) Every DBA needs to transfer data between tables. This is the kind of task that comes up all the time. Not only do DBAs need to know how to transfer data between two tables on the same server, but they will also need to know how to do it from one server to another. This article wi

(Arthur Fuller) The logical consequent of normalization is that columns should be modeled as rows only theoretically. In practice, where the number of columns may remain constant for years, this refinement is unnecessary. But in some situations, you should think about representing these attributes a

(Jayaram Krishnaswamy) Have you ever wondered how to access data for an SQL 2000 Analysis server from Microsoft’s Excel program? This article will show you a step-by-step procedure.

(Michael Labib) I consider Yukon to be a new way of supporting Microsoft.NET. In fact, when I heard about Yukon I began to ask myself many questions like “How will Yukon support .NET?”, “What will make me go for Yukon?” , “What are Yukon’s features?”, after some researches on my own I found the answ

XPGUID provides a couple of GUID (uniqueidentifier) related procedures to improve the usage of GUIDs inside SQL Server 2000; most importantly it provides a procedure for generating sequential GUID’s, besides that it provides a procedure for testing a string if it represents a valid GUID, without gen

(Tom Moreau) As you know, I enjoy receiving e-mail from you, particularly when you provide me with a challenging T-SQL problem or one that makes me dig in and learn something new. This month’s “best question” award comes from UK-based Dr. Graham Smith.