Help on 'Alter Table' command
I need help with Altering the table to add an identity row in my stored procedure.
I am bulk inserting data from a .csv file and then adding an identity column to it so that i can work on rows inside a loop. But the column that i am adding is not getting recognized and it throws an error. Checked at profiler but i don't see SP:stmtCompleted for alter command though SP:stmtStarting is recorded. Is there any other way i can make this alter work?