Yes, the table gets rebuilt .... I just meant to show that a script could be generated of the process and run outside of EM.

You can do it through EM, but instead of saving your change, press "Save change script". Then you can use that script later & build upon it if you want.

I just got that error too ....  Didn't bother to troubleshoot it yet.   I guess it got past the proofreader !

It's hard to believe that MS stores the dates in...

Technically, you could use replication, choosing the "Don't initialize - subscriber already has data" option.  But I bet it would get messy, and it wouldn't be my first choice. Log...

Sorry, What's TPM ?

Back in my AS/400 days, I had all sorts of information about objects that was very useful. It kept track of objects usage & changes along with...

If you have Lumigent's Log Explorer, you can set it to alert you when there are database changes. I have it on our production server and find it useful from...

Sorry I wasn't clear.  I hadn't seen you EM Tricks article, so I tried clicking the link in your first post.

I tried the link above, and got page not found ??    Did some pirates whisk it away somewhere ?

(edit) Found it by looking around a bit ....

You could set up a publication for each location.

For England, you create a publication with your account information, let's say your account table is ACCOUNTS and the field is COUNTRY. ...

You can add a filter, which will mark the subscription for reinitialization, then a new snapshot will re-populate the tables with the filter criteria.

I'm not sure what you mean by...

I'm not sure about merge replication, but with snapshot & transactional replication you can do it by scripting out the "delete" publication from Ent Mgr, then snip out just the...

just add "Where not exists in sysarticles" to your select from sysobjects

How about backup & restore instead ? ?

That restores the entire database to that point in time. If there are other transactions in other tables after the error that you still want, you'll have to take a few...

Yes, we're using Veritas SQL Agent for most of our backups, but haven't had any problems with restores, not that we've done that many. I am doing SQL backups to...