sorry

😀

But can you see the image

plz comment on the attached image

i simply asked the reason of the below error

CREATE INDEX IX_SDN ON ITM_Alerts(SourceDomainName)

Msg 1919, Level 16, State 1, Line 1

Column 'SourceDomainName' in table 'ITM_Alerts' is of a type that...

i simply asked why the below error came....... was it so tough ....

CREATE INDEX IX_SDN ON ITM_Alerts(SourceDomainName)

Msg 1919, Level 16, State 1, Line 1

Column 'SourceDomainName' in table 'ITM_Alerts' is of...

you caught me!!!!!!!!!!!!

but it didnt work..................................................... 😉

i am getting error

please help me with the error

CREATE INDEX IX_SDN ON ITM_Alerts(SourceDomainName)

Msg 1919, Level 16, State 1, Line 1

Column 'SourceDomainName' in table 'ITM_Alerts' is of a type that is invalid for use...

There is no indexing on the table and yes i am reading 100%

Can you provide me the steps of indexing in SQL Server 2005

Are you sure this need to be like '%XXX%' from the data you provided 'XXX%' would suffice, that would be faster to process.

Both the above are taking the same amount...

Hi Thanks a loads its working