Take a look in Activity Monitor (Mngm Studio, under Management node) to see if your db is still restoring; if not then run

RESTORE your_db WITH RECOVERY

Registry Key: HKEY_USERS\S-1-5-20\Software\Microsoft\Windows\Current Version\WinTrust\Trust Providers\Software Publishing

Value: State

Original Data: dword:00023c00

New Data: dword:00023e00

Good luck

This is a known issue. It's better to apply sp2 directly than sp1 and then find the patch that fixes the int services service. However, there is a workaround after...

The issue is I cannot see the packages by connecting above.

Do I have to define...

I connect to the server as you described,the security it's ok. It's only the packages cannot be viewed nor the folder they've been deployed to. However, they exist as selecting...

Just close the template explorer (there is an x on top right hand side) if it annoys you, don't try to remove it.

You can do flashback in Oracle, not sql.

Restore your db to a copy - make sure you don't overwrite your mdf and ldf - from a backup that has the...

This is a known issue, please read MS article here

http://support.microsoft.com/default.aspx/kb/820220

I would say to use an SMTP server along DBMail if you don't need your sql server to receive...

Firstly, you have to be patient while running anything-sql on a VM. I'm not sure why that guy said that memory cannot be added as VMs are not managing the...

This book is truly "gold". Designing the hardware/optimised database solution for a complex 24/7 high available SQL Server 2005 integrated app it's not a simple task and information on web...

I have to get used to this new website format...sorry, I do not have your message in front of my eyes right now, hope this will answer your question;

Viewing logs...

You meant moving logins probably; you would have to move logins as a separate task as they are stored into master db. please read here how to do this

http://support.microsoft.com/kb/246133/

Table partitioning is not a built-in functionality for sql 2000; however, this works good in sql 2005, but unfortunately it's not your case. You can use partitioned views when accessing...

You would have to build this directly on your db as this is depending of your records; my suggestion is to run the query in Management Studio, then Tools->Database Tuning...

http://support.microsoft.com/lifecycle/?p1=2852