I'd have to check, but I believe that there is a 1 or 2 byte offset that is stored in each row. There might be a 1 byte placeholder at the offset...

Apologies for this. I have censored the post.

Use a semaphore or flag on each record to note that it's locked, or better yet, the FK of the user ID that actually has it locked. So retrieve a...

There might be a script to help in the scripts section as well. Not to toot my horn, but I wrote some articles, all entitled Tame Those Strings (search on...

You can try, but I doubt it as well. I agree with Mark that if you want to read the log, Lumigent, ApexSQL, LogPI are all good candidates for reading...

If it's full, use the no_log instead of trunate_only. I usually follow Franks advice when I need to shrink one.

I agree with renaming the job, but you cannot do this until the originating_server column in sysjobs is changed. The question was aimed to test knowledge that this is the...

Strange. Can you upgrade the Access db locally and then transfer the data to the server?

sorry to hear that. a good reason not to use EM to edit and instead use a flat file in Query Analyzer that is under source control.

There are a few editors that might help. Not sure which one would do what you want. Try Imceda (http://www.imceda.com), they have an IDE. Also ApexSQL Edit (http://www.apexsql.com)....

We can try. I try to get them moved as soon as I can.

I don't think there is a setting at the db level. Either connection or the server default.

You can log a limited amount to disk. Not sure there's a good way to do this.

I prefer to bind the default, but I'm not sure there's a functional difference. Might be easier to read if you choose the name.

No.