Me?  The person who took all afternoon to figure out how to identify any difference between the machines?

Seriously though, thanks for giving me something...

That's definitely the option of last resort.  I'd have already done that, except that it works as written on one of my test servers. 

I've been trying to isolate differences between the...

Thanks so much for the reply.

While I like the replacement of the UDF, I still get the same violation of unique key constraint message, and no inserted rows.  (I also...

Thanks so much for saving me all that typing.

Any thoughts on what objectid and objecttype correspond to?

So how do you get it to work?

Jonathan,

Thank you so much for responding.  Between now and next month when we run this process again, I will look into the topics you recommended. (Of course I can't get it...

This is just a general comment about how the answers to the QOD are displayed.  First, I think the explanations of the correct answer lately have been terrific.  The only...

Your database doesn't by any chance have Autoclose set to 'Yes', does it?

The string series has been very helpful.  I wanted to reread the 'substring' article, but the link doesn't work, although all the others do.  If I go back to the previous...

We've automated a number of our FTP transmit and receipt jobs using WS_FTP Pro, and it has a a passive mode switch.

http://www.ipswitch.com/

MattieNH

Wow, who would have thought?

I know I raise this point every time someone writes something like this:

A user who saves any password is as scary as the ones who write...

Thanks so much.

Mattie

What does the "8=" mean?

/A "gvAuthorNm":"8"="Brian"

If you delete a record from the table, unless it's the last one, won't a count give you a duplicate?

ie:  Records 1 to 10, #7 deleted, so now you have 9...

Thanks for your reply.  However, if I understand your answer correctly, I didn't ask my question very well.  I don't need to find 'MyNumber', I need to compute it.

Mattie