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 |
|
vmon
Yak Posting Veteran
63 Posts |
 Posted - 2004-06-30 : 15:56:11
|
| Is there an easy way to compare the create "proc_name" with the name of a procedure in Enterprise Manager to show which procedures have names different than the create statment in the prodcedure.Thanks,vmon |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-30 : 16:19:37
|
| [thud]getting off floor to climb back on to barstool...umm...office chair[/thud]HUH?Brett8-) |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-30 : 16:27:28
|
| There are some funnies in SQL where you can create and then do a rename and the names get "confused" - but I'm not aware that SProc name is one if them.Server name ... now there's a possibility ...Dunno if that sheds any light Brett?Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-30 : 18:23:06
|
| Compare syscomments to the name stored in sysobjects. That will let you know.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-30 : 18:34:12
|
| I've seen this happen when a developer changes the sproc name in Enterprise Manager. syscomments doesn't get updated. So EM will display the new name, but when you go to script it, it has the old name. DROP and CREATE it instead!Tara |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-30 : 23:55:28
|
| Actually I've seen that before, now you mention it. I don't know how you remember all this stuff ...Kristen |
|
|
|
|
|
|
Compare proc name with create name