ISSUE RESOLVED.

It was a permissions issue.  Messing with the local login, the login used on the Linked Server, and what the expected permissions were on the network were, I was finally able...

Another update: After querying users and testing group memberships, I have found that:

A user with userAccountControl = NULL do not return in my memberOf query.

A user with userAccountControl of 512...

Yes and I have tried it in many different ways and formats.  Maybe it's just not possible.  It seems like SQL 2005 may be able to do this.  I have...

In my DTS package, I have a connection to a dBase IV file that's out on the network.  With that connection, I initiate the Create Table task. 

Thanks!

Again, thanks so much!  I have assigned SCOPE_IDENTITY to @scopeIdent which worked great. 

As for Antares, working in CRM I have encountered the different scenarios of 2 and 3, so...

I apologize, I meant many-to-one.  Multiple contacts to one customer.  I will try out the SCOPE and see if I can't get that to work. 

I really appreciate the replies!

Thank you, Steve!  I am putting some efforts towards testing, but I wanted to immediately thank you for taking the time to write this up. 

"Or are you just a new, bad SQL programmer looking for some proprietary kludge to avoid the effort to learn to do it right?" 

LOL, good lord!  This gentleman would toss me...

Thanks for looking at this!  I feel vulnerable to attacks pasting my code : ).  This is just an example with raiserror.  I assume the rest of my code is...

I actually have already tested it, but not against production.  I generally feel more comfortable knowing I'm not doing something out of the ordinary or that's not recommended. 

Thanks a bunch!

Thank you both for the help!  I was able to get the Column_updated() function to work.  Though, I'm sure I would have trouble in a more complicated situation. 

The application...

I wrote up a long message and upon previewing it, it dissappeared.  So, in short...

Programmatically accessing that information could help us find IP addresses or Machine IDs for particular users. ...

Thanks for all the responses!  Knowing it's at least possible will help me approach one of the developers.  Writing DLL's is not quite yet in my bag of tricks.

To add to this question:

The Job and JobSchedule for this job is never changed - I am only working with JobSteps.  The first job is static, always step_id 1, and...

Thank you Jules!