Its a server wide setting set when you install it.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Looks ok.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Just a guess, try setting the database status property.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Brian, I think I'd be willing to risk the guid. Not even sure it's possible to get a duplicate and even if it is, odds have to be pretty low....

We'll probably look at it. SQLWire was "good enough" so we didnt see a need to try put out a product that about the same info, if anything they ran...

Can you post your connect string?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Maintenance plan is the simplest way to get started. I typically run the consistency checks once a week.

Andy

http://www.sqlservercentral.com/columnists/awarren/

I dont think there is a merge module for it. Easy enough to build one. Use Depends.exe to see if has other dependencies that need to be included.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Its the nature of things that there is always some gray, few absolutes. Can you give me an example of how using object ownership helps..besides the great one from narine?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Standard tran log backup should do it. Maybe the log is just not big enough? Index rebuilds will generate a lot of transactions. Replication can cause the log to not...

Count by group or overall? If you want a count by group just include Count(*) in your select. If you want a count of the number of rows resulting from...

If you look at the proc its a fairly simple update. Shouldnt affect any of the things you mentioned. If you move all your mdf's to the new server when...

Everything I saw in the newsgroups says it cant be done. Not a promising start. Maybe work around by creating an mdb that links in all the tables from the...

You can view the text of the stored proc in the master database.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Shouldnt have affected anything. Sync with backup can definitely affect your latency. Alternate plan is to just restore the publisher if something goes wrong, then re-init the pub and send...