Thanks to everyone for the answer. Unfortunately, the last part of my message got cut off. Our table has 10+ million rows and one field in those rows may contain...

What do you expect from a newbeie! I found that MS Analysis Services has a SP2 that I hadn't installed. I installed it any my problem went away.

Bill

Brian,

This is off the subject but you mentioned you restore the entire OS from a tape backup. What software do you use? When we tried the same thing with ArcServe...

Antares,

I found the error thanks to your directions. The problem was that Sql SP 1 was installed on the production box and I had not done the same for my...

Antares,

I did a "select version" on both machines.

My Development Box:

------------------

Microsoft SQL Server 2000 - 8.00.534 (Intel X86)

Nov 19 2001 13:23:50

Copyright (c) 1988-2000 Microsoft Corporation

Developer Edition on...

Thanks for the thoughts. But in our case the TL dump doens't happen at 8:56pm and a Full Backup at 9pm. The schedule has both slated for 9pm. That's why...

I'm trying to determine if Sql server is running on a given machine. I turned off the Sql Server on "tower2" using the SQL Server Service Manager, emulating a failure.

In...

More info on this problem: this morning everything was working fine (surprise!) on the server. That is until 11am when the timeouts started up again during a DB dump. Here's...

After further examination I think the t-sql is using the wrong column. Instead of "rowcnt" is should use "rows" which is present in both sql7/sql2k sysindexes.

use newbie

select o.name as "Table...

Here's another detail:

under SQL 7: sysindexes\rowcount field is a <binary> field

under SQL 2K: sysindexes\rowcount field is a bigint!

Thanks for the help guys. One other glitch. When I run the script on a SQL 2K machine the "row count" column displays as a decimal but under our Sql...

Thanks Andy,

That did the trick. The documentaiton mislead me.

>>>

Start Method (SQLServer)

The Start method starts the Microsoft® SQL Server™ 2000 service, optionally connecting the SQLServer object on successful start.

Applies ToSQLServer Object...

Andy,

How will adding more RAM help the situation? It's my understanding that Sql will gobble up, if not restricted, most of the available RAM on a server. So putting more...

I used profiler and found that it errored out on:

ALTER TABLE dbo.benefits DROP CONSTRAINT DF_benefits_vac_available

ALTER TABLE dbo.benefits DROP COLUMN vac_available

I didn't see...

Antares686,

The developers wanted my to change the (field) names to protect the innocent but here's the Sql script. I haven't had a chance to run profiler yet but I will...