There is a problem in my servers as well that starts from 2008 data.

I dont think any these jobs are still running which i can get from "Job Activity monitor".

If...

Hello,

sp_change_users_login will update the users, why do have to delete and update for each DB.

Note this is a old thread.

Great this is the one i worried a lot, thanks OPC i'll try and getback

thank you guys

Thanks OPC, we dont have SSIS.

we are moving to different domain and server so this is not upgradation.

Is there any way to do reports migration and individual user accesses...

Thanks gail and any other thing do i have to take care

Any one about point 3.

JC-3113 (5/14/2013)

---

Hi Jeffrey

thanks for the input

that takes me back to my original issue

I am rebuilding indexes on sat night after my full back up

what happens then is that my differentials...

Hello,

You need recent differential backup only .

The size is disadvantage of defferential backup and if you want to over come that go with a log backup.

Can you connect to the linked server using the userid and password.

i hope that is password issue.

Thanks both of you.

BufferPoolCommittedMemoryGB and BufferPoolTargetMemoryGB showing 1.56 does that means it is using only 1.56GB of 8GB (AWE is not eanbled )?.

thanks but sys.dm_os_sys_memory is not available in SQL 2005.

pavan,

i didnt get your question, can you explain it?

Eddie,

This is total RAM available in the server , can we get how much it is currently in use and by sql server?

what is compatibility settings?.

In addition to jack's comments.

why dont you user in or bigint and you can use identity as well.

Index will have greater effect on usage of between.