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 |
|
sqlnovice123
Constraint Violating Yak Guru
262 Posts |
 Posted - 2010-02-23 : 14:37:36
|
| Hi,I was able to compile the stored procedure fine but I do not see the proc on the database. I compiled using ctrl + F5. I am not sure whether I loaded the proc. Any help is appreciated.Thanks |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2010-02-23 : 14:41:24
|
| Did you preface it with dbo.sprocname? If not you may have created it in your schema instead of dbo. Look for username.sprocnameMike"oh, that monkey is going to pay" |
 |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-02-23 : 14:46:57
|
| Also, if you are looking at the Object Explorer in SSMS, refresh the 'Stored Procedure' view and look again. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-24 : 10:27:41
|
| or just try the below querySELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE Routine_Name='Your procedure name'to see if its actually present------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Loading a stored procedure in sql 2005