Lotus Notes is an integrated desktop client option for accessing business e-mail, calendars and applications on [an] IBM Lotus Domino server. The Notes client is mainly used as an email client in large organizations, so some of us have to work with it. I, personally don’t like it because it is not user friendly (see [...]

An Identity column in SQL Server is used to auto number the rows. See this great post on Autonumbering & Identity Columns. When you delete rows from the table, the identity will not reset but you have few options of doing it yourself. The SQL Server Management Studio GUI doesn’t support this option…
1. DBCC CHECKIDENT
This [...]