dbcc inputbuffer should not be returning trigger code. fn_get_sql will, but DBCC Inputbuffer should not.

Are you sure you're seeing that function's result and not the other one?

Reposted to SS2K5 Forum, no more replies here please.

New Thread

Not a problem at all Tom. Does DBCC INPUTBUFFER not return the data you are looking for? If you're looking for the statement right before the trigger that...

Spoke too soon, yes it does, my fault:

DECLARE @Example

TABLE (

field1 VARCHAR(30) NULL,

...

It doesn't when I run Paul's Code:

DECLARE @Example

TABLE (

field1 VARCHAR(30) NULL,

field2...

Sometimes it's the little things ;-).

Get rid of the 'GO' after the table creation.

Are you aware you're selecting out of a different table than you're dropping/creating/populating?

Thanks for solving that mystery Sergiy. That woulda bugged me for weeks.

Ian Yates (12/9/2005)

---

3ms is the smallest unit of time a datetime field can capture. So by subtracting 3ms from midnight, you get the latest possible time that could be captured...

Heh, ok, I don't know what I was thinking when I linked that. I guess I should have actually tested that first. That code was all wrong, I...

douglas.allison-1136597 (3/29/2010)

---

Hi Greg

Thanks for that the formatting is not the messy part as when I see it on Manager ets it's all tastefully indented etc.

Will have a look laters at...

Ordinarily, I'd have said that Dynamic SQL would likely have fixed the issue, but you can't use that within your function. I think you're on the right track with...

It's an order of operations thing. If you look at the execution plans, the sort doesn't come until after the compute scalar. Removing the order by, removing the...

My pleasure Tom, glad I could help.