We are planning to cluster SQL Server 2005 (Active-Active). Can we also
cluster Microsoft Analysis Services 2000 on the same nodes ? If we can, what
are the issues we need to be aware ?
We are not ready to go to Analysis Services 2005 yet.

Problem Description:
Unable to uninstall SQL 2000 Server on a Windows Cluster 2003 Server SP2.
My goal is to uninstall SQL 2000 and install SQL Server 2005 on the same
server.

Our production SQL database’ located on SQL Server 2005 (SP2) with 3161
version. When we use the SqlBulkCopy, the following error occurs:
System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS)
protocol stream is incorrect. The TDS headers contained errors.

Is it possible to upgrade from 2005 express to 2005 workgroup?
Thank you.

I am little at a loss here.  I found a procedure that allows me to
pass two parameters: username and dbname and it grants execute to that
user to all stored procedures on theat specific database.
I couldn't find anything that would allow me to grant execute

I was monitoring our customer's SQL Server and noticed that it has Page Life
Expectancy about 3,000,000.
Is that in seconds or milliseconds? Is that normal?
Thanks in advance,

 I run followings sql quirey
GO
DBCC CHECKTABLE ('ECPARTY' ,REPAIR_REBUILD);
GO

When server starts i get a error and theses messages pop up....
(SQL Server) Your SQL Server installation is either corrupt or has been
tampered with (Could not open SQLEVN70.RLL.). Please uninstall then re-run
setup to correct this problem    

I use NTBackup  (Windows 2003) to backup my SQL 2005 servers. I backup all
files (disk C, D, E ....) + system state to one file .bkf (no to tape). I
excluded from backup all *.mdf files and *.ldf files.
Unfortunately I noticed strange behaviour, when I tried restore backup from

Could the following query be simplified/optimized?  The database has a table
that maps users to locations, locations to chapters, and sections to
chapters. I need to issue a query that would return a list of sections that
can be assigned to a user (excluding the ones that have ...

I am completely SQL ignorant, so please be gentle!!!
Are SQL 2005 64 bit databases constructed differently to SQL 2005 32
bit databases? For example, could I restore/import a database created
in the 64 bit version to a 32 bit version of SQL 2005?

I'm hosting a site on DiscountASP and since I have full text enabled
I
need to schedule the population. However, they don't allow using SQL
Enterprise Manager and said I have to use SQL to do it. I'm really

I have several jobs scheduled to run every evening. Is there a way to
set SQL Server 2000 send an alert message if any of jobs fails or
completes successfully?

Gurus,
Running SQL Server 2005 SP2.  The SQL Server Browser service but since I am
running on dynamic ports it is not listening on 1434.  In fact, looking thru
Configuration Manager I am not able to tell what port it is listening on or

Is there a way to get a list of records that have changed since a specific
Date/Time?
I could create a trigger and a new table and work off that data but I have a
lot of tables I want to query so I don't necessarily want to create triggers