Do you have any control over the structure of the database? If you do, I would strongly recommend changing your table so it looks something like this:

001 a

001 b

001...

chadlau11 (1/4/2015)

---

John Mitchell-245523 (1/2/2015)

---

There are probably newer-fangled ways to do this, but I would stick to what I know, and import the list of files into a staging table so...

There are probably newer-fangled ways to do this, but I would stick to what I know, and import the list of files into a staging table so that you can...

What results do you get from the following queries? Remember to run them in the same database as you got the sys.database_principals results from.

SELECT name FROM sys.objects WHERE object_id...

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