The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. The request failed with HTTP status 404: Not Found.
Screenshot of Error in the Report Viewer This error reads: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. The...
Easy Way to Start/Stop SQL Server on a Multipurpose Machine
I have been doing a lot of development on my gaming machine and as all gamers know, you want to have as much free RAM as humanly possible while playing games. I close all open applications, but what d...
How to get Filename and File Extension from a Column with tSQL
I have written this query like 100 times, but this time I am going to document it so I don’t lose it again. This query specifically assumes that you have a single column that contains a file nam...
SQL Server: String or binary data would be truncated.
Msg 8152, Level x, State x, Line x String or binary data would be truncated. What does this mean? This is the equivalent of SQL Server telling you that you are trying to fit too much into a container ...
SQL Server: Attaching a Second Copy of a Database that Exists Already in the Same Server
This was a fun one, I couldn’t find a definitive answer on this so here is mine. Question How can I attach a database (MDF/LDF) to my server that has the exact same name as one of the ...
SQL Server 2008 R2 will not install – Unhandled Exception has occurred in your application.
Buggy Installers This is a fun installation problem it almost made me pull my hair out trying to figure it out. Concerning installations I honestly feel that there is nothing worse than an Installer N...
Straight to the Point: Query for Database and Table Sizes
I love how I have to search too much to find simple information, one liners, it is just like in College where my college course book would be about 100,000,000,000 pages long and really it says absolu...
Selecting Random Date Between a Date Range with tSQL
I had a very interesting experience recently trying to figure out how to select a random date between a date range using tSQL, it was a lot of trial and error, but ultimately this is what I came up wi...