January 2008 - Posts

• How to backup and truncate all log files in a database

  Some things to consider ... Make sure you can recover your server and database prior to issuing these commands. Since I am generically calling a rountine you will receive errors on the system databases. Your database and log files must follow the convention Read More... Posted Saturday, January 26, 2008 10:41 AM by mab | 4 Comments Filed under: SQL Server

• Unable to delete or disable SQL Server job due to error regarding MSX server

  Have you ever run across this error before when trying to delete or disable a SQL server job (or edit one): Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server . This sometimes can happen if you rename a Read More... Posted Saturday, January 26, 2008 9:54 AM by mab | 2 Comments Filed under: SQL Server

• SOAP Toolkit + Vista + Excel 2007 + Call Web Services = Impossible

  Well I wouldn't say impossible ... just not supported. I had a conversation with a client that asked "Where do I get the latest SOAP toolkit for Vista?". I had to politely say "We don't support the SOAP Toolkit anymore." Which was followed by "Well how Read More... Posted Wednesday, January 02, 2008 2:13 PM by mab | 3 Comments Filed under: Visual Studio, Excel