Will take a look, but may only be this weekend. Deadlock are a fair bit of work

You asked SQL to restore the database and then leave it in the restoring state so that you can restore more backups. That's exactly what NORECOVERY...

Try this then

SELECT COUNT(Email) AS NumberOfEmails -- get the count

FROM (

SELECT DISTINCT TOP 15 Email -- get 15 unique emails

FROM (

SELECT Email1,Email2,Email3, Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM outputresume3

...

Just 15 unique email addresses? No counts involved?

Move is used to move the mdf and ldf files. What was the exact command that you ran to start the restore? Did you use the NO_RECOVERY option?

Is there...

SQL can only do an index seek when the where clause references a left-based subset of the index key. In your first query, that's exactly what it's doing, so that's...

SQL choses the appropriate locking level and, unless you really know what you're doing, it's better to let it decide.

Can you post the full script of these two stored procs?

CLAS.dbo.P_delete_pending_request

CLAS.dbo.p_get_Appro_Data_Process

Given...

Threads can't be deleted. That's why I put the redirection in here and the request for no more replies. Just leave this thread alone and people can answer in the...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic846818-361-1.aspx

Sample data please. Just a few rows that are in the table so we can see what we're dealing with. 3 pages on and I still don't know what you're...

Can you post the entire deadlock graph please? There's no enough info in just the resource list.

You've got a classic two-object deadlock there. Processe613ac8 has the keylock (a lock on...

Is google offline again? Is books online not working?

These two, and all of their subpages will tell you just about all the changes.

http://msdn.microsoft.com/en-us/library/cc280407.aspx

http://msdn.microsoft.com/en-us/library/bb500435.aspx

Afraid not. I'm still trying to get the weather to confirm to my...

Ok, that's looked after by the webmaster, not me. I'm doing manual notifications this...

Never got any mail. Did you send it via the forum? Can you try a PM?