you should also patch your version( 9.00.1399 ) is RTM you should patch SQL Server ( SP3 is already out )

Sorry I should have posted: UPDATE STATISTICS {tablename} WITH FULLSCAN,ALL

GilaMonster (3/3/2009)

---

noeld (3/3/2009)

---

It's not. SQL will always try to cleanly shut down all of its databases...

Normally sp_publication_validation is what is used, any custom rule you will have to program it yourself.

winston Smith (3/3/2009)

---

so what happens in the case of a power outage? is sql server able to recover without intervention, as long as the storage media is ok? there will...

Even in the case of a power outage SQL Server most be able to recover unless disk corruption occurs!

Be careful before engaging into things like this. You must ensure that your primary file group is always available, that your transaction log backups are tightly controlled and PRACTICE as...

when you run dropsubscription and droppublication all replication objects should be removed unless there are errors. You you run also droppullsubscription if you are using "pull" subscribers. Please refer to...

Are you talking about LogShipping ?

You should you Merge and Yes SQL Express can be subscriber to either Transactional, Snapshot or Merge.

By the way your server version is retrieved by running "select @@version" on the...

You can also on a per article basis tell the the publication not to delete the data at snapshot time.

Nevermind, I think I am in need of coffee 😉

Am I looking at the same question you are ?

There is no TRUNCATE TABLE anywhere in the code!

🙁

Please, post sample code and sample data.

You will probably need a level and a path to run your rollups but we can't go further without more info.

Hopefully you understand why...

H (2/27/2009)

---

Hello Noel,

I ran sp_helppublication on the publication db, and it returned these results:

1timesheet_prd_TRA01110Snapshot publication of timesheet_prd_TRA database from Publisher NL00-TSHEET1TST.001100000NULL336001NULLNULLNULL0NULL21NULLanonymous00NULL14NULLNULL100

It was a great help, because I saw that there...