Welcome to AspAdvice Sign in | Join | Help

Browse by Tags

All Tags » sql2005   (RSS)
Friday, March 21, 2008 4:14 PM

SQL 2005 Tools Install Experience is the suck

Just finished building a couple of ultimate developer rig machines for the office for Brendan and me, and was adding software today. So I installed Office, Visual Studio 2008, and then SQL Server 2005. I'd forgotten that installing SQL 2005 client
Posted by ssmith | 12 Comments
Filed under: ,
Saturday, December 01, 2007 7:17 PM

Save SQL Query Results With Column Names

A minor frustration I've had with SQL Server for years is that when copying the results to Excel, the column names are not included. Well, Brendan blogged about this yesterday , and in a great demonstration of the value of blogging, he received a
Posted by ssmith | 4 Comments
Filed under:
Monday, September 24, 2007 3:48 PM

Installing SQL 2005 Management Studio

I've installed SQL Server on a few dev boxes in my time, and one thing I've noted on several occasion is that even if you check the box during the install to say you want to install all of the client tools, usually they don't install. You think they installed,
Posted by ssmith | 3 Comments
Filed under: ,
Thursday, March 22, 2007 3:28 PM

VS2005 Data Pro Dies on Compile Fix

I had an issue with VS2005 For DB Pros (the Data Dude SKU) where every time I would build my solution (or that project), VS2005 would simply die. This was on Vista. After looking for the answer, I contacted Gert Drapers who informed me of the fix —
Posted by ssmith | 0 Comments
Filed under: , ,
Friday, February 09, 2007 1:40 AM

SQL Reporting Services 401 Error

If you just installed SQL Server Reporting Services and you are getting a 401.1 Unauthorized error when you try to go to the http://localhost/reports this post may help. I ran into this and was having a heck of a time figuring it out, since I assumed
Posted by ssmith | 2 Comments
Monday, February 05, 2007 3:30 PM

Reporting Services Plus Vista Equals Pain

I spent quite a few hours yesterday trying to get Reporting Services to work on my Vista laptop. It didn’t end up working. For quite a long time I got a login prompt when trying to go to localhost/reports, which would bomb after 3 tries and had
Posted by ssmith | 6 Comments
Monday, November 06, 2006 2:56 AM

SqlDependency Issue Resolved

I’m doublechecking my demos for my sessions at DevConnections this week and I think I finally fixed an issue that has plagued me off and on for the last year or more when I’ve been demonstrating the new SQL 2005 SqlDependency features. It
Posted by ssmith | 7 Comments
Filed under: ,