Thanks Russell!

My requirement is to do it through a query...

Regards

Arun 

sushila,

THANKS(big one)!

That solved my 2 day search on books online(this shows how bad i'm), i was trying my hands on columnproperty...

And now from sql commands i'm migrating to combining these commands...

Charles

Thanks a ton that worked like a chum...can't we do it for a single column.

Just now learning all the sql commands from books online, do let me know how do i...

Andy,

Thanks! I tried the above code...and found that without the GO statement the procedure was created and then when i manually executed the procedure, it gave an error after 32 iterations...with...

Soctt,

My requirement was to find the datatype of the column hence i tried the following query

select 'au_id' from information_schema.columns where table_name = 'authors'

I'm using the pubs database and in that...

i found my procedure listed under object browser...but when script object to new window and saved it, and when modified everytime it took the help of query analyzer to drop...

I did as per your directions...and there i notice odd number of GO statements, don't they need to complement each other, one signals the start and the other signals the...

As per every1's advice i'm using the query analyzer...they have asked me to abstain from Enterprise manager.

one more finding is on execution of the previous procedure the output was "1509580416"...

guys do u mean to say whatever is included in the go statement would be the first one to get executed...do let me know if my understanding is correct. 

i'm...

Thanks Sushila & Glenn for their inputs...found to be simple and interesting.

Regards

Arun

oops that was my fault, after i posted there i found this folder for the newbies, hence posted it again...

Thanks for reminding.

Regards

Arun