Hi,

I ran this query no error.. completed successfully..

Whether any data pages are corrupted or not... i have lost two day data in production server..

backup failed for two days

Yes. Raid level problem bad stripe.. but i have 2 days before backup was there.. how to up database to normal status... backup also not worked .. any luck

exec sp_executesql N'INSERT INTO schd_det2

(schd_date,schd_discr_qty,schd_interval,schd_nbr,schd_line,schd_rlse_id,schd_reference,schd_type,schd_domain,USERNAME,DATESTAMP,DOMAIN) VALUES

(@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,''QAD_DATAMART'',''2011-02-09'',@P10)',N'@P1 datetime,@P2 float,@P3 varchar(1),@P4 varchar(8),@P5 int,@P6 varchar(12),@P7 varchar(1),@P8

int,@P9 varchar(7),@P10 varchar(7)','2011-09-05 00:00:00:000',0,'M','P1000189',27,'20101213-001','',5,'1101020','1101020'

this is insert query statement

I have insert data directly into SSMS it taken 2 seconds for 2000 rows , i am used while loop and insert command

But we got that problem data inserted through...

Data insertion through application using procedure ( but i inserted data 2000 rows on ssms it taken only 2 seconds .. )

Lock Pages in Memory privilege must be enabled for the account that runs SQL Server.. is it correct .. any memory related problem

Just now saw the sql error log : " A significant part of sql server process memory has been paged out. This may result in performanence degradtion duration (30 )seconds

I am used below query

SELECT lims2.LOGIN.LOGINNUM

FROM lims2.LOGIN WITH (NOLOCK) INNER JOIN

...