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 |
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
 Posted - 2007-05-31 : 01:02:09
|
| I am creating a stored procedure isp_Backup (earlier posted by Tkizer).It gave me following warnings .------------------------------------Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master.dbo.xp_backup_database'. The stored procedure will still be created.Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master.dbo.xp_backup_database'. The stored procedure will still be created.Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master.dbo.xp_backup_log'. The stored procedure will still be created.-------------------------However i coulde not c the stored procedure in the list of stored procedure in master database . Is it created ? . If ys where can i c the same . Also i could not c the stored proceudre xp_backup_database in SPs or xSPs . |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-31 : 01:13:25
|
Are you creating SP in master database?Are you able to see SP contents on following command:sp_helptext 'isp_Backup' Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
Posted - 2007-06-01 : 00:54:44
|
| Thanks Harsh for the response .I created the same in master. At the time I created , it did not show me . But when after couple of hours when I re-opened the enterprise , it showed me . So problem solved for the moment. But any logical explanation for this . |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-01 : 01:01:50
|
| You should have refreshed the list of SPs in EM.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
Posted - 2007-06-02 : 03:41:25
|
| Refreshing is very basic to me . I must have done that. Normally posting to forum for basic questions is last resort to me . Probably something else . |
|
|
|
|
|
|
stored procedure