This is somewhat rough, but I think addresses your last question.

SELECT		syob.name 'ObjectName',

--		syco.name 'ColumnName',

--		syco.type,

		syob.type 'ObjectType',

		syus.name 'UserName'

FROM		sysobjects syob

		JOIN

		sysusers syus

		ON syob.uid = syus.uid

		/* If you want column data

		LEFT OUTER JOIN

		syscolumns syco

		ON syob.id = syco.id

		*/

WHERE		syus.name = '<username>'

Regards,

SJTerrill

Edited by - TheWildHun on 06/26/2003 1:43:30 PM