Viewing 5 posts - 1 through 5 (of 5 total)
By looking at the other posts, I think that some are confusing Primary Keys, which should only be used for referential integrity and not used by humans, and Reference Keys,...
September 15, 2011 at 8:41 am
Here is part of what I do...
CREATE VIEW [dbo].[DataDictonary] AS
SELECT schemas.name AS SchemaName
,all_objects.name AS TableName
,syscolumns.id AS ColumnId
,syscolumns.name ...
November 30, 2010 at 4:04 pm
Here is a view that I add to my databases that I use to create a column level data dictionary. I think I will incorporate the ideas from this article...
November 30, 2010 at 12:26 pm
If you want to see an interesting use of one time passwords check out GoToMyPC
From there documentation:
One-Time Passwords
The use of One-Time Passwords (OTPs) offers an additional level of security
that can...
November 4, 2010 at 10:45 am
This could be done by adding two columns to your user table. They are:
LoginCount int null
AllowedLoginCount int null
If AllowedLoginCount is greater then zero, this is how many time they can...
November 4, 2010 at 8:23 am
Viewing 5 posts - 1 through 5 (of 5 total)