AMAZING! Lowell, thank you for sharing this.

Yes, very helpful when investigating a new database!

I still agree with Steve, if only because I can't abide by not giving everything I can at whatever I do. I would just like to see a...

Agreed. You make a nice distinction between the types of companies and how they treat employees.

I strongly believe that an enlightened company which truly values its people best...

I find far too many people that want to slide by in their job without trying to give more than they think they get from the company. ... they should...

[Edited]

Thank you. I am still learning and am always grateful for the help I get here and how gracious most of the posters are.

@ScottPletcher:

The real problem is you're trying to assign keys before you've even determined the needed entities and their attributes! [/i] That's the big problem with the false notion that identity...

Grant Fritchey (12/18/2013)

---

I could, but won't, argue that identities are a crutch. Natural keys can work fine. I try not to worry too much about the key structure while I...

Another quibble I would throw in is to make each table's primary key an identity field, meaning "an integer that SQL Server assigns automatically to every new record when it...

Grant,

Yes it was homework, but I thank you for taking your time to craft such a gracious (and clear!) answer. Some posters here scorn helping students and I've never...

Lowell,

Good catch! Something bothered me about that EXEC statement but I didn't stop to think about it. An idle question for anybody: are those brackets a problem...

Why the square brackets around [MediaCreateCustomerDataSet] ?

They aren't generally needed unless you're using a SQL Server reserved word or have spaces in the name. Have you tried your...

wat3575,

When you're in SSMS, click View --> Template Explorer. Go to the Triggers section to see 4 different example templates for building a new trigger.

Lots of good education in...

What kind of text file? If it's a CSV or other delimited type of file you can do it with bcp very easily. Look it up in BOL....