Until a couple weeks ago I would have agreed with the Anders answer.  I've gone the no-PK route in the exact scenario mentioned... tracking logins.  That view changed when someone...

Regarding your second question, the connection manager settings I am refering to are the server name and database name properties.  Knowing these values would help me to figure out if...

A brief overview of the application.

The application was designed so each customer has their own database. There are many customers (a good thing!), with each production server supporting several...

Supplemental ideas, some that conflict with previous opinions.

I rarely start a new database from whole cloth, but tend to come in after the thing has been rolling for a while. ...