anthony.green (6/1/2012)

---

I might be wrong, but I thought that option was for SQL Mail and not DB Mail so therefore shouldn't be in 2012 as SQL Mail is depreciated.

There where...

Lowell (6/1/2012)

---

Manie the key is the specific error messages you see in msdb.sysmail_faileditems.

take a look at the data from this SELECT statement:

are all the err.[description], basically the same? what is...

I agree. I do not see the purpose for this. You would anyway...

K. Brian Kelley (5/10/2008)

---

The problem is that CREATE LOGIN and ALTER LOGIN won't take the variable. The way around this is to use Dynamic SQL. For instance:

CREATE PROCEDURE dbo.Create_Login

@username sysname

AS

BEGIN

SET...

Hi guys,

Sorry for never giving feedback here but work has been hectic taking all my free time but no, sorry Brian I could not get your script going and was...

Thanks guys for all the replies. I have actually decided that I am after all not to do it and rather check the tables as I go and where necessary...

This project that I am doing has been coming with me ever since I inherited this database. I have been walking into walls in many ways because of a lack...

Hi Steve,

I wish you and your family as well as everybody on SSC a splendid and blessed 2012. May we all prosper in the New Year. My goal (rather than...

I honestly do not understand why people, in any sphere of life, has to spice their words with swearing and bad language. It is bad taste.

Steve, you are so right. Be thankful for what you have and if you are unhappy find something else. However, in the current economic climate I would say hold on...

Do I do better now than last year? Well, let me put it this way. I still have a job and I am thankful for that.

Hi Andy, very nice and accurate article indeed. You see I am in the unique situation where my boss wants me to work from home on days I do not...

At this point in time I am battling to read at least 3 articles a week so I can at least grow a bit but hey, I also don't complain....

I won't say I do not have any mundane or boring parts in my job but fortunately that I in the minimum and yes, I have also learnt to automate...

cphite (2/14/2011)

---

Interesting solution, but honestly I think a far better solution is to train your developers to avoid doing things like SELECT * in production code, along with having a...