You should be able to do this, but keep in mind MSDE dies at around 5 users, which is easy to use unless you are talking very small scale web...

If it's full, then backup transaction with no_log should help. Be sure you then take a full backup as you won't be able to point in time restore.

Check the sQL...

Maybe this: http://support.microsoft.com/default.aspx?scid=kb;EN-US;110507

I manage 10 DBAs in a multi-platform, enterprise shop that supports a 12,000 person company. Here the production DBAs have access to production and development. Development DBAs have access to...

If the table and filegroup are consistent within themselves and there are no changes to other tables that affect then, then consistency shouldn't be an issue.

Other than for performance, filegroups...

Haven't really looked at this. It seems boot camps are good for preparing you for the test, but not for learning. That's a gross statement, but what I've seen.

look up charindex, patindex in BOL.

User sends email to you.

You create view.

This is correct. There was a vendor at PASS 2003 that had a windows auth driver for Java, but that's the only one I've seen. I believe it isn't allowed...

I echo most of what's above. Stability and Security need to be to notch before this is released. I wouldn't mind some interim release stuff, but more I'd like more...

select @myvar = @@rowcount

Interesting idea and thanks. If I get some time, I'll try to look into the tempdb thing.

I didn't think of it, but a restore makes sense. Be sure that your integrity has not suffered before you go any further.

You can set the retention for the jobs in the history tables.

The with INIT should overwrite the previous backup. Not sure why it doesn't work here. I take a different approach. I make a new filename everyday, so I have the...