I have done it without a problem. When you define a publication in SQL2K there is an option to indicate if all the subscribers are SQL2K or not.

Andy

I think you might be referring to doing it in Query Analyzer,there you can right click anything and select "send to window" or "send to file". Faster than the copy/paste...

I don't think anything wrong with your code, sounds like you are off by one on the length of the "record". Are you accounting for a record delimiter of some...

I haven't tried it yet, know we have a project where we're considering something similar. Seems like it would be doable, use form fields in the template, then based on...

Good point. The built in encryption in both Access and SQL so far has been weak, designed to make it harder to get to the data or the stored procedures,...

I haven't tried this, but it looks promising:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_5mwe.asp

"Microsoft® SQL Server™ 2000 introduces the ability to programmatically associate up to 128 bytes of binary information with the current session or connection....

SP_Change_users_login is what you're looking for - there are a couple of articles here on the site that discuss it. The ID's are mismatched between sysxlogins in master and sysusers...

I guess one question would be are you testing on the same spid you're logging? Not using two different QA windows to test? Another is from your client app if...

If its all or nothing you can use the datareader/datawriter roles. Other than that yes you'd have to do it one at a time, easy enough to do a loop...

Does the service account have disk permissions too? Try using RunAs (if you're on Win2K) to test the app separately.

Andy

Tom, I'd be interested to see your code, never hurts to see more than one solution. Written but untested (sorry, had removed the named instances I use for testing and...

Are you sure you're triggering changes that meet your criteria? I'd move the code from the trigger into a proc and set up a fake inserted table to test against....

If you know there will be a max of three then I dont think you need recursion, just self join to the table twice with a left join.

Andy

Dont you need a where clause on the first update?

Andy

I'd go with which ever one you have more experience with. If you're not experienced with either one yet then I think SQL2000 makes more sense. No idea about study...