Another option is to detach it. The only reason I mention it is some applications which look for databases, such as Microsoft CRM (oh, joy), may error out when it...

I'm probably going to Week 2, for IT Pros. But then again, I'm facing the upgrade to Windows 2008 Active Directory.

ahenderson (2/14/2008)

---

I read it in the Microsoft technical article that you can download here:

This is the part of the article that I read:

Best practices for database ownership and trust

•Have distinct...

SQLBill (2/14/2008)

---

I've heard the exact opposite. You should never have a user own a database unless absolutely necessary. If the user account is dropped and they still own a...

That's permissions within the database. Are you worried about users having too many rights there? Because those rights don't carry out to AD.

Also,...

Strictly speaking, it's not necessary. A lot of organizations do it because of convenience. But I've seen cases where it's locked down hard.

The question is responsibility and accountability. If...

When you say it had write access to an AD group, can you explain a bit more what you mean?

SQL Noob (1/31/2008)

---

we have used ESX for years now with VMotion and the works and it works great for things like weblogic instances where in the past you would have...

3. Only compromise if configured correctly is underlining linux platform.

...

5. Believe me Windows is x100 more likely to crash than linux. Never has the ESX platform crashed on me...

It looks like you're missing a few single quotes, but those may have gotten dropped by the forum software.

1) Is the job owned by sa or another member of the...

rgriffin (1/30/2008)

---

I'm not well versed in vm, but it seems to me you lose the ability to control the physical location of important database components like log files and the...

Another vote for Password Safe. There is also a Portable Apps version meaning if you copy the electronic files off like Steve indicates, you just have to a USB key...

Whoa. There's a lot of stuff being thrown out, let's work through it.

BUILTIN\Administrators corresponds to the local Administrators security group for the OS. Before you go about looking to revoke...

Jack Corbett (11/27/2007)

---

With respect to the features, service broker can be extremely helpful, but only if you intend to use it. Doing SOA via SQL Server (HTTP endpoints) saves you...

Unfortunately, no. In syscomments it...