Post reply

All proc not visible in SSMS 2008 project

  • February 6, 2009 at 5:02 am

    #206291

    Not able to see all the sp which are saved in VSS 6.0 from SSMS 2008 project explorer. The procedures are visible when we connect through VSS 6.0. Any idea as to why some of these procedures are not visible.

    Please assist.

  • February 6, 2009 at 6:34 am

    #939433

    Sounds like possibly a permissions issue. Are the procs created with different schema's? Do you have permissions to those schema?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 9, 2009 at 7:17 am

    #940464

    Hi,

    Thanks for reply.. However there is no issue of rights as all the schemas are same i.e. 'dbo'.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply