I bought my last one from a place in MO. I searched around and found a place that some friend had used, and ordered one through them.

http://www.ecollegepc.com/

They worked with me...

You can use ALL, or CONTROL.

You can use this function to check permissions: http://technet.microsoft.com/en-us/library/ms176097.aspx

What application executes an application role and then needs to alter objects? I'm curious.

How are you running this from the batch file?

The -E parameter uses Windows authentication. If you run from the command line, it uses your Windows credentials. If you schedule this...

You can script it, though I'm not sure what you're trying to do here. Why "Control" permission? This is typically a higher level of permissions than most users need.

The GRANT...

Those are good books. I'd add in as well that Kevin Kline's SQL in a nutshell is a nice intro.

Glad you've moved on, and a nice editorial. I agree that these challenging jobs help you learn, but I agree with Andy. Easy to get stuck there.

I think you need...

http://www.jasonstrate.com/index.php/2010/08/sql-saturday-on-a-friday/

Jack Corbett (8/16/2010)

---

For choosing sessions, I personally think that having a selection committee nominate the top N for each category and then allowing the community to pick is a good...

First the Summit is typically around 1500 people that pay. Leave out volunteers, speakers, and that's about what the Summit is. Sometimes smaller. I suspect the Rally will be smaller,...

Home, and glad to be here.

The same article can be sent to multiple subscribers.

You set up a new subscriber, point to the existing articles. You can remove the first subscriber, or leave it there.

I'll play, and I'll toss in a prize.

Honestly, this is a place I'd use a CTE since it's cleaner, IMHO, to read. And it's becoming a bit of a convention in code.

With W (applnbr, application_count)

as

(

...

I'll see about sending an email/digest out.

This is one of those things that I'd like to push a little, experiment with, if I make it on the board. If not,...

I think the SQL Rally is designed to "try" some things out that don't happen at the Summit, and get more speakers there. Personally I'd like to have people submit...