Jeff Moden (9/26/2008)

---

No clues about whether the object already existed or not which certainly protects you from an accidental overwrite, but leaves room for the error of code not actually...

I write a lot of my own script generators and then repeatedly execute the results and from my experience, it's not accidental overwrite that they are primarily protecting you against,...

Hmm, I am not sure of all of your conditions (obviously) but if the script needs to include an IF [NOT] EXISTS, then the body will have to be Dynamic...

I think that you may have confused Sisyphus (eternally condemned to push a boulder up a hill) for Prometheus (bringer of fire/light/enlightenment to humanity). Mind you, I think that...

You do realize that this executes on the Server and not on the Client, right?

Glad we could help.

XP_CMDSHELL is all you need.

Gosh Jeff, you make it all...

Will Summers (9/22/2008)

---

The columns I am talking about are Last Run Date, Next Run Date, Enabled, and Status. Also I would like to see the icon that shows if...

Please do not cross post.

Make sure that Veritas is backing up the logs correctly.

Heh. Yeah, I should mention that any Junior DBA's reading this probably want to check with their boss before they use this command. It is not gentle with...

francis (9/20/2008)

---

😉 I do mean to kill them cause I am not be able to complete the daily backup !

😛 Thanks for the formula, how could I apply the cyanide...

Actually, I'm using my blog to hold the pieces and incomplete articles until I can get them together into full articles.

The ASCII() function only returns the ASCII integer value of the first character:

select ascii('m'), ascii('mz')

----------- -----------

109 109