See, this is why I make making friends with the network admins and email admins my #1 priority when I start in a new company 😉 Well, right after...

And, for code, be sure to check all the NULL checks.... Major change happened there from 6.5 to 7.0

I did photography a lot earlier in my life, mainly aviation photography and motorcycle road racing. Now motorcycle riding myself. I think in the IT department where I...

Yeah we considered that last approach, but sounds kind of risky (due to the nature of the data).

Would it work to make a user defined function that would do all...

I grew up in Norway, learned "proper" in English in school. At some point could even speak cockney English with the natives. Today after having lived in the...

When SQL 2005 came out I told my boss that if we had no plan in place for upgrading to it within a year of release I would change job.

I...

I think being asked to define acronyms is fine in an interview. So much of my jobs have been interacting with higher ups that might not know what ACID...

Yeah we use roaming profiles. ONe would think they would exclude service accounts from that, but could note get my network people to say anything else than that roaming...

I don't write articles for here (or anywhere). I do however try to document fixes in the forum to problems I have asked for help with. Figure that...

I guess I should have also said that the 3 systems I have seen this message on when doing restores from a remote server, there has been network issues every...

Oh, I read all the time. This website, SQL Magazine, various blogs, books. But last certification test I took was 7.0 Design and Implementaion.

I said I was weird about it 🙂

With 10+ years experience, and no degree, I would consider getting a degree in something not CS related. Open your eyes to other lines of work, or even make...

If you have the room on the server you are restoring too, restore with a different name, then at the end of a succesfull restore, drop the original database and...

Lowry Kozlowski (5/8/2008)

---

I agree that asking about a Resource database is misleading and incorrect. In the system db .mdf files master.mdf refers to Master etc. so mssqlsystemresource.mdf should not be...