SQL Server Directory - YOUR Microsoft SQL Server directory for Microsoft SQL Server 6.5, 7.0, 2000 and 2005 (Yukon).
SQL Server Directory - YOUR Microsoft SQL Server directory for Microsoft SQL Server 6.5, 7.0, 2000 and 2005 (Yukon).
 
Home ] Up ] FAQ ] Links ] Privacy ] Search ]
SQL Server Directory - YOUR Microsoft SQL Server directory for Microsoft SQL Server 6.5, 7.0, 2000 and 2005 (Yukon).
Categories
SQL Books
Consultants
SQL Certification
SQL Downloads
SQL Education
SQL Jobs
Data Mining
Magazines
Product Reviews
Products
Reporting Services
SQL Server 2005
SQL Server 64 bit
SQL Server Katmai
Web Resources
Wise Scripts


Top MS SQL Ads
Transcender
MCDBA Directory
SQL Server Dir.
Transact SQL Dir.

Top JOB Ads
CareerBuilder
Monster
Chicago Jobs
Senior Jobs
Microsoft SQL Server 2000 Developer Edition - LESS than $50!
MSSQL 2000 less $50

WISE SCRIPTS - SQL VERSION

Find out what SQL version your server is running.
Rem ***** Start - SQL Server version
Rem ***** http://www.mcdbadirectory.com - by mark wehmhoefer 10/26/2000
Rem ***** WISE script for finding the SQL Server version
Rem ***** Build the commands to get the SQL version
Delete File(s) %TEMPINFILE%
Insert Line "set nocount on" into Text File %TEMPINFILE%
Insert Line "select @@version" into Text File %TEMPINFILE%
Insert Line "go" into Text File %TEMPINFILE%
Insert Line "set nocount on" into Text File %TEMPINFILE%
Rem *****Use ISQL with the above tempinfile commands and output to
tempoutfile
Rem ***** %ISQLSWITCHES could be thee values:
Rem ***** trusted connection = -Syourserver -n -w300 -E
Rem ***** sql login connection = -Syourserver -n -w300 -E -Usa -Pyourpsw
Execute isql %ISQLSWITCHES% -h-1 -i%TEMPINFILE% -o%TEMPOUTFILE%
Rem *****Loop through the ISQL output text file tempoutfile for the version
string
Set Variable SQLVERSION to
Read Lines of File %TEMPOUTFILE% into variable SQLIN start block
If SQLIN contains "SQL Server" then
If SQLIN contains "6.50" then
Set Variable SQLVERSION to 6.50
elseif SQLIN contains "2000" then
Set Variable SQLVERSION to 2000.00
Elseif SQLIN contains "7.00" then
Set Variable SQLVERSION to 7.00
elseif SQLIN contains "6.00" then
Set Variable SQLVERSION to 6.0
elseif SQLIN contains "4.20" then
Set Variable SQLVERSION to 4.2
else
display message "SQL Server Version Unknown"
exit installation
End Block
End Block
End Block
Rem *****End - SQL Server version

 


Home ] Up ] FAQ ] Links ] Privacy ] Search ]

Born: 10/20/02         Aged: 11/25/06

Business: B2B Referral, Industrial Supply Deals, Office Supply Deals

Career: Back To School Mall, Chicago Job Resource, Chicago Job Talk, Diversity Job Resource,
Executive Job Resource, First Job Resource, Freelance Job Resource, Seasonal Job Resource, Senior Job Resource

Hobby: Tradin Stuff, Wild Birding

Shopping: Health Care and Fitness, Just Best Gifts, Just Clearance Sales
Just Comparison Shopping, Just Outlets, Luxury Matters, Value Buyers

Technology: FrontPage Help, MCDBA Directory, SQL Server Directory
Transact SQL Directory, WinFS Directory