Definitely depends on the client. Here where I work the minimum configuration is P400 with 128m RAM, more than enough for anything we could think of so far! Doing the...

Steve - you gotta try SQL Compare - it'll change your life!

Andy

Maybe log an entry into a table when each app starts, then run a job that will look for rows with a missing close out entry - then have it...

Not sure I follow - the insert is failing on the publisher?

Andy

That makes sense - I dont think there is a way to upgrade without having 6.5 installed.

Andy

Havent used it, but Im in favor of using SQL replication rather than something low level like Double Take. At least I can modify/troubleshoot replication! Perhaps other readers will have...

Did you modify the table, either on the publisher or subscriber? There will be an insert proc on the subscriber for each table that is being replicated, you can compare...

Nothing much more than I posted earlier..that I can think of at the moment anyway, is all kind of a blur!

Andy

Hey Jim,

We have a lot of useful articles here on the site that might help clear the fog some. For example, I have one posted that explains how logins and...

We're glad to help!

Andy

If you're just applying minor changes to a db, I'd agree that a script is the way to go, especially since you still need to go through the process of...

Should have thought of that too - functions often encapsulate quite a bit of code, just depends on how many times you're accessing the same table whether it makes sense...

I think its a ODBC trace file - check your DSN utility to see if tracing is turned on.

Andy

I agree about the use of the return code for error signaling. I doubt there is much difference in overhead if you declare true output parameters - figure no matter...

One other thing to remember is that you can actually turn triggers off in SQL 7 and later - which can lead to a few puzzling moments if you forget...