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 |
|
bpsintl
Posting Yak Master
132 Posts |
 Posted - 2008-12-18 : 05:42:00
|
| I'm running an sql statement to create tables and import data from another db. The statements run fine but I get a "Ran but with errors" message.The message says it's something to do with a date field but diesn't give me any indication what line or section these errors are on.Hoe can I run the statement but find out exactly where the errors are occurring? |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-18 : 05:56:26
|
| You may see more details by expanding error (click + ) - or look at lower line. Or else place some print statements and test SQL in SSMS.You can incorporate create table and import data using:SELECT columnNames INTO newTable FROM oldTable where .......- this way removes some chances for error - eg datatypes, column size etc. |
 |
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2008-12-18 : 06:15:19
|
| Its ok, I didn't realise if you double click the error message, it highlights the statement that fails!!Thanks anyway |
|
|
|
|
|
|
sql import