I've heard folks use GUIDs when passing ID's in URLS. When you have UserID = 100, someone can type in 101 or 99 and display information that way. When...

Interesting...so a GUID is unique value across dbs and the world? So regardless if we're using GUIDs in SQL Server 2005...then migrate to 2008, we won't have an issue?...

Hey Jeff,

Thanks for the reply! I like your way also...

Can you explain what the "U" is used for then? We didn't have that in the other example...

Thanks...

Awesome reply! Thanks so much...

So, the naming convention makes sense now. I haven't really worked too much with the middle part of the schema (the middle part...

So always use the db_login for asp.net code....not the actual db_user. Got it.

Ahhh, makes sense. Have a 1:1 relationship for a db_user and a db_login. So if...

Great...that helps alot! So if I have a 'manager_login', and associated with a 'JohnDoe_user' db user, should I use JohnDoe_user within my Asp.net code? My guess is yes,...

I understand that the login is for the db server, but when associating a user to a login does what? Part of my understanding is to merely associate the...