You cannot rename fixed roles (provided by SQL Server), as Lynn noted.

For custom roles, if you want to move people from db_datareader, you can query the role to find members.

EXEC...

http://msdn.microsoft.com/en-us/library/ms189775%28v=sql.90%29.aspx

jackimo (3/26/2012)

---

It does make me think about the storage overhead for a Relational Database, log backups, install, TempDB, full backups. For every GB of data we probably need 3...

It is good, though a lot is left out, despite the 2:20 time.

Read the books if you haven't, they're great.

Anyone else going to see The Hunger Games (or seen it)?

My 13 yr old is rallying the troops to go see it tonight.

AW2008 is filestream enabled, so if that's what you need, use that. If you want to avoid FS, go R2 or 2010.

Rod at work (3/20/2012)

---

Gail, I've seen job postings like that, too, where such a person would be a superman/superwoman, if they knew well all of the skill sets listed. ...

I tend to agree with Anthony, but a few more things.

Don't delete old backups until the new one is made, so take that into account.

In terms of backups, are you...

I tried it for a couple weeks, but it just seemed like I got some slightly...

Looks like the site isn't updated and you have to call MS to get a price.

US: (800) 426-9400

Canada: (877) 568-2495

Lynn Pettis (3/22/2012)

---

Glad you agree, because I went back and read through everything again to see if I could figure out where I got annoyed. It was after he...

kaspencer (3/22/2012)

---

Why is the number of errors in Questions of the Day so great?

How are we supposed to interpret typographical errors?

I have yet to build the stored procedure SP_ESP so...

My apologies for the question. Yesterday was a holiday for me, so I'm getting back today.

The typo is corrected, and thanks to all who pointed it out. Points have been...

Randy Rabin (3/21/2012)

---

Oh, and Steve - I clicked on the little graph above your post expecting to see some relevant data. Took me a minute to realize the time frame...

Hmm, just ran a test db, in compat mode 80, and CROSS aPPLY works, as does a select from missing_indexes.

SQL2K8, SP1

CREATE DATABASE sql2kCompat

;

go

ALTER DATABASE SQL2KCompat

SET COMPATIBILITY_LEVEL =...