Tag | SQL Server 2005 Posts

Today I ran into this problem when setting up the SQL Server Management Tools for SQL Server 2005. Like any good little code slinger, I googled (if you are particular to Microsoft, you can read that as “binged”) to see who’s had the problem, because it’s no news that when you aren’t on the crest of the tech wave that someone else has had the same issue. In particular, MSXML 6 would fail and the log would have a message similar to: MSI (s) (40:58) [22:16:00:859]: MainEngineThread is returning 1605 ...
While http://en.wikipedia.org/wik... outlines some limitations of SQL Server Express, there are some specifics that are missing for Reporting Services. One such example is what I discovered today while at a client that uses DB2 for its RDBMS. SSRS that comes with the Express Edition only supports creating reports against the local SQL Server data source. Be aware of this when considering SQL Server Express in your system design. http://www.microsoft.com/te... ...
Here we are at the second week's task for the Manhattan Project: switching the user's database to MSSQL instead of SQLite. I'll be honest, there weren't any valuable resources I found for assistance in the creation of this tutorial. Mostly it was a combination of Try / Fail and guessing based on what I saw in the code for the MSSQL dll in the project. I might say that there weren't resources, but what I mostly mean is no tutorial. There are some .sql files to help get the database started, but that's ...
I am pleased to announce that the BIDS Helper team have just released v1.3 which is our first release with support for SQL Server 2008. With these release we have also improved our international support. All of the features in BIDS Helper still only display in English in their user interfaces. But in previous versions, some of the features of would not work at all in non-English versions of BIDS because of the way we were integrating into BIDS. This has now been fixed and all of the features of BIDS ...