Results 1 to 3 of 3

Thread: save execution plan

  1. #1
    Join Date
    Dec 2007
    Posts
    13

    save execution plan

    Hi,

    I am using SQL Management Studio Express Edition for MSSQL 2005. I am trying to save an execution plan. When I try to save it (by right clicking in the execution plan area), the 'Save Execution Plan As' option is grayed out.

    Is this because I am using the Express Edition? Or is there another reason. Is there another way to save the execution plan?

    Thank you

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Can you save it in file -> Save Execution Plan As? What kind of permission do you have in the db?

  3. #3
    Join Date
    Dec 2007
    Posts
    13
    it was permissions - i was logged in with Windows Authenitcation - when I changed to 'sa', i was able to save the execution plan -

    thanks for your assistance,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •