List out all columns that are set as Identity columns in the database
2001-08-22
714 reads
Robert-Vallee,
2001-08-22
List out all columns that are set as Identity columns in the database
DROP PROCEDURE hx_ShowIdentityColumns go /* Robert Vallee 01/11/2001 rvallee@hybridx.com input: None output: Table format Desc: List out all columns that are set as Identity columns in the database. Warnings: None. */ CREATE PROCEDURE hx_ShowIdentityColumns AS select o.name as Table_Name, c.name as [Column_Name] from syscolumns c, sysobjects o where c.id=o.id and (c.status & 128)=128 order by o.name,c.name
You rated this post out of 5. Change rating
2001-08-22
714 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
2001-08-22
541 reads