The article name "Customer" is same in both statements.

Example:

exec sp_article_validation @publication = 'Pub_keys', @article = 'KeyToken', @rowcount_only = 0, @full_or_fast = 0, @shutdown_agent = 0, @subscription_level = 1

exec sp_article_validation...

Gere you go ...

create table Test1 (Tname varchar(1000))

insert into Test1 (Tname) values ('<>Agenda and Minute')

insert into Test1 (Tname) values ('<>Agenda and Minute')

select Tname,

Substring( Tname,

CHARINDEX('id=',tname) + Len('">>'),...

What are all the agent jobs you have disabled/delete for this particular replication? If not, do SQL agent and stop them and verify the replication monitor.

The value should be match with Department table values. Because there is FK relationship between DEPT & EMPLOYEE tables.

Sandeep,

Few questions, How big principal database is? is there any Index rebuilding operations going on the Principal? any snapshot dbs exists on mirror database?

Regards

SRI

Hey,

How did you deleted replication? Have you "DISABLE PUBLISHING AND DISTRIBUTION" from management studio?

Explain ind detail, so that it is easy for any one to assist you.

Regards

SRI

Hi,

For insertion of Department is stringt forward ...

Insert into Departments (Dept) values ('A')

Insert into Departments (Dept) values ('B')

Insert into Departments (Dept) values ('C')

Insert into Departments (Dept) values ('D')

select * from...

Tara, are you kidding us ... Why cant you test the same ?

When you move Dev database to PROD server ....

1. Take out all unneccessary db objects (Temp tables, sps ...) from DEV DB

2. Shrink the DEV DB, take full db backup...

offcourse Pablo (Paul) Berzukov covered most of the points.

In addition to that, now you have huge SAN in hand. So you can scatter your data files, log files of...

Once you moved the files (mdf, ldf) from Location1 to Location2, Stop and restart the instance of SQL Server. make it DB OFFLINE.

Refresh the Management studion and verify the changes.

Regards

SRI