Are the Databases on Default or named instanced?

Are you using Static or Dynamic IP Addresses?

That could be a problem.

If you try to connect from a client to the Server with TCP/IP enabled that should tell you something...

The Database is in use.

Did you ever do the following?

Issue the command to determine who is connected to the database.

Then you will need to Kill the connections to the Database.

Make...

Are you sure that you removed all of the SQL Server Components for the Evaluation Edition and then rebooted before installing the Express Edition?

Make sure that you have completely removed...

nice work! 🙂

Why not add a CASE Statement or some other logic to your query. Maybe I'm missing something. 🙂

I agree, the thought of performing an in place upgrade scares me.:w00t:

I believe that you want the FOR XML EXPLICIT.

Please check the following examples:

http://www.sqlservercentral.com/articles/ADO/article4/516/

http://articles.sitepoint.com/article/data-as-xml-sql-server

Please let me know how you make out.

Thanks.

What is with JOIN T2 ON 1=1?

SELECT T1.col1,T3.col3

FROM T1

JOIN T2 ON 1=1

LEFT JOIN T3 ON (T3.col1 = T2.col1 AND (T1.col1 = T3.col2 OR T3.col2 IS NULL) )

GROUP BY T1.col1,T3.col3

How are...

Don't you get a dialogue box with an error message? I find that hard to believe. Get a screen shot of the error.

Have you checked the SQL Server & Windows...

That exam does not cover an BI material as I recall.

This exam is required before you can take the MCITP Test for BI.

There is a lot more than taking the...

If I gave you the answer then I would be doing you a disservice for you will go into the interview less prepared and less knowledgeable and lack confidence on...

There are many advantages of SQL Server 2005 over SQL Server 2000:

http://itknowledgeexchange.techtarget.com/itanswers/advantages-of-sql-server-2005-over-sql-server-2000/

http://msdn.microsoft.com/en-us/library/cc966519.aspx

http://technet.microsoft.com/en-us/library/cc917715.aspx

http://www.microsoft.com/sqlserver/2005/en/us/upgrading.aspx

http://www.geekinterview.com/question_details/41410

Yes, you can upgrade directly to SQL Server 2008 & I would strongly suggest that you upgrade to SQL...

Yes, thank you. 🙂

Based on your answers to my questions I may have some additional information that will hopefully be helpful to you...