Rich,

no, you don't need to reapply the service packs. Actually hardly any files will be changed and the databases aren't touched at all.

Markus

1)What are the advantages and pitfalls of using the 64-bit versions of Windows Server 2003, and SQLServer 2000?

 64-bit offers better memory managemnt especially if you...

I did the exam and passed in when it was still in beta(November 2005). I did hardly any exam specific preparation, but when again I had worked with SQL 2005...

Ray,

what exactly do you mean with öpen SQL Server"? Which tool you are using? If it's Enterprise Manger, then you can't register a 2005 instance. If your using SQLServer Management...

Jose,

while this string might work, I would never accept an application on my server which uses the sa account. You should create a SQL login on the server with the...

Sounds like the server is only accepting Windows authentification. Your using a SQL login, but the error says that it's not a trusted login, which means Windows login.

Check the server...

One more question. Why would you want to install 32-bit SQL server if you already have a 64-bit OS ? There's not price difference for the licenses and 64-bit has...

Andrew,

still not sure if i understand you correctly, but here is what I understand is possible.

You can have two Windows 2003 64-bit server nodes and cluster two SQL server 32-bit. It's...

Not sure if I understand your question correct, but if you're asking if it's possible to have 32- bit on one node and 64-bit on the other node, the answer...

Yuri,

you could use partitioning for the table and indexes and when rebuild indexes by partition if necessary. Partitons which aren't fragmented don't need to be rebuild. This should shorten the...

Hello Ed,

I don't have any "official" documents but I have some experience with running SQL 2000 and 2005 on the same cluster. We didn't have an cluster specific issues, apart...

I never did it with Oracle 10g, but with previous versions I remember we had to install the Oracle client on the SQL Server. This will add the drivers you...

I agree with Terry that standard or even workgroup edition would be sufficient in most cases. Enterpise Edition has some extra  scalability and availabilty features and also more features for data...

Depending on the type of information you want there are several ways to go. If you want a message then a certain value exceeds some value you might want to look into...

I've seen that problem when kerberos authentification could not be initialized when the server starts up. Check you're 2005 SQL log for any error during start up.

Most of the time...