Help Again: Find out the data-type of a column

[Pho3nix]

Need to convert a nText column in SQL but dont know which column it is..well what I'm trying to convert is a view.. Could that be the problem? Any help would be appreciated.

 

[diabolus]

Tried the standard stuff like this?

select st.*,sc.* from sysobjects so
inner join syscolumns sc
on sc.id = so.id
inner join systypes st
on st.xtype = sc.xtype
and st.xusertype = sc.xusertype
where so.name = 'YOUR VIEW/TABLE/OBJECT'

 

[tkburn]

SP_HELP 'your table name'
will give you the column names and type within that table