Thank u, now recovered but still am getting one transactions like

Oldest active transaction:

SPID (server process ID): 123

UID (user ID) : -1

...

Hi ,

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build...

Thank u so much , I just made small alternations that is DISTINCT for removing duplications & LTRIM & RTRIM for removing white spaces..

Its amazing working fine,,,

Small changes i done from your query

SELECT TOP 100 Author,LEFT(author,CHARINDEX(',',author)-1)AS FIRST_PART,

SUBSTRING(author, CHARINDEX(',',author)+1,LEN(author) ) AS SECOND_PART

FROM Table WHERE Author LIKE '%,%'

Thank u sir,

I forgot the charindex functions.. thanks for you output...

Thanks for replies, I will keep the old backup file at least 1 month ...

Thanks.....

Thanks your for your replies, here we will keep the Backup files at least one month,.

I understood everything ,Sorry for my bad English,

Actually we are taking the backups weekly once, after two weeks we will delete the old backup files,

But still our one of...

Am not serious, My problem is unable to understand our Gila replies..

If we have full recovery model , can we do that? and how?

Thank you so much..

My problem is track number generations, now i got a solutions , thanks... Location...

Yes, Table name is Location_master

The columns are like :

STATE , LOCATION_ID , TRACK NUMBER, ETC..

HERE THE DATA's WILL INSERT INTO LOCATION_MASTER

BUT WE NEED TO GENERATE THE location_id...

Sorry Network problem unfortunately i made two times...

THANKS GREAT.....

Thank you so much...........