[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | Microsoft SQL Server Support |
| Notice: | Please Registar, Note #11 |
| Moderator: | AMCUCS::BETTS |
|
| Created: | Tue Aug 23 1994 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 382 |
| Total number of notes: | 1233 |
355.0. "Strange behaviour with ISQL and -i option" by STKHLM::KNORN (I'm still here) Mon Mar 24 1997 09:21
(..is it because it's a monday ...)
If I type this command in ISQL
alter table product_offering
drop
contraint FK_PRODUCT_OFFERING_PRODUCT
go
everything works fine. BUT...
If I put the exact same command in a .SQL file and use the input file
option in ISQL (like ISQL -U me -P secret -i myfile.sql) I get the
following error:
1> 2> 3> 4> Msg 170, Level 15, State 1, Server LUCIA, Line 3
Line 3: Incorrect syntax near 'FK_PRODUCT_OFFERING_PRODUCT'.
alter table product_offering
drop
contraint FK_PRODUCT_OFFERING_PRODUCT
1>
Can anyone explain ?
Stefan
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 355.1 | | CSC32::HOEPNER | A closed mouth gathers no feet | Mon Mar 24 1997 16:01 | 8 |
|
Maybe ISQL is parsing only the first 3 characters of 'contraint'
and the command line is reading the whole thing?
Have you run SQL Trace while doing this from both the GUI and the
command line to see what is being passed?
Mary Jo
|