Are there any additional errors in your sqlsp.log ? This should be in the %SYSTEMROOT% directory on the server. This might give a clue as to if there is another...

If the MSDE is installed on the same server as the application, you can remove all the network libraries (which I believe is not the default with SP3/SP4). In that...

SQL Server 2000 and below has no built-in integration with Visual SourceSafe. However, there are numerous 3rd party tools which do this. Take a look at the review on DBGhost,...

No. Lessons 3-8 should have knowledge you can apply directly to SQL Server 2005. Lessons 10-11 as well. This is based on the description you posted. I'm not an MCT,...

Not necessarily... for instance, perhaps one or two of the columns are better off as text or ntext columns. Hence the reason to ask about the design.

Does the named instances differ from the default instance in any way? Collation, Language settings, etc.?

Yes. If you don't have a proxy account setup, your users won't be able to run xp_cmdshell, even if you've granted access to it, unless they are sysadmins. Therefore, scheduling...

Good point, I did. The snippets can come in very handy, I just haven't retrained my self to use them. By the time I think "SELECT * FROM" I have...

For the most part, then, SQL Server support on a cluster isn't very different than on a stand-alone server. When you get to applying service packs and hotfixes you'll need...

Well, in SQL Server 2000 if you have access to the database, you have access to the INFORMATION_SCHEMA views. And they'll review all information to anyone... this gets fixed in...

Yes. Views are reported as well by INFORMATION_SCHEMA.TABLES. To ensure you only get tables, you must use Table_Type = 'BASE TABLE' or you'll get views, too.

Agreed. This error is definitely a SQL syntax error. Your network configuration is not an issue here at all.

To piggy-back on happycat59, here is a Microsoft KB article that talks about how to move the files. I include it because it references the system databases and you have...

SQL Server does not store the IP address information nor does it log it through a tool like Profiler.

If you didn't have Profiler or traces running at the time,...

Are you just having to support the SQL Server or the SQL Server + OS w/ Cluster?