Would advice you to run tuning advisor and analyse the index it returns..

or see if below suggestion resolves key lookup.

Include below columns in index [HumanaAuditClaims].[dbo].[ClaimLine].[idx_ClaimLine_ClaimSummaryUID]

[HumanaAuditClaims].[dbo].[ClaimLine].ClaimLineUID, [HumanaAuditClaims].[dbo].[ClaimLine].ChargedAmount, [HumanaAuditClaims].[dbo].[ClaimLine].PaidAmount, [HumanaAuditClaims].[dbo].[ClaimLine].RevenueCode

hvermaak (6/5/2013)

GilaMonster (6/5/2013)

I would strongly recommend...

do check which process is taking up high CPU.. is it sqlserver or any other process.

you can check SQL source control from red gate. Also, having scripts in database is kind of similar a document store. Do more research on document store..

you can use a version control tool for it.

Hi Sarab - thanks for the info.. will get in touch

I didnt. Msg me ur contact details. Probably we can start one 🙂

what exactly you did??Did you tried to login into the other server with the username you created.

create a username in both domain with same name and password. I have tested for a workgroup and domain...

does that means that any one with permissions on table can access the data even if it is encrypted?

any suggestions....

homebrew01 (7/21/2010)

Why ? You will miss out on many 2005 benefits.

OP: This has been covered many times....

run the upgrade advisor and look for issues.

If every thing is fine then script out the logins at 2000 - google how to transfer login between sql servers.

Then use backup/restore,...

got it...a known isu..must have googled before posting .. 🙂

linked server is on A and am just accessing it from server C.