SQL Server 2000 user Utilities

You do not need to query the system tables, you can also create an ordered list of columns through the Object Browser in the Query Analyzer. SQL Server version client utilities provides such a method (SQL Server 7.0 is also available). If the Object Browser is not open, you can click on the toolbar | Object Browser | display/Hide options, or press F8 to open. In Query Analyzer, the Object Browser is displayed in a window to the left. In this window to the left, there will be a list of databases. Open all of the following options: Select the box with the plus sign displayed.
Expand a database.
Expand the folder for the user table.
Expand a table. You can see a column of folders.
Click the column folder and drag to the Query window.
Now you get a list of ordered columns (no chain) without having to query the system tables. You can use this list as the starting of a select list of queries.