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

The best way is to monitor the services. There are lots of app out there (NetIQ, BMC, ServerAlive).

not sure what is needed in EM. Perhaps sysjobhistory has the status while it is running. You could try select access on that.