tsql - How can I check if a SQL Server Index has been created ONLINE or OFFLINE? -


we have number of indexes in our database , number of environments we're deployed in, each use different version of sql server.

i'd able run report check if indexes created online or offline.

i've tried various t-sql queries on sys.indexes , beyond can't find anything.

google hasn't helped, here's hoping on wisdom of stack exchange


Comments