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 |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2003-02-10 : 15:55:37
|
| I am moving data from my database into an empty database, because I am moving across servers and am having problems with logons.The problem I am having is it fails at the end with 'invalid column name userdonation'I added this column a long time ago to my design, but its gone now. I think possibly it is erroring out because a stored proc refers to this column?? Is this possible ?? If so, how can I search through all my stored procs to find it?OR, what do you think the problem may be?Thanks alot!mike123 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-10 : 16:12:04
|
| Vyas wrote a stored procedure that you can download to search all of your database objects for a certain string:[url]http://vyaskn.tripod.com/sql_server_search_stored_procedure_code.htm[/url] |
 |
|
|
darinh
Yak Posting Veteran
58 Posts |
Posted - 2003-02-10 : 16:13:57
|
| Have a look at[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=8628[/url] |
|
|
|
|
|
|
invalid column name