Do you have the limit the size of job history log checked? If it is what are the # of rows that you are keeping?

I don't know that you want to join back to the original table, but you should use both inserted and deleted because the functions update and columns_updated consider a column...

How do you have permissions to the AS400 setup? What is package encryption set at?

Check out this article from BOL.

You could use Execute As, http://msdn.microsoft.com/en-us/library/ms188354.aspx or perhaps signing the trigger, http://www.sommarskog.se/grantperm.html#Certificates. I'm not positive that you can sign a DDL trigger.

I think this article[/url] might help.

Do you mean while you are restoring or do you mean a historical record?

The only thing I'm aware of is what is in msdb.dbo.restorehistory and it does NOT have a...

Brandie Tarvin (11/14/2011)

---

After looking at the link Remi posted, and noticing the MERGE answer there, I have to wonder. For a simple one or two table update like that, is...

Congrats! I don't know how you do it AND keep up with SQL Server....

Sorry to hear...

That IS his hobby 😀

I don't see a link anywhere..

Roy Ernest (11/9/2011)

---

L' Eomot Inversé (11/9/2011)

---

GilaMonster (11/9/2011)

---

Roy Ernest (11/9/2011)

---

Darn, I was submitting an article here and as soon as I uploaded an image, it removed all the previous text I...

DarthBurrito (11/9/2011)

---

Thanks for the reply. This is what I did after I posted the question.

I made a huge IIF statement in the textbox:

IIF(Parameters!Percentage.Value = "0.50", "50",

IIF(Parameters!Percentage.Value = "0.51", "51",

and...

Why not use ROW_NUMBER() instead of appending a number to the end of the name? Then you delete where row_number > 1