thanks i got your point

Can you please send me sample query

and why i am gettign key lookup ? , i have made covering index...

Use Sp_who2 and sp_lock to find out spid which are creating problems

nice video

Why you require this ?

but if you want to see how indexes...

Post your table/index defintions

and also see link below my signature to get faster response on your posts/queries.

on what basis, you say so ?

dbcc sqlperf(logspace)

With Static memory allocation once the maximum amount of memory allocated to SQL Server is reached it will never release the memory. Even if another process needs it. If there...

if possible restart sql server.

your are peroidically restarting the services ?

then post...

Is this problem get...

try this approach on serverA mgmt studio

INSERT INTO [serverB].dbname.dbo.serverB_table(object_text,created_date)

SELECT cast(object_text as nvarchar(MAX) ),created_date FROM dbname.dbo.serverA_table

this is the approach , you can take

use [TestDB]

GO

GRANT SELECT ON [dbo].tablename TO [loginname]

GO

use [TestDB]

GO

GRANT UPDATE ON [dbo].tablename TO [loginname]

GO