Hi, Recently intellisense in the SQL Server management Studio stopped working. It appears that it was caused by the installation of Visual Studio 2010 SP1. […]
Reconnect all SQL logins after DB restore
Hi, Below is a script that I use to reconnect sql logins after a database restore. It reconnects all users to all databases. Cheers
Restore SQL Server Database – disconnect all users
Hi, Often when you try to restore a database there will be connections to the DB, which will stop the restore from succeeding. What I […]
SQL Server SHRINKFILE not working
As microsoft put in in SQL Server Books online, “A shrink operation is most effective after an operation that creates lots of unused space, such […]
SSIS Date conversion error going from Oracle to SQL Server
Hi, The other day I had the task to move a large amount of data from Oracle to SQL Server. I had chosen to import […]
SQL Server Excel and Soft Returns
Many moons before reporting services existed, I was involved in writing a report architecture which was based upon SQL server and MS Excel. In short […]
SQL Server 2008 R2 Nov CTP – Uninstall issues
I was attempting to uninstall the SQL Server 2008 R2 Nov CTP and I found the SQL server 2008 R2 (x64 in my case) uninstaller […]
SQL Server 2008 Uninstall – Restart Computer Failure
Sometimes when attempting to uninstall SQL Server, “Setup Support Rules” performs a check and fails on “Restart Computer” with the following error; “A computer restart […]
SQL Server Date Format – Convert to varchar
Below is a nice little script to output the various formats displayed by sql server when using convert(varchar, getdate(), n). It just outputs the current […]
SQL Server Reporting Services (SSRS) – IIF statement divide by zero error
If you use the IIF statement to solve your divide by zero errors, you will most likely find that you still get divide by zero […]