sql-server-2008

SQL Server 2005 and 2008 on same developer machine?

Has anyone tried installing SQL Server 2008 Developer on a machine that already has 2005 Developer installed? I am unsure if I should do this, and I need to keep 2005 on this machine for the foreseeable future in order to test our application easily. Since I sometimes need to take backup files of databases and make available for other p...

SQL Server 2008 vs 2005 Linq integration

Linq To SQL or Entity framework both integrate nicely with SQL Server 2005. The SQL Server 2008 spec sheet promises even better integration - but I can't see it. What are some examples of what you can do Linq-wise when talking to a 2008 server that you can't when talking to SQL Server 2005? ...

SQL 2008 Dialect Support for NHibernate

Is anyone working on or know if there exists a SQL 2k8 Dialect for NHibernate? ...

Can I use SQL Server Management Studio 2005 for 2008 DB?

I am looking to manage a SQL Server 2008 DB using Management Studio 2005. The reason for this is because our server is a 64-bit machine and we only have the 64-bit version of the software. Is this possible? How about managing a SQL Server 2005 DB using Management Studio 2008? ...

Best practices for DateTime serialization in .Net framework 3.5/SQL Server 2008

Some 4 years back, I followed this MSDN article for DateTime usage best practices for building a .Net client on .Net 1.1 and ASMX web services (with SQL 2000 server as the backend). I still remember the serialization issues I had with DateTime and the testing effort it took for servers in different time zones. My questions is this: Is t...

Moving SQL2005 app to SQL2008

I will be moving our production SQL2005 application to SQL2008 soon. Any things to lookout for before/after the move? Any warnings, advices? Thank you! ...

SQL Server 2008 Reporting Services Report Definition Customization Extensions

I've been looking into report definition customization extensions (RDCE) in SQL2K8 recently and I've been at a loss to find much documentation or even chatter on the internet about it. MSDN has a brief overview: http://msdn.microsoft.com/en-us/library/cc281022.aspx And the sample report from this book http://www.amazon.com/Applied-Micr...

Reverse Engineering for Database Diagramming in Visio with SQL Server 2008

I need to reverse engineer a Microsoft SQL Server 2008 in order to create a Microsoft Visio 2007 Database Model Diagram. So I choose Reverse Engineer from the Database menu to connect to the DB. I configured the Microsoft SQL Server Visio driver so that is uses SQL Server Native Client 10.0 as the ODBC driver. Afterwards I created a Use...

Upgrade MSDE to SQL Server 2008

I am trying to upgrade an named instance of MSDE to SQL Server 2008 Express. When I get to the "Select Features" page of the 2008 installer there are no instances listed. The upgrade to SQL Server 2005 Express (on the same VM image) however works fine. It seems to be a supported scenario (http://msdn.microsoft.com/en-us/library/ms1433...

How do I fix a Cross language installation problem in SQL Server 2008?

I'm trying to do a SQL Server 2008 setup and I've been given a Cross Language Installation failure. More specifically: Rule "cross language installation: failed. the Setup language is different than the language of existing SQL Server features. To continue, use SQL Server Setup installation media of the same language as the installed ...

How do I get the full name of the current user from a SQL Reporting Services 2008 report?

I know that the name of the user account can be retrieved from the built in variable User!UserID but how can I get the full user name of the user? I guess it would be possible to hook up some .NET code and do a Active Directory look up but are there any alternatives? ...

Cloud Hosting options for ASP.NET 3.5 and SQL Server 2008

I would like to get a list of good cloud hosting companies and what is offered by each. I specifically would like to focus on companies that can handle ASP.NET 3.5 and SQL Server 2008. Hopefully their are more options out there, other than Mosso. :) Edit 1 GoDaddy has a great deal, check out my post below. ...

Any reason to have SQL Server 2005 and 2008 installed on same machine?

I'm setting up a new development server and want to install the latest version of SQL Server 2008 Express. Will our existing sql2005 databases work with 2008 without modification? If so is there any reason to install both versions on the same server? ...

Can SQLExpress 2005 and 2008 be installed on same machine without issue?

I would like to install SQLExpress2005 as an instance "SQLExpress" and install SQLExpresss2008 as "SQLExpress2008" instance. Is there any problem with doing this on the same machine? ...

New Date/Time data types in SQL 2008

I am trying to use the new DATETIMEOFFSET data type in SQL 2008 but I can't figure out how to get the DATETIMEOFFSET '2008-09-27 21:28:17.2930000 -07:00' to show as '2008-09-27 14:28:17.2930000' (basically applying the offset to show the local time). Does anyone know how to do this? ...

Hooking up Reporting Services 2005SP2 to SQL Server 2008

I am trying to configure Reporting Services 2005SP2 on a machine with SQL 2008 on another hosting the ReportServer DB. When I create the ReportServerDB the DB is created as version C.0.9.45: When, afterwards, I try to initialise Reporting Services, I get an error about an incorrect version number. Reporting Services created a ReportSer...

SSAS Cube Browsing not working after SQL 2008 CTP uninstall

I've had SQL 2005 & 2008 CTP installed side-by-side with no problems. Recently uninstalled the CTP after it expired and now whenever I try to browse an analysis services cube in SSMS 2005 or VS 2005, I get the follwoing error: Retrieving the COM class factory for component with CLSID {C4F9B80B-89F7-4800-9C26-504D6E692B2C} failed due to...

How to use DataMining feature of SQL Server 2008 with ASP.Net

How to use DataMining feature of SQL Server 2008 with ASP.Net ...

How do I register a Web Reference for a SQL Server 2008 Reporting Service Report?

I'm trying to access the Reporting Services via Web Services in my Visual Studio 2008 Application. How/where can I find my WSDL? ...

Installation problem sql server 2008

I should probably take this for a forum but figured someone here might know the answer. I'm trying to install sql server 2008 on a home vista machine but it keeps telling 'Restart computer failed' everytime it does a check to make sure pre-reqs are met. I've restarted my computer and even uinstalled/installed .net 3.5 sp1. only thread ...