There are a few 3rd party tools out there, I think FMS has one too. A simple way is to create a diagram that has all your tables. Not perfect,...

Why do you need to know? So you can show a status bar, allow interruption of processing?

Andy

Bummer if that's true, had not thought about it. I've avoided Office SP1 just so I can use Outlook to send email from apps on my workstation. We've got an...

Havent had a chance to look at your code, but can offer help on Format. Compile a VB DLL that has one object with a Format function/method exposed, inside that...

I think Im the only one in favor of putting them in the db on here. Pro's are that it's in the db, secure, gets backed up. Con's are you...

We've been discussing this (me, Sean, Steve, Leon) about possible solutions. One was to build a code generator that would build procs for all the permutations. Leon has an interesting...

Triggers should always be lightweight and bulletproof. The only problem with calling a stored proc from a trigger is that you can't pass the inserted/deleted tables as a parameter, forcing...

Does it work ok if you run it as a plain .VBS file from Windows rather than via DTS?

Andy

It's a free download:

http://www.msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001169

Andy

I agree that IN is easier to read. I typically use OR if there are only two choices, IN for any more than that.

Andy

Just set permissions on the procs, not on the tables.

Andy

Here is the article I mentioned earlier:

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

Andy

I'd say NT is better than SQL login for that. Require everyone to keep workstations locked when they are away, change passwords at scheduled intervals. NT is much less administration....

We just used them for a good size project where I work, turned out pretty good. I'll admit looking at guid's isn't easy on the eyes. Our biggest reason was...

Have you tried the –UseInprocLoader switch on the snapshot agent? Are you removing any indexes on the subscriber table before loading (or just recreating the table?)?

Andy