My question here, if I rebooting this machine every night, shouldn't it clear all the locks and the space locked,

This is the result I get,

sysfiles18NULL00HEAP0100

fnSecAccountActionList263671987NULL00HEAP0000

fnTableDepends279672044NULL00HEAP0000

Computers2034106287NULL00HEAP0100

result is simple and replication

sorry I should have mentioned that earlier, database is Simple

How to change the properties to 32 bit for package please

I have a package rpd.dtsx and trying to execute and get the above mentioned error

DTSEXEC

Please do not worry, thanks anyways, I did the task as below,

RESTORE DATABASE XYZ FROM DISK = 'C:\XYZ.BAK'

WITH REPLACE

GO

Can I get the syntax for that, it makes sense

Thanks Gail

Thanks a Lot for this

Thanks a Lot, I will keep this in mind,

yes it is domain A

Trust is fine, I tested that

This all problems started when I had RTM version for SQL version and upgraded to SP2,

Thanks

Resolution: I tried copying few corrupted files that did not fix the proble,,

I re-installedthe service pack 2 for SQL server 2008 R2 64 bit and then rebooted the server that...