Ok, seen this one before. Not too serious.

Take a look at this blog post. If you can't solve based on what's posted there, post back and someone will hep more...

Oh, ok. I see I need to play more. :blush:

If you justwant to recompile a single procedure, use sp_recompile.

Where? The only posts I see from you are these two. Link?

Yes

Paul Randal (11/5/2009)

---

Gail - the log file doesn't work as you describe. The *active* portion of the log *may* only be as you've described, as long as a bunch of...

julia.streatfield (11/5/2009)

---

Hi, I'm pretty much in the same boat as Keith, i.e. v.new to this game. I've got the same errors appearing during integrity check immediately after applying sp3...

You can buy a log reader (Apex SQL Log is around $1000) and see, but who knows what it's going to retrieve. just because the log is big doesn't mean...

This is a SQL Server forum. This is probably not the best place to ask. Try http://www.dbforums.com

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

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

If you get this repeatedly, call Microsoft's customer support people. They have the tools to analyse and debug stackdumps, we don't.

Please don't cross post. it just wastes people's replies and fragments replies.

no replies to this thread please. Replies to: http://www.sqlservercentral.com/Forums/Topic813865-291-1.aspx

The log contains only the changes since the last log backup (in full recovery when a full backup was taken at some point) or since the last checkpoint (in simple...

You think? Which database engine is the stored procedure part of? Shouldn't be a hard thing to tell.

If I...

Will see what I can find you, won't...