The first index was created when primary key was created on ID column. So it means, instead of creating a new index, I just need to modify the existing index?

Also...

I went through the link but was not able to get much.

cheers

Siddarth

thanks for the link, will get back to you after reading the same.

Cheers

Siddarth

CREATE UNIQUE CLUSTERED INDEX [IX_R] ON [dbo].[R]

(

[ID] ASC

)

is the index created on table R

sorry for the inconvenience caused.

Yes, I came to know while reading the blogs and from that I got the table names 🙂

I will remove the same from the post.

But I am still not getting...

When I fired the following sqls : i dint got any results which is strange for me:-

Select * from Sys.Objects where object_ID =72057594049789952 OR parent_object_ID=72057594049789952

Select * from Sys.Objects where...

thanks everyone for the contribution.

the issuse came as I changed the @string parameter from Varchar(8000) to Varchar(Max) and the solution was posted here where the start was casted into int....

I am not able to complie the function because of Varchar(max) for @string parameter.

I have tested the same by setting to 1 but seems i made a mistake somewhere and didnt got desired result.

thanks for the same.

cheers

If I set the SEED to 1, the Indentity column will have the value of 2, please correcat me if I am wrong.

cheers

the issue is sorted for me 🙂

once again, thanks

thanks alot for the help 🙂

Cheers

Siddarth

We dont have any product for parsing the transaction logs. We also dont have any audit or trace running on sql server. The issue is some one has delete the...

Fine, I will take care onwards.

Cheers

Siddarth