As part of work that I was doing recently, I had to generate the creation script for a SQL Server database. While running through the Generate Script task in Management Studio, I received an error that indicated that the stored procedure was encrypted.
Read More...
While the use of AutoNumber and Identity fields in tables is greatly applauded by database designers the world over, they can be annoying for developers to use. In this article we look at techniques available to determine the id for recently added records in both SQL Server and Access, with an eye to the pros and cons of each approach.
Read More...