Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  The xusertype field

Author  Topic  rbryan Starting Member 2 Posts Posted - 2001-01-29 : 20:15:45 I have a function that accepts a stored procedure name and returns a recordset of the parameters and their data types for this stored procedure. It does this by interrogating the sysobjects, syscolumns, and systypes system tables. (Yes, I know I'm a naughty boy) I am currently joining on the usertype field, but I noticed that this field is actually computed, but there is another field, the xusertype field, that has an index on it. What is the difference between the usertype and xusertype fields? What is the best column for joining the syscolumns and systypes tables? Rob Bryan Aspect Computing Pty Ltd