Recently I had this problem when trying to connect to the SQL Server on a VPC that is running on Vista Ultimate x64. Initially the SQL Server 2005 instances on that VPC installed with required levels of Service Packs and recently installed SQL Server
Read More...
Here is another common error you will get to see with Database Maintenance plan in SQL Server 2005, though most of it has been resolved with Service Pack 2 and hotfix but still you need to take care few things. Error: Value of 'DD/MM/YYYYHH:MM:SS' is
Read More...
As you may be aware using SQL 2005 version you can set PASSWORD EXPIRY policy that can apply the same complexity and expiration policies used in Windows Server 2003 operating system to passwords used inside SQL Server. This functionality depends on the
Read More...