Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Finding New Indexes

Author  Topic 

kkozinski
Starting Member

3 Posts

Posted - 2001-03-29 : 13:14:21
I have a production DB on ServerA and a test DB on ServerB. In a flurry of performance tuning, I added several indexes to the test DB. Now I want to move those indexes to the production DB.

I'd like to run a query on the test DB to list the new indexes. How can I display the creation date of an index?

   

- Advertisement -