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.
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 databases2. Move the SQL files into your C:\temp directory3. Using ISQL, connect to your database as the appropriate database user4. In the Command window type READ c:\temp\47760a.sql ;5. Then execute the SQL6. Once you are satisfied with the results replace the details in the Command window with COMMIT7. 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 |
|
|
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 authenticationisql -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 AthalyeIndia."Nothing is Impossible" |
|
|
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... |
|
|
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. :) |
|
|
|
|
|