Russ-230211
SSC Veteran
Points: 293
More actions
May 3, 2005 at 1:15 pm
#185871
Other than Enterprise Mgr, is there a stored procedure on sql server or some SQL code which will return the column names used to build an Index?
Thanks
Russ
Allen Cui-55137
SSC Guru
Points: 51650
May 3, 2005 at 1:19 pm
#556613
sp_helpindex yourtablename
May 3, 2005 at 1:41 pm
#556619
Too, too, simple!
That does the trick. Thanks for your help
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply