Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Vendor requesting a script to run in ISQL?!?!?!
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jaybee from his castle
Yak Posting Veteran

64 Posts

Posted - 12/04/2006 :  06:22:21  Show Profile  Reply with Quote
Does this situation make sense to any of you? A vendor is asking me to run a search from ISQL - and bear in mind, I've never used ISQL before...

"The procedure for running the SQL is:

1. Backup your databases
2. Move the SQL files into your C:\temp directory
3. Using ISQL, connect to your database as the appropriate database user
4. In the Command window type READ c:\temp\47760a.sql ;
5. Then execute the SQL
6. Once you are satisfied with the results replace the details in the Command window with COMMIT
7. When finished close ISQL"

1) Would it make any difference by running it from QA? It's a straight select, but from QA a series of parsing errors occur;
2) How do I enter my windows login/password into ISQL?



Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 12/04/2006 :  06:24:57  Show Profile  Visit Merkin's Homepage  Reply with Quote
You can run it in QA, your vendor is just being old skool.

"A foolish consistency is the hobgoblin of little minds." - Emerson
Go to Top of Page

Flowing Fount of Yak Knowledge

5581 Posts

Posted - 12/04/2006 :  06:29:32  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
May be he prefers command-line instead of GUI:

isql -Sservername -Usql-username -Ppassword -isql-file-path

or, for Windows authentication

isql -Sservername -E -isql-file-path

from QA a series of parsing errors occur;

If you could post the script here, we can help you.

Harsh Athalye
"Nothing is Impossible"

Edited by - harsh_athalye on 12/04/2006 06:30:19
Go to Top of Page

Flowing Fount of Yak Knowledge

4110 Posts

Posted - 12/05/2006 :  00:26:31  Show Profile  Send jen a Yahoo! Message  Reply with Quote
imhe, most vendors especially system integrators request such things, i think it gives them the sense of security that they know what they're doing...

keeping it simple...
Go to Top of Page

Jaybee from his castle
Yak Posting Veteran

64 Posts

Posted - 12/05/2006 :  04:00:10  Show Profile  Reply with Quote
It's ok, the vendor is an absolute flake, I just ran the damn thing in QA and forgot about it.


Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000