June 5, 2008 at 2:04 pm
jeffrey,.
I appreciate your response. Is there a command, however, that will give the product name? Like SQL 2000, SQL 2005, SQL 2008, etc.? I ran the command on what appears to be SQL 2000, and it comes up with 8.x.x.x as expected. But if there was some command to run through the SQL 2005 Server Management Studio, I can show, then, the direct discrepancy between the visual client tool and the underlying DB engine --- namely, that the engine is 2000 and the interface to manage the engine 2005.
June 5, 2008 at 2:45 pm
Select @@version returns the following:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Or:
Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Jeff
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply