Depending on your situation, you may want to consider COALESCE as an alternative.

NP - full backups of all the system, user databases. Uninstall the rollup via Add/Remove programs under the Microsoft SQL Server 2005 installation, select the Show Updates check box.

Recentley installed cumulative update 5 (build 3215) from 4 (build 3200). I haven't experienced any problems w/ SSAS on either build (x86). In fact most of the updates introduced into...

Likely - this is VSS. I would disable VSS if you aren't using it. At a minimum ensure that your SQL directories are excluded.

Just go to start -> run -> services.msc and look at the SQL Server service, SQL Server Agent service, etc. You could also view this on the properties page for...

What account are the SQL service(s) running under?

Disable VSS (Volume Shadow Copy Service). More information on VSS -

http://www.windowsnetworking.com/articles_tutorials/Windows-Server-2003-Volume-Shadow-Copy-Service.html

Yes, and vies versa.

Correct - there are x86, x64, and IA64 versions of SQL Server 2005. Sounds like you have the wrong one 😉

Thanks Dave 🙂

🙂 Thanks, that's a good point, one would assume that the execution plan (view vs. named query) would differ quite a bit.

I would monitor the SQL Server performance counter, batch requests per second on your current CF/SQL server during your peak production load to first determine wether a CPU bottleneck currently...

Refer to the following post on MSDN:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1890772&SiteID=1

Use the query in the post to list the objects in TempDB, this will help you troubleshoot the issue. TempDB is volatile, worst case...

Thanks Michael 🙂

It could be related to a number of different issues. I would suggest to first see if the server is listening for incoming TCP connections on 1433. Open a command...