sp_help <tablename> sp_helpindex <tablename>

How do you know which index a table is using?

Question Posted / visala

Answer Posted / visala

sp_help <tablename>
sp_helpindex <tablename>

Is This Answer Correct ?

9 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the simplest way to create a new database in ms sql server?

958

Detail about query optimizer?

1037

How can sql server instances be hidden?

896

Explain features of analysis services?

926

Define left outer join?

927

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1042

What is explicit mode in sql server?

1018

How to execute multiple stored procedures at one time in sql server?

945

Does sql server 2000 full-text search support clustering?

816

List the advantages of using stored procedures?

999

What are the differences between user defined functions and stored procedures?

1007

What is Transparent Data Encryption?

942

Does group by sort data?

848

Explain the third normal form(3nf)?

896

How do I find the sql server database version?

942