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 |
|
EetieD
Starting Member
5 Posts |
 Posted - 2008-08-07 : 10:21:36
|
| I am trying to execute a SQL-file in Microsoft SQL Server 2005, in a query window.After running the sql file with 169,735 'INSERT INTO' lines, I got a message "Query completed with errors". And with no other results. When I try to see the content of the table, it is empty. This is quite frustrating, because the SQL Server does not give me the feedback I need what I am doing wrong (The script may be not 100% correct). Is there another way to run an 'Insert into SQL-script' than via the Query Window in Microsoft SQL Server? Or is there a way to see what I am doing wrong? If somebody know a suggestion, please help me. Thanks! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-07 : 10:30:39
|
Switch to the MESSAGES tab.Somewhere there among the 169,735 inserts you will have an error message.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2008-08-07 : 11:22:55
|
| and lo, the text will be red in colour.-------------Charlie |
|
|
|
|
|
|
Not enough feedback after running sql-script