Ninja's_RGR'us (3/3/2011)

---

Grant Fritchey (3/3/2011)

---

I'm still at the MVP summit so I have no time to play. I'll see if I can experiment a little when I get back next week....

Received in PM:

tonymartini777 (3/2/2011)

---

Sir,

Your response was spot on. Sorry for the confusion. Here goes the long version.

I want to create a scalar UDF where I pass the said 'tagname, starttime,...

Thanks, Grant.

I'll call support ASAP.

You're probably right.

Let's see what happens, I'll keep you posted.

Thank you, guys.

Dave Ballantyne (3/3/2011)

---

WTF! No, way, even from DAC.

EDIT: Interesting side-effect of my original issue: I found...

You could do both. Personally, I would write a stored procedure.

Dave Ballantyne (3/3/2011)

---

Gianluca Sartori (3/2/2011)

---

I wish I could, Jeff!

This statement is inside a system stored procedure and I can't modify it. I must admit I tried (when everything else failed)...

I don't want to be...

I tried, but the problem is always the same: I can't reference the object named "sys.sp_mergemetadataretentioncleanup" in the plan guide, because...

I don't understand if you're trying to create a scalar UDF...

CREATE FUNCTION getSomeValue

(

@TagName varchar(128),

@StartDate datetime,

...

You could use database mail.

If you are inserting from a stored procedure, you could add the code there, otherwise you could send the email from a trigger.

I wish I could, Jeff!

This statement is inside a system stored procedure and I can't modify it. I must admit I tried (when everything else failed) and my ALTER PROCEDURE...

WayneS (2/25/2011)

---

Thanks Gianluca.

[shameless plug] And if you happen to be going to SQL Saturday #69 in Philadelphia on March 5, 2011, I'll...

Not true: operations on table variables are logged, but don't participate in...

Check this great article by Wayne Sheffield:

http://www.sqlservercentral.com/articles/Temporary+Tables/66720/