January 19, 2010 at 10:17 am
I have sql 2005 running on a server 2003 OS. How do I add Sql 2005 to the compatiblity mode? I only have sql 2000 and sql 7.0
January 19, 2010 at 12:21 pm
Please run the following and post the results
SELECT @@version
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 19, 2010 at 12:56 pm
microsoft sql server 2000 8.00.2039
January 19, 2010 at 1:05 pm
You're running SQL 2000 there, not SQL 2005.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 19, 2010 at 1:12 pm
You probably have the SQL Server 2005 client tools installed on your desktop. SSMS can work with SQL Server 2000.
January 19, 2010 at 1:19 pm
that query was within sql studio
January 19, 2010 at 1:25 pm
The query Gail had you run returns the version of SQL Server you are connected to, not the version of the client tool running the query.
January 19, 2010 at 1:28 pm
jeffmc123452003 (1/19/2010)
that query was within sql studio
Doesn't matter what you're running it in. You are connected to a SQL 2000 server, that's why the maximum compatibility you can set is 80 (SQL 2000)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply