Problem with Integrity Check

I have a db on one server that publishes to a subscriber on another server
(which acts as distributor as well). Both are running SQLS2K. I have
maintenance plans in place on both dbs and each does an integrity check. The
check on the publisher runs fine. The check on the subscriber fails and the
log file states:
Starting maintenance plan 'Loc 052 S2 DB Maintenance Plan' on 5/10/2005
9:25:43 AM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL
Server Driver][SQL Server]Database state cannot be changed while other users
are using the database 'Unifirst052'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[1] Database Unifirst052: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs to
be in single user mode.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
processed. Database needs to be in single user mode.
************
I looked at the properties of both dbs and don't see anything different. I
have this same setup on other pairs of servers in different locations and I
don't have a problem with integrity checks on either the publisher or
subscriber. There are anywhere from 3 to 7 users on each of those systems.
What am I missing on the subscriber of this current system?
Remove the "repair minor problems" from the maint plan. Repairing is *not* something you want to be
done silently and automatically in unlikely case of a corruption. You want to do root cause analysis
etc.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Roger Denison" <RogerDenison@.discussions.microsoft.com> wrote in message
news:A7EFDE92-ECB4-4E27-AF90-41BF541D2DE8@.microsoft.com...
>I have a db on one server that publishes to a subscriber on another server
> (which acts as distributor as well). Both are running SQLS2K. I have
> maintenance plans in place on both dbs and each does an integrity check. The
> check on the publisher runs fine. The check on the subscriber fails and the
> log file states:
> Starting maintenance plan 'Loc 052 S2 DB Maintenance Plan' on 5/10/2005
> 9:25:43 AM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL
> Server Driver][SQL Server]Database state cannot be changed while other users
> are using the database 'Unifirst052'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
> failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [1] Database Unifirst052: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL
> Server Driver][SQL Server]Repair statement not processed. Database needs to
> be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
> processed. Database needs to be in single user mode.
> ************
> I looked at the properties of both dbs and don't see anything different. I
> have this same setup on other pairs of servers in different locations and I
> don't have a problem with integrity checks on either the publisher or
> subscriber. There are anywhere from 3 to 7 users on each of those systems.
> What am I missing on the subscriber of this current system?
|||That was it, thanks. Don't know how that got checked but I cleared it and
everything is good.
"Tibor Karaszi" wrote:

> Remove the "repair minor problems" from the maint plan. Repairing is *not* something you want to be
> done silently and automatically in unlikely case of a corruption. You want to do root cause analysis
> etc.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Roger Denison" <RogerDenison@.discussions.microsoft.com> wrote in message
> news:A7EFDE92-ECB4-4E27-AF90-41BF541D2DE8@.microsoft.com...
>
>

Problem with Drop Table and Field name chage

Hi!
I had two servers of SQL 2000 with distributor and publisher mode for replications. I wanted to change one field name of a table, I did the following:
1. stopped publishing,
2. Stopped distribution
3.Re-started the servers.

But when I want to save the changed field name i am getting this error

"/*

Saturday, October 18, 2003 12:59:08 PM

User: sa

Server: SSD-SQL2

Database: PAIFORWEB

Application: MS SQLEM - Data Tools

*/

'CC02' table
- Unable to rename column from 'INWARD' to 'INWARDxyz'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot rename the table because it is published for replication.
"

I am getting the same error while dropping the database toout when I checked the replication there is no distribution and publication is existing.

Please help, it is most urgent to me.

Thanks in advance.

Sabyasachi Sensearch for "manually removing replication" in google prior to proceeding with object rename.

Problem with distributor

In the replication wizard, the first menu "SELECT DISTRIBUTOR", have two
options
a) Make the "Myserver" its own distribuitor, SQl Server will create a
distribuiton database server and log.
b) Use the following Server, ( The selected server must already be
configured as Distribuitor).
When i select the first option pop-ups a window with this text :
"SQL Server Agent on SERVER1\Macuco" currently uses the system account ,
which causes replication between servers to fail, In the following dialog
Box, specy another account for the service startup account "
In the SQL Server Agent Properties which account i need to choose?
Thanks in ADvance
Alejandro Carnero
Brazil-Santos
Ideally use a local admin account.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"alecarnero" <alecarnero@.uol.com.br> wrote in message
news:OTGvbxcAGHA.740@.TK2MSFTNGP12.phx.gbl...
> In the replication wizard, the first menu "SELECT DISTRIBUTOR", have two
> options
> a) Make the "Myserver" its own distribuitor, SQl Server will create a
> distribuiton database server and log.
> b) Use the following Server, ( The selected server must already be
> configured as Distribuitor).
> When i select the first option pop-ups a window with this text :
> "SQL Server Agent on SERVER1\Macuco" currently uses the system account ,
> which causes replication between servers to fail, In the following dialog
> Box, specy another account for the service startup account "
> In the SQL Server Agent Properties which account i need to choose?
> Thanks in ADvance
> Alejandro Carnero
> Brazil-Santos
>