View Single Post
  #1 (permalink)  
Old April 14th, 2006, 11:14 AM
charuni charuni is offline
Registered User
Join Date: Apr 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to charuni
Default 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?