HI

i am getting severity level as 1

Sorry i have corrected the POST.

Hi

I am executing one SP from SQL agent job and i have used the error handling in SP using try cTHIS IS CLEARLY SPAMthod...

Hi,

I am also facing same problem and in my table i have one clustered and two non-clustered index's, two types of triggers INSERT/UPDATE and i don't have foreign keys in...

Finally I have created one script and it is working for me.

DROP TABLE #temp

DROP TABLE #temp1

DROP TABLE #temp2

--CURSOR TO FIND ALL INDEX'S IN ALL TABLES.

DECLARE @TabName varchar(100)

CREATE TABLE...

Yes, i have to take care of all null values because in our database we should not insert null values on indexed columns. and now my database size is 100GB,...

Hi Lange,

This a one time analysis process only.

Thanks dear it is working now.

Hi adnan,

While compiling your code i am getting the errors like below.

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 10

Incorrect syntax...