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 |
|
ywb
Yak Posting Veteran
55 Posts |
 Posted - 2006-02-09 : 19:17:43
|
| Hi,I need to export about 100 stored procedures from the SQL server in my development environment to the one in the testing environment. But it keeps giving me an ambiguous error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'disable'.Now how can I determine exactly which stored procedure is giving this error?ywb. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-09 : 19:34:32
|
| Are you getting this error in the Generate SQL Script wizard, while running the code in Query Analyzer, or somewhere else? Please explain.Tara Kizeraka tduggan |
 |
|
|
ywb
Yak Posting Veteran
55 Posts |
Posted - 2006-02-09 : 20:19:40
|
| Oh, sorry, forgot to mention that I was using Enterprise Manager's "Export Data..." function |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-10 : 13:50:02
|
| ywb, don't use Export Data wizard or DTS packages to script out objects. You can do this via the Generate SQL script wizard in Enterprise Manager. Right click, all tasks, generate SQL script. Grab the script and run it in Query Analyzer. If there are errors, you'll at least have a line number. You can also double click on the error in the results pane to jump to that line.Tara Kizeraka tduggan |
|
|
|
|
|
|
Error Export Stored Proc