Use this SQL 2005+ query:
SELECT OBJECT_NAME(object_id) AS TableName ,
name AS ColumnName ,
TYPE_NAME(system_type_id) AS DataType ,
max_length ,
is_nullable ,
is_replicated
FROM sys.columns
For SQL Server 2000 use this code
SELECT COLUMNPROPERTY( OBJECT_ID('SchemaName.TableName'),'ColumnName','IsIdNotForRepl')
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809