Re: Issue in SQL version
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 28 Jan 2009 15:31:59 -0800
SID (SID@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
When i am executing the select @@version query in my sql server management
studio 2005 i am geting server version as 2000.
Apparently then, you are connecting to your SQL 2000 instance. Notice
that it does not matter whether you connect QA or SSMS, they both think
that (local) means your default instance.
You said you had SQL 2005 Express Edition try connecting to
(local)\SQLEXPRESS.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Issue in SQL version
- From: SID
- Re: Issue in SQL version
- From: Uri Dimant
- Re: Issue in SQL version
- From: SID
- Re: Issue in SQL version
- From: Uri Dimant
- Re: Issue in SQL version
- From: SID
- Re: Issue in SQL version
- From: SID
- Re: Issue in SQL version
- From: Uri Dimant
- Re: Issue in SQL version
- From: SID
- Issue in SQL version
- Prev by Date: Re: Problem with bulk load security.
- Next by Date: Re: Service Account Rights (Detailed) 2000/2005/2008
- Previous by thread: Re: Issue in SQL version
- Next by thread: different Sql state value for SQL server version
- Index(es):
Relevant Pages
|
