No one "lost" points. There isn't a total from which we remove them. You earn them, or you don't.

Pints from Red Gate is a good idea, but at the rate I drink it would take me 5000 days to achieve alcohol toxicity.

I was checking dates, and must have forwarded a few years in a click instead of one. Monday next year, look for something interesting.

Alter authorization is a SQL 2005+ command. It didn't exist in SQL Server 2000. If you print out the values and try to run them, you'll see an error.

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

Schema's didn't...

I'd suggest what Grant says, but keep in mind you're going to get multiple result sets.

Should be a fairly simple join with a MAX(), but show us what you have.

Look up computed columns in Books Online.

Is this SQL Server 2000 or 2005? You posted in 2000. Also, you didn't mention what problem you're having, nor what you expect this to change the schema to.

I'm back, everyone have a good week?

ID10T error.

I started with one question, and then changed, rewording the answers and explanation to fit....

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.