Have you runa a DBCC CHECKDB against the database as it suggests?

Other than that, I'd want to see the code to try to figure out where the error lies.

You might...

Not at all. If I thought I had something really cool & wonderful I'd be crushed. Instead, what I've got is a bit of a hack based on other people's...

It's not a terribly well written script. We had a specific need and wrote it to meet that need and then stopped. We're extremely dilligent about keeping reserved words &...

I'm fairly certain you can only get the columns available from the inserted table within a trigger and not any parameters within a stored procedure. You either have to simply...

This should do it:

SELECT

p.name,m.name

FROM

sys.server_principals p

JOIN

Oops. Misunderstood. Sorry.

What about referencing the CTE within a second subselect & get the count that way?

Psuedo-code:

<paging logic>

JOIN (SELECT COUNT(*) FROM cteTable) AS t2

That way, it's all part of the...

It wasn't in the Audit event, no. But it was in the TSQL batch that immediately followed it.

Well, the short answer is, it depends. What, you expected yes or no?

Seriously though, I think it'll be OK, but I'd keep a close eye on it. As long as you're...

As long as you're only actually locking a row, for updates, it should actually perform faster. If you're updating multiple rows, you'll either get an outrageous number of row locks...

I'm not sure. Do you have any filters in place that might prevent the event from being captured?

I've never tried this before, but I just set "Audit Add Login to...

You can only use the CTE in the statement subsequent to it's definition. You can use it more than once within that statement but you can't use it in two...

We definately give the developers a copy of SSMS. In fact, they've got a Development server on their machines. They can't build structures into the dev servers, but we encourage...

That is an odd one. I use "run as" almost daily and haven't run into an issue. I don't have encrypted data. Maybe that's the difference.

Does it pull them all over when you expand the file list? I definately see a slow down when I open the error logs themselves, but I've not run into...

I've never heard of this one. Go to connect.microsoft.com. You can search for the bug there to see if anyone else has hit it. If not, you can report it.

I...