We only use SQL Server 2000 SP3.  We had different problems with OPENQUERY a year or more ago and coded them all out.

Our DBA returned on 29 Dec 2003.  He...

We restore backups about twice a month.  We take production backups and restore them in our development environment after each development cycle to make sure it is syncronized with production. ...

I created a merge replication test in our development environment and started the snap shot job. That worked fine. But when I start it in production it doesn't...

I have found the job that is for the snap shot for the merge replication that is not working. Can I just tell this job to start?

Robert W. Marda

SQL...

Sorry, forgot the details.

All SQL Servers are SQL Server 2000 with SP3. The SQL Server Agents seem to be running. The transactional replication is one way.

Robert W. Marda

SQL...

I told my manager about the recommendation many of you gave to contact Microsoft and he said to wait for our DBA to return.

The problem happened again today. I...

That is the solution I have implemented. Thanks. From a curious stand point, I would still like to know if there is a rename command for VB Script...

What (or who) is PSS?

I was planning to drop and recreate the index just now. I waited till now, because the table in question has over 5 million rows...

Late night Wed to early morning Thur I removed replication, dropped the primary key on this table, set database to single user mode, ran DBCC CHECKTABLE('tblCorrupt',REPAIR_ALLOW_DATA_LOSS), added clustered index (which...

Thanks, I am looking at DBCC SHOW_STATISTICS now, unfortunately I don't think I can get it to show me the statistics for all statistics at once.

I will never claim changing...

That I have heard and usually only change system table directly when I can't find another way to do what I need to do.

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital...

Thanks for the quick reply. So if the statblob column is corrupt I'll get this problem. Can I safely just delete all the _wa rows in this table?...

I have run DBCC CHECKDB (Which says it does everything DBCC CHECKALLOC does) and still have the 18 consistancy errors.

Here is one of them:

Server: Msg 8964, Level 16, State 1,...

My mistake. It appears to have been a corrupt index. I dropped the index and recreated it and now the select works fine. The only troubling thing...

Yes I have been using DBCC CHECKTABLE and DBCC CHECKDB. I think I have some data corruption now too. My problems seem to revolve around text data types....