March 31, 2003 at 12:58 pm
What is difference between sp_server_info
and Select @@Version?
Before Installation of SQLSP3
The sp_server_info gave me this information
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
I have Win NT sp 3 on the computer but there
is old information
after it i Installed SQL SP3
And there is difference between sp_server_info and @@Version
select @@Version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
But in sp_server_info i steel get the Old Information
Why ?
April 1, 2003 at 11:01 am
Very interesting. This server (SQL Server Central) has them the same.
A few at work have different versions. Checking further.
Steve Jones
April 2, 2003 at 6:31 am
Thank you !
🙂
April 2, 2003 at 7:16 am
But in the my testServer
sp_server_info = @@Version
April 2, 2003 at 12:11 pm
I did find a couple things out. SP_SERVER_INFO reads from a sytem table. @@version reads from the file version of sqlsrv.exe. So I suspect somehow the table didn't get updated during a service pack, but not sure why.
Steve Jones
April 24, 2003 at 4:02 pm
I have 2 servers Win2000 standard edition sp3
And On the Each one Sql2000 sp3 standart edition (but with difference between @@Version and sp_server_info)
db1, db2
I added Linked server db2 to db1 and db1 to db2.
And use it for simple queries for example
Select top 1 * from db1.Dbname.dbo.table1
Select top 1 * from db2.Dbname.dbo.table2
I never had problem with this
But now statisticly each 10 query return error
OLE DB provider 'SQLOLEDB' reported an error. The provider
did not give any information about the error.
OLE DB error trace [OLE/DB
Provider 'SQLOLEDB' ::GetSchemaLock returned 0x80004005:
OLE DB provider SQLOLEDB supported the Schema Lock
interface, but returned0x80004005 for GetSchemaLock .].
OLE DB error trace [OLE/DB
Provider 'SQLOLEDB' ::CreateSession returned 0x80004005:
The provider did not give any information about the
error.].
or when i use storeproc
The operation could not be performed because the OLE DB
provider 'SQLOLEDB' was unable to begin a distributed
transaction. [SQLSTATE 42000] (Error 7391) OLE DB error
trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d01c].
[SQLSTATE 01000] (Error 7300)
What is a problem ?
pls help !
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply