Marco

Please will you post the actual row(s)?

Thanks

John

Marco

I'm getting a bit outside my area of knowledge now. What does the row in sys.database_permissions look like?

John

The error message is saying that the principal has granted or denied permissions - not that it has had permissions granted to or denied from it. If you revoke...

Did the failure occur on the same step on which you set up the retry?

John

Gail

Yes, I did consider that, but then I noted that could equally be the case if a value of 1 and value of 1,000,000 were passed in for the @top...

You could put some control flow in your procedure, so that if a value for @top is passed, it used, but if it's null, the query is executed without the...

Something like this?

SET @top = COALESCE(@top,(SELECT COUNT(1) FROM Events))

John

ccd3000 (12/18/2014)

---

Yes. As I pointed out earlier, North Korea and (most of) the rest of the world aren't bound by the law....

Gene

Please reconsider. You're unfortunate enough that your first contribution happened to be to a debate that invariably inspires passionate partisanship. In such exchanges, comments are made that can...

It should be noted that the right to be forgotten is not absolute. It only applies in cases where the information is inaccurate, irrelevant, inadequate or excessive. There's...

jlahdenpera (12/18/2014)

---

The downsides of auto increment columns are well discussed and documented.

I have tables with > 5,000,000 records with Guids as primary keys. These tables contain static data so clustered...

While the query is running, use the sys.dm_os_waiting_tasks view to determine the wait type for the query. Do that several times, just in case it's waiting on lots of...

One way (not necessarily the most efficient) is to join v back to table_name on v.letter = left(table_name.name) before you do the UNION.

John

Is the Distributed Transaction Coordinator running on both servers?

John

And it's definitely a named instance? The SQL Server Browser service only resolves ports for named instances.

John