Drop identitycolumn

hi.

i want to drop identity column in a table but not though design view, so plz tell the script for that.

Unfortunately, you cannot 'just' remove the IDENTITY property of a column. You have to completely remove the column.

Code Snippet

ALTER TABLE MyTable

DROP COLUMN MyColumn

If you wish to keep the values in the column, and just remove the IDENTITY property, you must first add another column, copy the existing values to the new column, and then DROP the existing IDENTITY column.

|||

This resource might be helpful:

http://www.bennadel.com/index.cfm?dax=blog:24.view

Drill Downs in the Report

I am working on a report in our application, when suddenly a design problem strikes me..how can i make the drill downs to be expanded initially if there is a record to show and not expanded if there is no record to show..is this possible in the reporting services 2005? any help will be highly appreciated..tnx in advance..

GOD bless us..

You can probably do this by putting a visibility expression on the drill down group that uses the IsNothing function to check for data in the datasource?|||i had tried that approach but nothing happened,= IsNothing(Fields!task_name.Value)..is there any way you can see i can do it? is there any more functions to use in this scenario?|||Is it a table dataregion?|||In RS , it is written like IIF(expression, truepart, falsepart).But it doesn't work.
You should think like IIF(expression, falsepart, truepart)
So you should write = Not IsNothing(Fields!task_name.Value)