GilaMonster (10/9/2012)
Evil Kraig F (10/9/2012)
YarHad (10/9/2012)
GilaMonster (10/9/2012)
Index rebuilds don't get written into the SQL Server error log. You could add a piece to your maintenance tasks to log that a rebuild was done if you like, or run a trace or set up an extended events session.Ok, so it doesn't get written into the sql server log. Nice to know
Thank you very much!!
Just to clarify, what Gail's repeated above is that the Index Rebuild WILL be written into the log file (.ldf) that's attached to the database. That's not human readable, unfortunately.
Welll....... I can read it. Mostly. 🙂
I'm still not entirely convinced you're not a Turing Complete database with the amount of knowledge you inhale for fun, though... 😛 I shouldn't pick on ya much for it though, I certainly benefit a lot from your knowledge. 😎
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA