Hi Mike,

What are you trying to do exactly?  If you mean "can we manipulate the individual permissions listed in sp_dbfixedrolepermission output and build our own roles using those permissions as...

It sounds like maybe you should be issuing BEGIN DISTRIBUTED TRANSACTION instead of BEGIN TRANSACTION.  You may also need to set other settings for distributed transactions, including SET XACT_ABORT ON.

If...

I run a database hosting service, and we have people that use .ADP files even without db_owner permissions. 

We grant our clients the following roles:

db_ddl_admin

db_accessadmin

db_datareader

db_datawriter

db_securityadmin

To be honest, I'm simplifying a...

Remember that I am an advocate of the OBJECT_ID approach.  Did I mention that I'm an advocate of the OBJECT_ID approach?  Good.  Remember also that I agree that the LIKE...

Niall has a good point, too!  Although that solution won't print 'Already created' as was probably intended, that technique certainly results in one of two cases (a SQL Server error...

This is an interesting discussion, and (big surprise) here's my take. 

I agree that it *is* possible to use tricks with LIKE to figure this out, but they depend on...

Another way to look at this (and I apologize for the double-post) is that if you use application roles, then SQL will take care of authenticating and authorizing both the...

It may be helpful to keep clear in your thinking the difference between authentication and authorization.  Authentication is proving who you are (logging on to the SQL Server, in this...

I'd agree that there's nothing confusing about this question ... it just has to be read and interpreted carefully, and in a way that honors this particular question's context more...

My prize for 200 posts, apparently, is the honor of posting again.  That, plus the chance to get lots of question marks posted next to my name. 

If I was physically there and could poke at your server, and we had the time, and you were in the same puzzle-solving mood that I have been rightly accused...

10 15127 1 Collection <----- out of order

I assume that in this row, 10 is contracttypetext, 15127 is a.ContractTypeID, 1 is a.LOBID, and Collection is lobtext ... correct?

Chris

OK, that's what I thought.  I assume you know that stored procedures are made up of individual Transact-SQL statements.  What you are seeing is one trace record for each individual...

So you mean to say that your result set violates the ORDER BY clause in the "original" database - for one of the fields.  Hmm.  Which one?  Do you have...

I have only skimmed this topic, so forgive me everybody if I've missed an excellent point (and expecially if it was yours), but ...

What SQL Bill says will work -...