SQL 2000 Alter Table not working in stored procedure... 1

[Webkins]

Hello...
I am using SQL2000. The following code works just perfect in the Query Analyzer but fails when executed in a stored procedure:

ALTER TABLE partspec.dbo.double ADD auto_number INT identity

I am trying to insert a column with an automaticlly generated ID number. Any suggestions?

Thank you so very much.

 

[gmmastros]

Try this:

Exec ('ALTER TABLE partspec.dbo.double ADD auto_number INT identity')


-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[yelworcm]

Why is an alter table command in a stored procedure? Stored procedures are generally run many times, but alter table statements tend to be run only once.