Hi,

Do ur developer change the views,tables,procs etcwithout nowing u...

....if no then there is a tool called vss in which u can compare each and every it will show u what...

if u r going for SAN there might b some error comes like ur database might go in suspect mode, plz check ur drives .... and restart ur sql...

insert into tablename select * from tablename

use sp_who or sp_who2 active

;)– add temporarily identity column.

alter table tName add tid int identity(1,1)

–query to delete duplicate rows from table

delete from tName where tid not in

(select min(tid) from tName a where a.firstname =...

i was having the same error and i have recovered the data not with the backup but thru a third party tool u r rite (t-55) .......but sory i dnt...

wat will b the querylike???? for this

mmc problem try to resinstal ur windows and sqlserver 2005

wat is the size of ur database

DEAR NO ISSUES REGARING THIS I HAV A TABLE WHICH CONTAINS MORE THAN 300 GB OF DATA ....... FOR PERFORMANCE U JUS DROP UR INDEXES AND RECREATE IT .... AS...