(William E. Pearson, III) In this article, we will continue our examination of an area of considerable interest to MSAS developers and practitioners, and an area where optimization skills are vital to the efficient operation of both client and server. In our last article, MDX Optimization Techniques

You receive the following error message: Login failed for user ‘ServerNameguest’ You receive this error message if either of the following conditions is true: –You try to register a server in SQL Server Enterprise Manager. –You try to connect to Microsoft SQL Server 2000 by using SQ

( Muthusamy Anantha Kumar) In the previous article, we discussed how to implement SQL production changes to multiple databases on the same server. In part two we will discuss implementing SQL changes to multiple databases on more than one server. The following steps explain how to apply similar c

A DBCC CHECKDB statement may report consistency errors in your database when all the following conditions are true: –SQL Server loads data into a column that is a sql_variant data type. –The data originates in another column that is a sql_variant data type and at some point the data is sen

(Brian Lawton) It’s been almost 4 years since SQL Server 2000 hit the street. With it, Microsoft unleashed a powerful but often underutilized toolset. Think for a moment about your own organization. Are you doing anything more creative with your SQL Server software than running an occasional backup

(Brian Knight) As you may have heard, the next version of SQL Server (code named “Yukon”) has a name. The release is now formally called SQL Server 2005 to match Visual Studio 2005. A new schedule was announced that pushes the beta cycle out as well. Beta 2 will be widely shipped in the summer o

(Andrew Novick) The SQL Profiler is a great tool for monitoring and analyzing SQL Server Performance. I use it all the time to watch the detailed actions of a stored procedure, trigger or user-defined function (UDF) that I am developing. It can also be used to monitor aggregate performance of an ent

(Steven Warren) In my previous article, we discussed how to configure and test a typical failover scenario using Double-Take. At this point, you should now be able to create a replication set and configure replication and mirroring. In the final article of this series, we will show you how to restor

When you install Microsoft SQL Server 2000 Service Pack 3 (SP3) on your computer, you may receive the following error message: SQL Redist content: Command line option syntax error. Type Command /? for Help. If you click OK in the message box, the installation of SQL Server 2000 SP3 may comple

After you apply post-Microsoft SQL Server 2000 Service Pack 3 (SP3) hotfix build versions between 8.00.0859 and 8.00.0875, applications that execute a stored procedure that uses a SET NOCOUNT ON statement and that return one or more result sets following an informational message, a RAISERROR stateme