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 |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2010-03-30 : 04:26:51
|
| I've discovered this morning that I can't use execution plans for my queries against a datawarehouse. This was my way to optimise my slow queries. Is it because it's a datawarehouse, and we can't make changes (no intent) or that would slow down the poor server to describe my queries and see how to make improvements?Msg 262, Level 14, State 4, Line 4SHOWPLAN permission denied in database 'billing_data_warehouse'. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-30 : 10:43:12
|
| you just don't have permission to see them. ask you administrator to grant showplan permission to you |
 |
|
|
|
|
|
Why disable Execution Plans?