Since you are getting started, in addition to some reading, here are some videos: http://www.sqlshare.com/channel.aspx?cat=4a00c49a-6207-4ba8-952c-807481629761

A deadlock needs two sessions, and it needs multiple objects being accessed. AFAIK, if each person ran a single query you could not have a deadlock. It requires each person...

Deadlocks don't occur within a query, they are within a transaction when you are updating two objects.

I agree with Barry that you haven't really presented your thoughts in an organized manner and it's hard to follow.

My guess is that you would have an DrugOperations table that...

If this is homework/exam/interview question, it's not our intent to do the work for you. As mentioned by Jeff, you should try it. If you can't try it, then perhaps...

thanks, the servers have been acting up a little under load. We have emails sent from another server that connects to the database to send, but if that sender gets...

I'd agree with George that sp_help_revlogin is a better choice.

Is it through an http transfer or something other protocol?

And here I think Barry would like this car

It's Saturday, c'mon kids, go outside and play.

Here's what I'd do.

Write a query for everything but 0, so

select name, score, 'A' as 'OrderingField'

from Table

where score > 0

order by score

then union in the zeros.

select name,...

You might pick up a copy of this as well: http://www.amazon.com/Server-Relational-Database-Design-Implementation/dp/143020866X/ref=sr_1_1?ie=UTF8&s=books&qid=1260635050&sr=8-1

OK, 999 pages, I just had to post something and see if I could kick it to 1000.

I still want a "got SQL?" shirt.

Speaking of beer....

I got an email today from Red Gate, the subject was "108 bottles of beer and 16 pizzas"

The rest of the email was "in the servery" (cafeteria).

Some days...

I think Pavel is right. It has to be security. domain admins don't necessarily have rights to all folders.

What I'd suggest is you make a new share on the other...