I used to list from sysobjects to get this information, but found the INFORMATION_SCHEMA is a lot easier.
2001-08-22
714 reads
CL-Graham,
2003-05-05
I used to list from sysobjects to get this information, but found the INFORMATION_SCHEMA is a lot easier.
select TABLE_NAME, ORDINAL_POSITION 'Col No', substring(rtrim(COLUMN_NAME),1,25) 'Column Name', substring(DATA_TYPE + case when DATA_TYPE like '%char%' then '(' + rtrim(convert(char(3),CHARACTER_MAXIMUM_LENGTH)) + ')' else '' end,1,25) 'DataType' from INFORMATION_SCHEMA.COLUMNS order by ORDINAL_POSITION
You rated this post out of 5. Change rating
2001-08-22
714 reads
2001-08-22
366 reads
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
652 reads
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
399 reads
2001-08-22
699 reads