Anonymous

My feedback

  1. 4,186 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    88 comments  ·  Azure Cosmos DB » SQL API  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  2. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous shared this idea  · 
  3. 27 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous commented  · 

    Any thoughts please?

    Anonymous commented  · 

    Hello,

    Thank you for your help,I appreciate it.I tried creating this stored proc in master database logging in with SA credentials but it failed with error "Msg 262, Level 14, State 18, Procedure sp_MSforeachdb, Line 7 [Batch Start Line 4]
    CREATE PROCEDURE permission denied in database 'master'" and when i try to run on a random non-system Azure database in the same logical server i do get the following error "The module 'sp_MSforeachdb' depends on the missing object 'sys.sp_MSforeach_worker'. The module will still be created; however, it cannot run successfully until the object exists"

    Am i missing something? Could you please let me know your thoughts?

    Thanks in advance,
    Babji

    Anonymous commented  · 

    Hello,

    Thank you for your help,I appreciate it.I tried creating this stored proc in master database logging in with SA credentials but it failed with error "Msg 262, Level 14, State 18, Procedure sp_MSforeachdb, Line 7 [Batch Start Line 4]
    CREATE PROCEDURE permission denied in database 'master'" and when i try to run on a random non-system Azure database in the same logical server i do get the following error "The module 'sp_MSforeachdb' depends on the missing object 'sys.sp_MSforeach_worker'. The module will still be created; however, it cannot run successfully until the object exists"

    Am i missing something? Could you please let me know your thoughts?

    Thanks in advance,
    Babji

Feedback and Knowledge Base