This should do the trick, also dont forget the power of Google or your favourite search engine

set datefirst 1

DECLARE @dt DATETIME, @WeekOfMonth TINYINT

SET @dt = '2007-07-08'

SET @WeekOfMonth = DATEDIFF(week, DATEADD(MONTH,...

David, your getting confused over blocking & locking and deadlocks, what you are seeing is typical behavour within SQL and is blocking as two sessions are waiting for the same...

What I think John is getting at is which is quicker?

In the example I have used I say 2 hours to perform the index rebuild, so it takes 2 hours...

what is under the alerts folder in SQL Agent?

do the other people know how the alerts are setup?

do you need adding to an operator?

what alerts have you missed? how are they configured? where do they pick up the email address settings from? do all alerts send to the same people all...

you can send me a private message on here or keep posting to the forum. I would recommend the forum so that if anyone else has the same issues...

This will point you in the right direction if you dont have the traceflags enabled on your instances

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

Will need to refactor the job to send the mail, or get it...

Yes you can do that but you will still have sync issues as your not really changing anything which isnt already setup automatically.

Your still in the situation where if the...

can it connect to SQL?

No - Problem with the server principle (doesnt exists/set to deny connect/password expired/wrong password..... there are many different causes)

Yes - No problem

can it connect to the...

It can certainly cause sync issues in terms of it has to rebuild the index on the secondary server due to the operation being logged, so if an index rebuild...

ChrisM@Work (5/16/2012)

---

anthony.green (5/16/2012)

---

I thought the whole point of allowing the MAXDOP setting in statements is to override what is set at the server level as the options are evaluated at...

SQLCrazyCertified (5/16/2012)

---

SQLCrazyCertified (5/16/2012)

---

jitendra.padhiyar (5/15/2012)

---

Hello Masters,

During upgradation, all the user database will be upgraded to new version, but what will happen to system databases?

When you install newer version, system databases comes...

What is the problem you are having with this procedure?

I thought the whole point of allowing the MAXDOP setting in statements is to override what is set at the server level as the options are evaluated at run time...

are the primary and secondary servers the same spec? especially in terms of drive sizes?

what error messages do you get on the copy and restore jobs?

it might just be a...