I'd suggest that the PK on your person table be the user's Windows login name. Not too many people forget that.

Brian mentions another system table that I was thinking you might try putting a trigger on to capture the creation of a table, syscolumns. I'd be curious if that...

You have a terrific site here which will no doubt continue to grow in popularity. I'm certainly enthused to see that you are working on your infrastructure and look...

You might also want to look at this topic from last August:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=765&FORUM_ID=23&CAT_ID=2&Topic_Title=A%20better%20way%20of%20generating%20numbers%20than%20identity&Forum_Title=General

or a NOT EXISTS

To keep the leading zeros in Excel or keep the original format of the data (e.g., DEC1 will, by default change to December 1st) you can either format the column...

Though your question is about the best data type to use, in my mind there is still a big question about data integrity which Antares touched upon.

I see no problem...

If you have the "guest" user account set up in the "data" database then the permissions tied to it would flow through to the logins in the "SP" database that...

I've been using ErWIN for a lot of years. It's better than it used to be and I especially like the ability to report to HTML which I then...

I tend to have times in my fields so I typically do a BETWEEN and convert my end date to a varchar with a time element of 23:59:59. Probably...

An item that SkiMan mentioned is why I was told I shouldn't have the users run reports off our BCP server that is managed through log shipping. I was...

Sweet. I think David's solution is a real winner. I'd also vote for explicit conversions. When I tried out David's code I did that out of habit....

Can you see my red face?

You are quite right. A TRUNCATE TABLE would hit the FKs. It only side steps the triggers. The other option would be...

If you truly want to have a db with no data you should be able to restore a db to a new db, with the data, and run a script...

My experience with UDTs has been in Sybase but I won't use them anywhere again.

I use to think UDTs where pretty cool about 9 years ago when I was told...