Thanks.

Do I need to set Max memory and min memory if I enable lock pages in memory setting ???

Run instcat.sql provided by install package on 32 bit system and now cretae linked server on 64 bit to talk to 32 bit system.

The above works for sql server...

thanks

Thank you

I have rebooted sqlserver(multiple times) but still nolock.

we are just using local disks not using RAID at all.

The database is 70 GB and it suppossed to finish in an hour when there is no activity. Its really strange as I dont see any logs in sqlserver.

Thanks,

Thank you

Thank you very much

With dbo. he was able to create table with table owner as dbo.

Is there any way to make users as default table owner as dbo ,I...