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.

100 roles! Yikes. I've never had that many, but I suspect it's some type of bug.

I'd learn the T-SQL and just script it.

Did you set the test server to allow SQL logins? Server | Properties | security tab