So these are really quick snippets. I hit an error where my Gateway monitoring software could not connect to the database. All the errors were along the lines of “Provider cannot be found” and when I looked in the Connection String it stated “Provider=SQLNCLI” which is the SQL Native Client...
I’ve recently moved the database behind DavidOverton.com (also uksbsguy.com) from a Windows Server 2003 system with SQL 2005 to Windows Server 2008 with SQL 2008. This would be the same process if you were potentially performing a migration from SBS 2003 with SQL 2005 to SBS 2008 Premium with SQL...
I’ve found myself moving datafiles around or backing up to new locations before enough that I need to change SQL to point to the new locations before it will start for me to do further work. The process to get it up and running is to find the SQL instance in the registry and change 3 values. The...
Hi, I know I’ve been away a lot recently (closing the year end and then doing some travelling for work), but while cleaning my inbox (ohh, 2500 mails processed, replied too, filed and actioned – yee har!) I came across this and it is bang up to date. SQL 2008 is going to be the hot, hot, hot product...