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 - ISQL.EXE

Check if sign-on has sa privilege to run ISQL commands.
Rem ***** Start - SQL Server check user has sa privileges
Rem ***** http://www.mcdbadirectory.com - by mark wehmhoefer 10/26/2000
Rem ***** WISE script for finding if user has sa privileges
Rem Build the commands to get the SQL version
Delete File(s) %TEMPINFILE%
Insert Line "set nocount on" into Text File %TEMPINFILE%
Insert Line "if (select suser_name()) <> 'sa'" into Text File %TEMPINFILE%
Insert Line "raiserror ('Login doesn''t have sa privileges',18,1)" into Text
File %TEMPINFILE%
Insert Line "go" 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 any Msg
(error occurred)
Set Variable SRCHSTR to Msg
Read Lines of File %TEMPOUTFILE% into variable LINEIN start block
If expression true Left$(LINEIN,4)=SRCHSTR then
display message "SQL Server Login doesn''t have sa privileges"
exit installation
End
End
Rem ***** End - SQL Server check user has sa privileges

 


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