how about this:

/* still using the recursive CTE */

Create table MyTable ( Id int not null, Name varchar(128) not null, IdParent int NULL );

go

Create...

I guess your interesting read would be Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets[/url] and the sequels 😉

just solving your simple example using a cte can...

please refer to http://stackoverflow.com/questions/7843733/confused-about-updlock-holdlock

apparently just being member of 'public' on a database is enough to be able to script the create database statement. :crazy:

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 /...