I do have a seperate business that I manage during the two days a week that I am not working with the databases. And for me, it's incredibly healthy...

I was lucky in that the 3 days a week schedule was agreed upon easily during the final interview. I suspect that in many cases it might be necessary...

Aaron,

Great story! I'm sure you will find a position where you can bring your skills to bear if you haven't already.

Like you, I got hooked on databases after a...

I come in three days a week to do the DBA work for a small financial firm in Seattle (~100 employees). It has been an excellent arrangement on all...

I meant to set @cmdstr to a string of switches in the code snippet above.

I guess the question is really whether sqlmaint runs in a 64 bit environment, especially when...

Creating an alias seems like it would add another dimension to the problem. I would like to simply create a linked server for use in T-SQL commands within SQL...

Update on the SQLOLEDB missing provider problem.

The dll existed in the Program Files, so I used RegEdit to unregister and re-register it. That caused it to show up as...

Thanks for the suggestion. And it may be a solution, although we do have SQLNCLI already present and it works fine for our distributed queries, just not for the...

Scott,

I totally agree that retaining control of the database creation and naming is a better way to go. I had downloaded from TechNet two articles: "Deploy using DBA-created databases"...

More FYI,

I confirmed that I can create a database with a hyphen in the name if I use the square brackets, but not otherwise.

Meanwhile, I used the alter...

Yes, the command worked when I put the square brackets around the database name. I had thought that the dashes, "-" were illegal characters in the name of the...

Thanks guys, I'll study up more along the lines you suggested. I already believe in performing periodic restores from backups to prove that the system works, so it's valuable...

Books OnLine will give you info about using the procedure sp_changedbowner to replace "sa" with another owner. You are correct, you cannot change an existing user with access to...

Excellent article on a topic I thought I already knew. Thanks for going into the subject in depth.

Elliott

Thanks Jeff and Hans,

It looks to me like Hans' solution is equivalent to Jeff's in that Hans makes a lookup table on the fly. I chose to make a...