Thanks guys, so no shortcut for it, guess I'll just have to make the painful task of opening and saving using BIDS 2008.

Grant Fritchey (10/16/2009)

---

Layne-812700 (10/15/2009)

---

whatever size or type of data I use, they present the same result. You might disagree, but the first one is only a shortcut in my opinion.

Also,...

whatever size or type of data I use, they present the same result. You might disagree, but the first one is only a shortcut in my opinion.

Also, had a debate...

Edward, they don't like to change the structure for simple requests from users like that. Fortunately I was able to grab a tutorial on tracing, made it as a stored...

thanks everyone for your very helpful tips and advice. I guess my basic normalization training is still alive and kicking. 🙂

steveb (7/29/2009)

---

You seem to have a perfectly good natural key in the Student Table of StudentNo, but you have added a column xId to act as the identity column....