The use statement gets its own context in the exec() call. It doesn't change the context for the calling program. You can do what was suggested above by Jason (recommended)...

I would agree with Hugo. If the transaction is written to the log on the mirror, it is committed. If the mirror were to fail, this would be rolled forward...

No plans here. Rockies don't open until Fri and I'll be in Omaha that weekend.

Skipping this year, though I may watch some of the first game Sun night.

I've had all of those, have media, and currently have none of those drives...

I think electronic systems can add a lot, better control/monitoring, more efficiency. Better reactions in many cases than drivers themselves.

However some of the systems need manual backups. Steering can't disappear...

My Prius has a detachable key, but it's only for the door.

Also, if the battery is dead, then you can't unlock the rear hatch, which is where the battery is....

I tend to agree with your annoyances, but I do like the...

didn't quite work. The replacement doesn't respect cr/lf

Hmmm, I'll see if we can add someting that makes sense.

Please provide: 1. DDL in the form of CREATE TABLE statements to create your sample tables 2. DML in the form of INSERT INTO statements to populate the sample...

I could do the snippet piece, but asking for parameters isn't a capability I have. It's not built in and not sure we could build it.

However I could had a...

I hadn't thought about the puddle. I'd hope the keys can withstand some brief immersion. I know I've dropped the Prius keys in the snow and it hasn't been a...

If you mean with the catch all query? I think it's as Gail mentioned, you don't necessarily get a good plan and can end up scanning the table or getting...

Are you saying you want a read only and a read/write role? Separate from db_Datereader/writer?

That's easy to script.

loop through all tables in all databases, grant rights to a standard named...

Talk to recruiters. They often find things others don't.

Add this to your LinkedIn profile. Lots of companies and recruiters start here.

Do some testing/experimenting with the platform and write about it....

You are right, I did. I was thinking row and misread that. I've seen RBAC mostly as row based, not role.

In terms of roles, there isn't a script to do...