June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database

January 5, 2010
Pinal Dave
SQL Server
Execution Plan, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

During one of my recent training class when I asked students to check the execution plan using (can be enabled using CTRL+M), they received error as following.

Msg 262, Level 14, State 4, Line 1
SHOWPLAN permission denied in database ‘AdventureWorks’.

Read More

SQL SERVER – Actual Execution Plan vs. Estimated Execution Plan

August 28, 2007
Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
DBA, Execution Plan, SQL Scripts
I was recently invited to participate in big discussion on one of the online forum, the topic was Actual Execution Plan vs. Estimated Execution Plan. I refused to participate in that particular discussion as I have very simple but strong opinion about this topic. I always use Actual Execution Plan…
Read More
Previous 1 … 15 16 17 18
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version