Consider the following scenario. You use ADOMD.NET in a Microsoft ASP.NET application to connect to Microsoft SQL Server 2000 Analysis Services. You try to connect to a remote OLAP server. In this scenario, you may receive an error message that is similar to one of the following: Connection timed

(Serdar Yegulalp) Most SQL Server development is done using SQL Server Enterprise Manager or Query Analyzer. The former provides a nice, hierarchical view of the entire server and its attendant database objects, but has many limitations. The latter provides the power of a command line, but is strict

In Microsoft SQL Server 2000 with Service Pack 4 (SP4), a query that generates a very large query plan may not run. For example, the query may not run when you use the DELETE Transact-SQL statement and you try to delete records from a table that has FOREIGN KEY constraints on many tables. When this

The Feature Pack is a collection of standalone install packages that provide additional value for SQL Server 2005. It includes: –Latest versions of redistributable components for SQL Server 2005 –Latest versions of add-on providers for SQL Server 2005 –Latest versions of backward compatibi

(Scott Mitchell) On November 7th, 2005, Microsoft officially released .NET 2.0 (including ASP.NET 2.0), Visual Studio 2005, and SQL Server 2005. All of these components were designed to work side-by-side with previous versions. That is, both ASP.NET version 1.x and version 2.0 can be installed on th

(Douglas Reilly) To say that Jim was a database geek [when we worked together] is an understatement. He was the guy who wrote stored procedures to write stored procedures.

(Vinod Kumar) Diagnosing problems in SQL Server 2000 has always been a point of concern from both developers and DBA’s. More often than not we would have had a need to use undocumented and DBCC commands which are sometimes very difficult to understand too. SQL Server 2005 on the contrary is like a o

Consider the following scenario: • In Microsoft SQL Server, you use Microsoft OLE DB Provider for Visual FoxPro as a linked server by using the OPENQUERY function or the OPENROWSET function. • In SQL Server, you configure Microsoft OLE DB Provider for Visual FoxPro to run in-process. • You ru

Microsoft SQL Server 2005 is a complete business intelligence (BI) platform that provides the features, tools, and functionality to build both classic and innovative kinds of analytical applications. This paper provides an introduction to the tools that you will use to build an analytical applicatio

Returns a character string after truncating all trailing blanks.