I have a control record which contains data which only occurs once in the system (session duration, for example).
I want to have a single row in a table.
How can I enforce this? I'd rather not play around with permissions - simply as I don't fully get all the nuances/levels of security, nor do I know who will have access to the data (I'm the developer, not the user/installer).
So, I thought a constraint would be perfect.
I've got a identity column.
Is there a way to never allow the value for the identity to be anything other than 1?
Or is there another way to enforce a single row for a table?
Hopefully a simple enough question...
Using MS SQL 2005.