Hi,
You can use the stored procedure
Code:
sp_columns_rowset "table_name"
This is an undocumented stored procedure that is shipped with Sql server versions 7.0 and above.
Try it out if your sql version is 7.0 or above.