ExEvents outside of enterprise really is the most flexible and powerful mechanism for auditing.

No, the security has to be done after you successfully move the database to 2012.

You need to be able to grant access to an account to the drive locations where the backup is going to go. That's why it should be a network account....

I hope the move between servers is meant to be permanent, or that you took a backup, using the BACKUP DATABASE command before you did the move, because what you...

Yikes.

OK, well, the way to solve this would be using a recursive CTE and the OVER...ORDER BY clause... but thousands? No. It basically won't work. I'm think 3-5 or even...

Is it always three values or is it any number of values?

This is not a problem I've run into, but it seems that killing the process ngen.exe has helped a number of people solve this problem.

So I assume it's keyed off the accountid, but what determines the order? if it's just ordinal, we might have a problem because you can't guarantee order without an ORDER...

I'm with John, that makes perfect sense based on the data you're showing.

Side note, get in the habit of identifying the owner of every column in your queries, not just...

I'm confused then.

As written, you can run the code you're showing, anywhere at all. It's basically hard coding values into a table variable. What does that have to do with...

By and large, if the data entry is variable in length, I use VARCHAR even though it might be more likely to fragment. That's why we do maintenance on the...

I don't see either a WHILE loop or OPENQUERY in the code.

rodjkidd (1/15/2016)

---

I'm also very glad that SQL Bits is not at the Adephi. That was an odd few days last time. A hotel that was once grand but no longer.

I...

Not if they're dbo. You can't deny much to someone at that level. Instead you'd need to grant them individually each of the dbo level permissions, but not allow them...

Ed Wagner (1/14/2016)

---

Alvin Ramard (1/14/2016)

---

SQLRNNR (1/14/2016)

---

I know a few people that are. Timing was bad for me. I am going to...