Also I don't know which language you are using, however you can change the language for the user like:

Check the language that has the first date Monday... more correct check...

Did you try:

SET DATEFIRST 1;

GO

Check the first date with

SELECT @@DATEFIRST

Yep!

Did you check if your account is locked in Active Directory, just in case!?

Jeff, you are amazing how you are playing with T-SQL!

In every code that you have published for any solution, I have learned something new!

Thank you sir!

Dugi

Take a look to the sweet tool from RedGate that is still free to use and let us know what happened!

http://www.red-gate.com/products/dba/sql-index-manager/[/url]

Seems that we need to update the list so seriously, Steve make someone Admin for incoming updates of the SQL Server!

Seems, time for the consultancy or reading and searching lot of stuff about Performance ...

Hmm and something when you are working with critical things on critical environment, is when you need to change something, just duplicate in this case you SP and rename it...

Try this if you can find something in the Query Column:

SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query]

FROM sys.dm_exec_query_stats AS deqs

CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest

ORDER BY deqs.last_execution_time DESC

Congratulations Jeff - I knew that you deserve it and you will win ! :w00t:

So thank you from community point for your help to the SQL Community!

~ Dugi

Jeff Moden (8/9/2011)

---

Dugi (8/9/2011)

---

Jeff,

Thanks for the very nice stuff! Simple to say that I need to read it again and doing more and more practicing and practicing ...!

Have a nice...

Jeff,

Thanks for the very nice stuff! Simple to say that I need to read it again and doing more and more practicing and practicing ...!

Have a nice day,

Dugi

Ninja's_RGR'us (5/13/2011)

---

Dugi (5/13/2011)

---

stan-617410 (5/13/2011)

---

Thank you...

Ninja's_RGR'us, you are right... I have a trigger, I didn't realize that it was having the problem.

Thanks Dugi, your last submission is where I...

stan-617410 (5/13/2011)

---

Thank you...

Ninja's_RGR'us, you are right... I have a trigger, I didn't realize that it was having the problem.

Thanks Dugi, your last submission is where I started.

I appreciate...