Re: Issue in SQL version

Uri
When i am executing the select @@version query in my sql server management
studio 2005 i am geting server version as 2000.


"Uri Dimant" wrote:

SID
So you are saying that when you launch SSMS to connected to the instance of
SQL Server (in your case it is an named instance) you get the version of SQL
Server 2000?


"SID" <SID@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FE9BD332-B776-4D17-9050-D4DF4B3A2B30@xxxxxxxxxxxxxxxx
Editing last Post.
Sql Server managment studio 2005:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
Windows
NT 5.1 (Build 2600: Service Pack 2)


"SID" wrote:

I have two different intances of SQL 2000 and 2005.
On Firing "SELECT @@version" in sql query analyser in 2000 :
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
Windows
NT 5.1 (Build 2600: Service Pack 2)

And what i got running same in Sql Server managment studio 2000:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
Windows
NT 5.1 (Build 2600: Service Pack 2)

Both are same.

"Uri Dimant" wrote:

Is it possible that you connected to the 'old' instance (SQL 2000)?


"SID" <SID@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:07D36AD2-F61F-48D9-9FA7-66B57C8D5346@xxxxxxxxxxxxxxxx
I ran it in Query analyser.

"Uri Dimant" wrote:

SID
Where do you run this command? In SSMS? I suspect you do not have
SSMS
installed on the computer for SQL Server Express Edition.



"SID" <SID@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4CB0F56A-C9BD-47B3-BA02-18D13309EF4B@xxxxxxxxxxxxxxxx
I am newbie and for getting version of server, fired SELECT
@@version in
my
Sql 2005 express but i am getting Server-2000 and i expected it as
2005.
Please clarify.









.

Relevant Pages

  • Re: Fresh installation and no access
    ... "Uri Dimant" wrote in message ... did you set up SQL Server to Windows only or Mixed Authentication? ... loggin in with my user accountI have no permission at all. ... Then I got this error message: ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2008 failover cluster and DTS
    ... "Uri Dimant" wrote: ... I should have mentioned that you need to install DTS 2005 Designers ... I have new SQL Server 2008 fail over cluster and need to migrate system ...
    (microsoft.public.sqlserver.clustering)
  • Re: Covert Column data to a row
    ... Uri Dimant wrote: ... What is the version of SQL Server are you using? ... CREATE TABLE #mable(AUserID INT, varchar(16)) ... FOR XML PATH) AS ...
    (microsoft.public.sqlserver.programming)
  • Re: Roles and permission mapping table
    ... But can i get a query/script for getting this data. ... "Uri Dimant" wrote: ... In SQL Server 2005, you can use the Has_Perms_By_Namefunction ... execute permission for. ...
    (microsoft.public.sqlserver.security)
  • Re: DTS Run - spaces in dts names
    ... "Uri Dimant" wrote ... ... Ie, no quotes at all? ... Is there some setting in SQL Server then that would explain this mystery? ...
    (microsoft.public.sqlserver.programming)