You really need to dig through articles on the subject and then perhaps look for posts where people have had issues.

It's straightforward, but likely you also want to practice, and...

That's for an instance. It gets weird with different editions, instances, VMs, etc. And it's always changing.

Definitely call MS if you have questions.

I definitely dislike the shorthand that so many people are using, but I think it's a bit of a fact of life for newer generations.

I was slightly torqued about the...

and this is usually a client side thing to do, not a SQL calculation.

In the SQL Agent properties (not mail), do you have the same profile selected that you set up for the database server?

This is a silly question. We don't do all the research for you.

Start reading yourself and ask specific questions: http://msdn.microsoft.com/en-us/library/bb500435.aspx

Apparently the windows credentials are not getting sent through. Is this a service of some sort?

Networking, security, learn like you did SQL. Dig in, find some forums/sites/newsletters, and start learning.

Yes, you just install SQL again on the same machine. It will ask you for the instance name.

I might do it 10 times or so, just to be safe. Allow some pad in case things change.

You could probably calculate out the max in any column and use...

Not to hijack the thread onto cursors, but I use them many times for one-offs , things like Brandi that need to be done, and figuring out and testing a...

I've tried Atkins, didn't like it. Felt tired, missing some energy. Tried South Beach, with better results, but it didn't fit me.

We have done the Body For Life (http://bodyforlife.com/)diet a...

Excel doesn't really run in the same process, AFAIK. It can hang, which could hang this SPID.

It's an interesting solution, and one that might fit in certain places. Having users...

Links in the article have been corrected.

They shouldn't be allowed to run the same job at the same time. They weren't re-entrant in 2000 AFAIK. Are you sure there aren't two jobs doing the same thing?