Roy Ernest (8/17/2010)

Steve Jones - Editor (8/17/2010)

Roy,

I'll...

Jeff,

Keep an eye here, and the newsletter. We'll publish something when we hear.

Roy,

I'll try to do one for you...

No word yet on a place. I have used ESPN and CBS in the past. I sent an email to Dan (the OP), and no response. If I don't...

My plan was to run W2K8 and HyperV on mine (I think it goes to 12 or 16GB of RAM), but then I found that the USB in a guest...

Lian,

You'd have to provide more information about what is happening. I assume you mean query timeouts from the table(s) that the job affects? What does the job do? What are...

I like my job, and mostly because I deal with all of you on a regular basis, way more than I work with people in my company. They're fine too,...

Do you mean in those tests that you cannot log in at all, or that you are not a sysadmin?

I assume this machine is a member of the domain, correct?

Here's what I would do. I had a friend doing something similar for clients. He had one "master" database that contained common information and tables for all the clients. This...

Good luck. They were great to work with, reasonable, made changes for me, offered advice, and helped me pick a great system that works for me. I emailed a bunch,...

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.