Hmm, there seems to be a lot of confusion here between Windows logons, vs SQL logons. The xp_cmdshell_proxy_account is a Windows logon. So when I say "Log on...

Daniel C (10/14/2008)

---

Yes, indeed, I have the unique index on date_created (smalldatetime NOT NULL) and indeed the trigger removes the time part and inserts only the date. BUT,...

GilaMonster (10/14/2008)

---

In addition, you just have to miss one place and all of your checking is useless. If the web user has no rights other than exec procedure then you...

Well,...

bcronce (10/14/2008)

---

I have a question.. lets say you have to use a dynamic query. how about you modify the dynamic query string like this

eg.

incoming query: " select * from test1...

There are, but they may or may not be what you are looking for. in Management Studio, right-click on a database in the Object Explorer pane and select "Reports.. Standard...

Awesome article Jack!

jsheldon (10/14/2008)

---

rbarryyoung (10/14/2008)

---

Two questions:

1) Does the '##xp_cmdshell_proxy_account##' credential exist? If so, what is it?

2) What rights...

Daniel C (10/14/2008)

---

That could work, I see only one problem: if I have one transaction with multiple inserts, how is this going to behave?

To my understanding, there's no handling in...

This paragraph from BOL pretty much sums up the situation:

xp_cmdshell Proxy Account

When it is called by a user that is not a member of the sysadmin fixed server role, xp_cmdshell...

jsheldon (10/14/2008)If I add Grant Execute to DBSBATCH and rerun the procedure again under DBSBATCH I get this

Msg 15153, Level 16, State 1, Procedure xp_cmdshell, Line 1

The xp_cmdshell proxy account...

I am not sure, but I think that you can do this with an INSTEAD OF trigger. Put a Unique Key on the field and then in the trigger,...

Perhaps I should clarify though: my original reply was only meant to comment on sending mail from a Trigger, not anything else that Steve was recommending.

Jack Corbett (10/14/2008)

---

rbarryyoung (10/13/2008)

---

Steve:

You're right that SQL Mail (xp_send_mail) is a No-No from a trigger, however Database Mail (db_send_mail) is safe from a trigger because it is built around...

Tim Brandt (10/14/2008)

---

SQL server is the only application I am having speed issues with. If I...