Unable to add the index on the northwind database table. how can we build the index on the northwind database table.
please have a look at BOL : create index ... a lots of exmaples are given regards hsGoswami ghemant@gmail.com "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami
You can even use index wizard to create index in EM instead of directly coding for it in QA. Take an idea of indexing through EM and then code it. Before that as hemant said read more SSP articles on indexing.
What statement did you use and what was the error message you got back? -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
Is this some kind of classroom exercise? Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.