You can use VMs for production machines but it needs to be configured well to give good performance and it is not good for production clusters. You can use...

A domain account would allow SQL Server to connect to resources on other machines. For example it could write files to a network share or connect to SQL Server...

If you're under the support/maintenance contract you can upgrade SQL 2005 to 2008 without additional licence cost (or at least that applies to our contract)

Ramu,

Did you find the answer to this problem? We are getting similar problems with a Java app and after investigation we may increase the throughput of the network...

If you do get locked out you can change a registry setting to make it mixed mode authentication but of course you need an 'sa' type of account and password...

Ensure you have selected groups in the object types of the user search box, select the domain and just type administrators - it will change to builtin/administrators when you...

Can't offer any suggestions but

I'm using Enterprise Edition 10.0.1600.22 evaluation. I created a test table, enabled cdc and it worked. I checked the cdc.change_tables table and the has_drop_pending...

Yes this is true. A client machine connects to the principal server and the principal server returns the details of the mirrored server which I believe is then stored...

Administrative shares are the ones set up for disks and have the name of the drive letter and a $ sign. So for example c$ is an admin share...

In 2000 Log Shipping is only available in Enterprise Edition. In 2005 it is in Standard and Enterprise

You can use the RESTORE command or the SQL Server Management Studio GUI to restore a 2000 backup to 2005. Once it is restored the compatibility level will be...

We apply the service pack to upgrade our client tools to ensure we have the latest version. Some features are fixed in the newer versions and you can have...

Can you confirm whether you are using MSDE or a full version of SQL Server?

What happens when you just double-click on the setup program? It should prompt you to select the instance to upgrade. It doesn't matter where the database data files...

SELECT * FROM sys.master_files