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

You could just do value * 100 which would be 50 for .50

AndrewSQLDBA (11/9/2011)

---

Hello Everyone

This is yet another issue of duplicate data. This is very old data that is coming over from an old Unix and DB2 database. Just my luck.

In a...