Post image

Time to upgrade your SQL Server 2005 instance

Last edited on 17 November 2016. As you know, SQL Server 2005 is now over ten years old. Microsoft has helpfully provided a list of ten reasons why you should be upgrading from SQL Server 2005. The question is not whether you should be upgrading it (you should, by the way), but to which version? Microsoft even[…]

Post image

Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000

(Originally posted on my personal blog.) For those of you battling with a 64-bit SQL 2005 Server linking to 32-bit SQL 2000 Servers, here’s a handy solution. This problem has been plaguing us for a while now, and today I made it work, thanks entirely to uber1024. Add this to your SQL Server 2000 instance:[…]