SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Vendor requesting a script to run in ISQL?!?!?!
 New Topic  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?

Thanks,

JB

Merkin
Funky Drop Bear Fearing SQL Dude!

Australia
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.



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

harsh_athalye
Flowing Fount of Yak Knowledge

India
5514 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


quote:
from QA a series of parsing errors occur;

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


Harsh Athalye
India.
"Nothing is Impossible"

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

jen
Flowing Fount of Yak Knowledge

Sweden
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  
 New 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.06 seconds. Powered By: Snitz Forums 2000