John Waclawski (3/11/2013)

---

I too am running into this with SQL Server 2008 R2 at the moment.

I'm getting a subject line, no body text. Still plugging away at it. ...

No problem. I just ran the same code and it is formatted correctly. Have you tried debugging the code to see where it is going haywire?

Fear Naught (3/11/2013)

---

A very good function however it seems to miss the leading zero off dates that are in the first 9 days of the month when using a format...

Dave Vroman (2/8/2013)

---

Couldn't get yours to work. Too many errors in the post. We're using this one. I wanted to see the difference. The table of holidays contains only holidays...

Tested and works,You could use the SP_SEND_DBMAIL option. For this you need to specify some paramaters as seen below, for the @recipients you could just enter the correct text message...

Thank you for the help. After i posted the topic i poked around and found out that my boss has a VMware backup running at the same time and i...

So i was able to get a trigger that would see if the connection made was trying an insert, delete or update and if so it would block that connection...

Here is what i came up with. What i am trying to accomplish is say if the sql command is a DELETE, INSERT or UPDATE and it was requested from...

Steve Jones - SSC Editor (11/12/2012)

---

A login trigger may help you here, but in conjunction with an application role. You might be able to trigger an application role as part...

I thought of doing that, i am actually trying to write the trigger and test to see if that works. The problem i am facing is that the users are...

The problem i am faced with is my company uses a thrid party application. This application needs to have all the users assigned to a role which has just...

Thank you all for your comments. LIttle history behind why i came up with this querey. I work as a sql dba and report writer for a legal...