Alex: Unfortunately I'm not sure what you are asking for? The only main difference between using OUTPUT with a MERGE is that there is a $action value that you...

Curtis: The INTO part of the OUTPUT clause has a field list. If you include the field list the insert into a table with an identity column will work....

I did a blog post a few years back on using OUTPUT to backup table changes. I could do an updated version?

Kenneth Fisher

Sean Lange (8/9/2016)

---

No discussion about nested transactions would be complete without a reminder that they are really a myth and do not do what it seems like a real nested...

tom.w.brannon (7/27/2016)

---

I expected the answer to be that there was an error because tbl did not exist. Since that wasn't an option, I did some experimenting around the open...

-- Variations on the following frequently including sys.dm_exec_sql_text and sys.dm_exec_query_plan

SELECT blocking_session_id,* FROM sys.dm_exec_requests WHERE session_id > 50

EXECUTE AS LOGIN = 'AD Login'

EXEC sp_helpindex [tablename]

On the theory a late answer is better than no answer (and since I found this one in my search of the exact same question).

Here are two links with possible...

Thanks!

Oddly that helps quite a bit, even though I'm more having a problem with apathy than a to long to do list.

Robert is right (of course) your permissions are a combination of all permissions combined. Of course this includes any DENYs you have in either set. If for example...

Really the DAC doesn't really add any security implications. Only sysadmins can connect and if you are a sysadmin you have complete control of the instance anyway. The...

Let's not forget that this is also about the ability to read dynamic SQL. And it doesn't matter if you like or dislike dynamic SQL at some point you...

jshahan (7/14/2014)

---

1. The outside 2 single quotes delimit the string.

2. On the inside of the string you must have 2 single quotes for each single quote you are...

Well it was extensively to...

It's 2014 and 2005 is 5 versions ago. I think it's fair to put syntax that doesn't work in 2005...

Phil Parkin (7/11/2014)

---

Apologies - I have not read all of the thread, so this may already have been covered.

It may be of interest to note that, although they are often...