Dear Paul Ibison,

Thanks for your immediate reply.

but if i need to use the sp_repldropcolum

i have to drop all the constraints and the indexes for the particular column.

is it...

All our SQL servers are SQL Server 2000 with sp3a

can this be done?

thanks

ramesh

All,

Any suggestions on the above question?

can this be done?

thanks

ramesh

All,

My point here is, we can't create an index on a view, if the view definition contains tables that resides in other databases, coz to create an index on a...

Your Idea looks pretty good, if we are dealing small amount of data.

in case, if the data grows larger, the performace going to get a hit.

why i am saying this...

is it possible to start a program (with parameters)

from a stored procedure or a trigger.

and the program should run out of process .

i mean not using the same memory...

thanks for the immediate replies.

actually the exe is a program written in VB 6.0

im quite new to this .can you can post script on how to execute this program by...

working fine for me... habdy function

thanks to Erland Sommarskog, and to u, for the link

I guess this is expected behaviour. You can't use @TEMP to pass...