Jon.Morisi (2/27/2013)
If I create an INDEX like the following
CREATE NONCLUSTERED INDEX [IX_table_col1_col2] ON [dbo].
(
[col1] ASC,
[col2] ASC
)
WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = ON) ON [PRIMARY]
How do I check up on it to see when it's 100% completed
You'll get the following message when it's completed if you're running this from SSMS... just like any other query.
Command(s) completed successfully.
--Jeff Moden
Change is inevitable... Change for the better is not.