>I'm trying to write a query of the system tables in my DB where I pass it the id of the table - and what I want to get back is the colid and name of the column that is the primary key for the table.

It's not recomended directly query SQl Server system tables. If you're using SQL 2000 see if you can get that info from Information Schema views.