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 |
|
debradeng
Starting Member
46 Posts |
 Posted - 2006-10-25 : 00:08:47
|
| I am trying to use SP to replace all Dynamic sql in a project,I right-click the SQL and add new query,but can't see all SP that I created last week,just a few can select,why? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-25 : 03:25:11
|
what do you mean?1. if you check enterprise manager, under stored procedures, you don't see them?2. if you check query analyzer, under stored procedures, you don't see them?3. if you run this...select name from sysobjects where type='P'order by name asc you don't see them?then you must have forgotten to save the procedures if you used enterprise manager or did not run the script in QA or just parsed it--------------------keeping it simple... |
 |
|
|
|
|
|
I can't see the created SP when adding queries,why