Works with SQL Server Express 2005 ?

grennis · Post by **grennis** » Thu Aug 19, 2004 8:06 pm

Anybody knows if this works with SQL Server Express 2005 (currently in Beta)?

Thanks

Post by **jclausius** » Thu Aug 19, 2004 8:11 pm

I haven't tried it out yet.

However, the Vault database scripts did not work with early betas of Yukon, so I would be surprised if they ran under SQL Server 2005 Express.

atweiker · Post by **atweiker** » Fri Oct 08, 2004 10:40 pm

I just tried installing it on my SQL 2005 Beta 2 instance and it doesn't work. It is due to one of the stored procedures that has an ambigous column reference. Starting in 2005 it's required that all columns be explicitly specified.

Example:

Code: Select all

SELECT Name, Address FROM Users

should be

Code: Select all

SELECT u.Name, u.Address FROM dbo.Users u

This is especially important when joins are involved. For clarity I didn't show an example using a join, but if you have any more questions I'd be more than happy to clarify.

Post by **jclausius** » Sat Oct 09, 2004 8:09 am

Thanks for the report.

atweiker · Post by **atweiker** » Sat Oct 09, 2004 10:49 pm

I just remembered as well that in the "Best Practicies Analyzer Tool for Microsoft SQL Server 2000 1.0" it has a feature that will check for 2005 compatability.

http://www.microsoft.com/downloads/deta ... laylang=en