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 |
|
vladimir_sim
Starting Member
2 Posts |
 Posted - 2007-03-05 : 12:10:51
|
| Hi,Recently, we are modifying some table structure in my Sql2K database. Hence, some columns are dropped or renamed. However, when we use Query Analzyer to modify or update some related stored procedure, it does not flag those missing columns as error in it.What is wrong, any fixes for this issue.Thank you |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-03-05 : 12:17:55
|
| because it only creates or alters the sproc it doesn't check if it's correct.you have to run the sproc to see if it executes ok.this isn't like assembly compilation in .net or similar.Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
vladimir_sim
Starting Member
2 Posts |
Posted - 2007-03-05 : 12:32:26
|
| Hi,1. Maybe I didn't explain myself clearly. I apologize for it.2. Whenever we open any SP in QA, after any modification to the script, pressing F5, any errorwill be flagged out including missing columns and other.However, in this case, my QA does not reported this errors like it did before. |
|
|
|
|
|
|
Sql2k QA not reporting missing columns