After 1659 days of this question, still helping.

Thanks a lot.

webrunner (9/16/2013)

---

Thanks - could you post any more information on this, such as a specific error or one of the Microsoft fixes or support documents about this issue? It seems...

Exelent post!

I use XP_READERRORLOG to do something similar, but i need to say: sometimes XP_READERRORLOG enter in an infinite loop than can't kill (only reset of course)

😉

yeah! back ups and more back ups... that is the question!

I use this method for a time and i continue thinking that is the most friendly for newby database developers to debug.

Exelent explanation.

and SQL2008 RTM will be discontinued?:w00t:

I found a little error when test a 2008 r2, show messages for 2005

Excelent!

I was working in this for hours... and I can't resolve the problem... :hehe:

thanks a lot!

ssaari (8/26/2009)

---

When I ran the script, I received this error:

Msg 102, Level 15, State 1, Line 27

Incorrect syntax near '('.

Line 27:

FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, 'LIMITED') AS i

Please...

Hi, Excelent script. but i add a little if to use the enterprise on line defrag

SET NOCOUNT ON

PRINT '---------------------------------------------------------------'

PRINT 'DefragIndexes.sql script started on database [' + DB_NAME() + ']'

PRINT...

Hi Rudy, excelent script!

but, you have a little bug at the en of the second comment... /* instead */ ;P

Hi all, I change the dynamic query to default_databse to avoid...

I made some modifications, like a bigint in some variables and put in on one line to run it in openrecorset.

declare @ts_now bigint, @iUserCon INT, @iLogInStart INT, @iLogInEnd INT, @fSeconds...

Hi, i have similar problem sometime ago. I have a user that need to be dbo for some reason but i neet to limited to "no drop".

i found the solution...