Классика :-)

if object_id('dbo.sp_desc') is not NULL drop procedure dbo.sp_desc
go

CREATE PROCEDURE sp_desc
(@tablename varchar(50) )
AS begin

select cast(column_name as varchar(15)) name,cast(data_type as varchar(15)) type,
length = case when isnull(character_maximum_length,0)>0 then
character_maximum_length
else
numeric_precision
end
,is_nullable as 'NULLS?'
from information_schema.COLUMNS where table_name=@tablename

return(0)
end
go

--exec sp_desc 't_Order'


DECLARE @table varchar(80)
DECLARE tab_desc cursor
FOR SELECT name FROM sysobjects WHERE type = 'U'
-- OR type = 'S'

OPEN tab_desc
FETCH next FROM tab_desc INTO @table
WHILE @@fetch_status = 0
BEGIN
PRINT @table + char(13) + char(10)
EXEC sp_desc @table
FETCH next FROM tab_desc INTO @table
END
CLOSE tab_desc
DEALLOCATE tab_desc
GO