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.

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