Have you tried explicitly granting backup admin to the login being used? I'm guessing now, but might be worth a shot.

I'll try playing around with the issue a bit,...

Actually, in most cases, I'm a believer in "find something you can build that will help the end user and build that, then evolve it into something better step by...

Yes, that's a more elegant solution. I didn't bother with the variable assignment and all that, was just trying to show the basic structure of the query.

I voted for both.

Have to say that they strike me as "nice to have", not as crucial. I'd rate the first one as "nicer to have" than the second...

Execute As is expecting a user, not a permission name. Create an account that has dbCreator permissions and try executing as that user.

Architecture is a pretty broad subject. What kind of articles are you asking about?

Something about logical design? Physical design? Normal forms? Gathering business requirements? Something...

That makes it a permissions issue, almost certainly.

Have them run it under elevated permissions, see what that does. (Take a look at Execute As in Books Online if you...

GilaMonster (7/7/2009)

---

Exclusive table locks.

Sequence table has much the same problems as the MAX(ID)+1 solution. Either you...

Anyone with any thoughts on this one: http://www.sqlservercentral.com/Forums/Topic748034-148-1.aspx?

I haven't done it in years, but I know that VBA and VBS have a FileSystemObject that allows you to read lines from the file into memory. Works for...

Yes, I've heard of Albania. I have no idea what your legal requirements are going to be, but that will be the first thing you need to nail down...

Ian Scarlett (7/7/2009)

---

Rather than add a SortOrder column to the table, just include one in your query e.g.

select id, forename, case when forename = 'Kim' then 1 else 2 end...

Profiler creates a lot more overhead than a server-side trace that dumps to text files. That creates very, very little processing overhead. Might matter if you're looking at...

Actually, for what you're doing, you...

Yep. That's always been the biggest weakness of online data. You can't find it if you can't think of the exact words to look for. That's the...