Can I Alter any of the table through stored procedure. I tried but it didn't
work, if any one guide then I would really appreciated.

Thanks

It works good for me in SQL 2000 and SQL 2005. See the sample below.

create table xx( i int)
go
create proc xproc
as
Begin
alter table xx add j int
End
go
exec xproc
go
select * from xx

Thanks
Hari

"Rogers" wrote:

Thanks Hari, can you try this one. It wont work from my side.

create table xx( i int)
go
create proc xproc
as
Begin
alter table xx add j int
End
select * from xx where j is null
go

exec xproc
go
select * from xx


"Hari Prasad" <HariPrasad (AT) discussions (DOT) microsoft.com> wrote