Did you know you can ALTER an existing column to give it the identity property?
If you look up ALTER TABLE in the BOL index, you'll see this:
ALTER TABLE table_name
{ [ ALTER COLUMN column_name
{DROP DEFAULT |
SET DEFAULT constant_expression |
IDENTITY [ ( seed , increment ) ] }
....
I had been telling people for years that you couldn't change the identity property of an existing column, but there is was. And if you can't trust BOL, who can you trust?
Then I looked again.
Oops... this was ALTER TABLE for SQL Server Compact Edition, which has very different syntax in many cases. But the CE entry seems to always come up first whenever I do a search or use the Index. There are some workarounds however.
In the Search Dialog, right under the wide search field, is a drop-list list next to the word "Technology". Click the down-arrow and you'll see a list of checkboxes which allow you pick and choose which elements of Books Online you want to search. You can uncheck SQL Server 2005 Compact Edition. However, that only affects the search operations. If you use the Index, you'll still see CE content. There's good news here too. There is a Filtered by: drop-down list at the top of the index list, and you can choose which content you're interested in. For this list however, the choice is all or one. I can choose just to see SQL Server Database Engine, but I can't choose to see everything BUT Compact Edition.
But wait. I just found out about a really clever trick, from former SQL Server MVP Umachandar Jayachandran, who now works on the SQL team at Microsoft:
You can use the Help Collection Manager in BOL to remove the SQLCE content
entirely. This will filter it from the index too. You can access the Help
Collection Manager from:
ms-help://MS.SQLCC.v9/sqlcc9/html/b06d0f98-ef00-4b03-9f5d-b5c184b8df92.htm
Search for below if you can't use the link above:
Adding and Removing Help Collections
The URL can be entered directly into a browser, or into the URL text box at the top of the main BOL content screen.
Have fun!
~Kalen