Here's an alternate way to list the names of procedures that the current user has execute permissions on..

select o.name

from   sysobjects o

where  o.type = 'p'

and    permissions(o.id) & 32 = 32

..see...

Ugh - missed the 64bit part on both accounts

Indeed - with a 64bit platform you have plenty of room to adress 4 GB ....

I would actually like to advocate that you never use EM for any kind of write operations, especially not as sensitive as shuffling data around. Main reason for this is...

Personally, I recommend that you start by having these enabled. Only if you run into problems that may be related to the maintenance of index stats should they be of...

From BOL

You don't want to have...

It looks to me like you have the 'autoclose' database option turned on? (see sp_dboption)

/Kenneth

There's really no short answer to all those questions, but I recommed that you start by looking up 'memory' in Books On Line. It's a good starting point, and there's...

Well, I wasn't aiming at you in particular, John, though I think that you too in your post may have used 'blocking' and 'deadlocking' somewhat interchangeably. ( 1) describes how to...

Just a note to clear things up (or perhaps muddy everything even more )

Transact SQL CASE is not a switch statement like it...

Can you elaborate a bit more on what you are trying to do? ..and perhaps also why? (it gives a good background to know the reasoning behind ones attempt to solve...

To make life easier when dealing with dates, try not to use ambigious dateformats.

select * from table where DateTest between 02/06/2005 and 01/01/2005 

There is no way to read these...

Please do not confuse deadlocking behaviour with 'normal' locking behaviour - aka 'blocking'.

Deadlocks occur when two processes ends up waiting for each other's resources already held by the other part....

A deadlock can happen when two processes does the same thing, but in reverse order.

Say you have procA that within a transactions wants to modify tableA and then tableB. At...

Try to look at the data you're retrieveing for column wins.numwins. Could it be possible that you have something in there that is > 99 ..?

/Kenneth

You still can only use bcp for

table => file or file => table - you cannot use bcp for table => table

/Kenneth