Thanks for your reply ..its working now...

Problem is i have not updated the file location with data base file name ....like 'd:\database' instead of 'd:\database\modle.mdf'

FCB::Open: Operating system error 5(Access is denied.) occurred while creating or...

i don't have backup ..is there any other way to change physical file location of database ?

Thanks for your reply....

How much memory is on the server? 16 GB

What's sQL's max memory setting? 10 GB

What else in running on the server?...

How much memory is on the server? 16 GB

What's sQL's max memory setting? 10 GB

What else in running on the server?...

when check the error log i had seen the msg

"A significant part of sql server process memory has been paged out. This may result in a performance degradation.

Duration:...

example normally my query wont take so much of time but due to some issue in server its taking so much of time In such a case what...

Auto matic check point doing the process frequently when am launching the big reports so i/o bottel neck problem coming ,to avoid such a problem i want stop Auto check...

-- create a source table

create table tv_source(c1 int, c2 char(100))

go

declare @i int

select @i = 0

while (@i < 100)

begin

insert into tv_source values (@i, replicate...

i have decided to use table variable to avoid this kind of lock .i hope this will be better performance . thanks for your reply.

is there any way to prevent the table lock while inserting ?. that is permanent temp table so we are deleting the data from that table at the...

key cloumn will have different value for each transaction then how its locking the other transaction ...

then it show lock at page level or table levle but its showing key levle thats why i am asking ...

how to create the customize report ?