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

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Vendor requesting a script to run in ISQL?!?!?!

Author  Topic 

Jaybee from his castle
Yak Posting Veteran

64 Posts

Posted - 2006-12-04 : 06:22:21
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!

4970 Posts

Posted - 2006-12-04 : 06:24:57
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
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-04 : 06:29:32
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"
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-12-05 : 00:26:31
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 - 2006-12-05 : 04:00:10
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
   

- Advertisement -