is the user member of any powerful instance level security group(s) or has the account been granted things 'on any database' ?

someone must have granted 'view definition TO ...' ;

e.g. to public ( not my favorite ! )

try:

deny view definition TO [ThatSpecificUser]

IMO that must be something that comes from either:

- someone executing DDL for implementation of stuff

or

- a dynamic sql statement someone is executing.

SQLserver will not let you implement DDL...

HowardW (9/10/2014)

---

I'm assuming it's the conversion from a binary(8) to varchar that's causing the problem. If you output cast(eqs.query_hash as varchar(255) ) in the select, does it look different?

You might...

I know you the values of query_hash and query_plan_hash are different and the columns serve different purposes.

My points are:

- why is query_hash of the sqlplan not equal with the query_hash...

start reading here : Database Mirroring (SQL Server 2012)

itmanagers (8/27/2014)

---

Hi,

Hope you are doing fine.

I'm new using SQL backup jobs with multiple full, diff and log backups.

I have the following scenario

full- every day at 8:00pm

diff- every 4 hours

log- every...

Koen Verbeeck (8/4/2014)

---

ALZDBA (8/4/2014)

---

Koen Verbeeck (8/4/2014)

---

Weird issue here.

I have a rather large DWH query. For testing purposes I singled out one single ID.

But sometimes the query returned 1 row, sometimes...

Koen Verbeeck (8/4/2014)

---

Weird issue here.

I have a rather large DWH query. For testing purposes I singled out one single ID.

But sometimes the query returned 1 row, sometimes 2, while it...

vinodmmec916 (8/4/2014)

---

Hi community,

I want to know whether we can create an automated html format mail for new users and it has to be immediate as soon as a new user...

If you make that existing index the clustering index, make sure to set a suitable fill factor to avoid the need for page splits ( and the according waits /...

in our house:

- each team of "infrastructural software suite" people handles backup and recoverability conform the businesses needs and uses the appropriate scheduling system.

- SCOM monitors is all 🙂 and...

Nice article, Dwain !

:smooooth:

Thank you for the confirmation.

my bad. Sorry for that.

Executed as user: mydomain\myserviceaccount. The page (1:402), object ID 75, index ID 1, partition ID 281474981625856, allocation unit ID 281474981625856 (type In-row data) has been modified,...