1) Please post the error message.

2) Make sure that SQL Server Browser service running.

I guess the width of the...

Thanks for your updates. Happy to know that you are able to fix the issues.

Keeping the primary...

mhd_mhd (4/18/2012)

---

i have a standby database in sql server(2008). backup from primary database and copy logs and restoring Occur every day every 10 seconds ,but i have latency in standby...

mhd_mhd (4/18/2012)

---

i have a standby database in sql server(2008). backup from primary database and copy logs and restoring Occur every day every 10 seconds ,but i have latency in standby...

1) Run the following (with your database and publication name):

USE <Database>

GO

EXEC sp_changepublication

@publication = 'MainPub',

@property = N'allow_anonymous',

@value = 'false'

GO

EXEC sp_changepublication

@publication = 'MainPub',

@property = N'immediate_sync',

@value = 'false'

GO

2) Add new article to the...

Check the publisher and make sure that table is fine there.

You can remove the article 'SummaryHeader' from replication and re-add it without generating snapshot for other articles in the publication.

Another...

Minto Minto(quendans) (4/13/2012)

---

In our server (SQL 2008 Standard) we are facing a problm with one table.

Issue:It is having 740 rows.These row we have updated last month.This month agian we have...

Please post the complete error message you got.

farrukh635 (4/12/2012)

---

1. Is it neccessary the service account user of SQL Server Agent and and SQL Server user must be same on both server?

2. If i change service account and...

It is a valid question.

Run this:

sp_helptext sp_helpdb

Please post/attach the query execution plan.

declare @test datetime = getdate()

SELECT @test = ISNULL(TT.EffectiveDate, GETDATE())

FROM testtable1 AS TT

WHERE TT.VersionID = 2167

select @test

Thanks for posting the solution.

I think updating system tables should be avoided.

Can sp_update_jobstep be used for this?