 | Note: Ensure that you are logged in using the AgfaService account; you cannot log into SQL Server Management Studio using the Administrator account. |
This procedure applies to SQL Server 2005 and SQL Server 2008.
To help you in troubleshooting SQL Server problems, find out what indexes are on a table.
To determine the indexes on a SQL table
In the SQL Server Management Studio, open a new query window.
Type sp_helpindex table_name
where table_name is the name of the table you want to find indexes on.
Click Execute.
The index list and their properties are displayed. Ignore the entries starting with _WA as they are temporary indexes created by the server. The server discards them.