Hmmm... Of course, make sure Notification Services is installed. I'll check any documentation once I get back on Wed. Are you getting any errors?

No problem at all. Glad to help.

Here's my Errors database, which contains the proc and table. This is my standard, BTW. I don't like doing error logging or the like...

No, I never did. I've mentally moved on to other things, so I doubt I'll be doing it.

I found all the scripts and I attached them to this post....

Here you go:

create procedure [dbo].[usp_CheckUserPassword]

/*======================================================================

Name of Procedure: usp_CheckUserPassword

Date Created: 02/23/06

Created By: Brian Laws

Description: Check to see if a given password is valid for a server

Returns: 0 = Success, 1...

Actually, I'm thinking better of posting my whole solution here. Since this system is incredibly sensitive, I'm conerned that my posting it may expose any security holes and thus make...

Yelena Varshal (11/14/2007)

---

Brian and Dave,

these are good points and we do have SOX and FDA auditors. I am not sure they will be happy if we have uniformed SA passwords...

Yes, I believe there is....

Hello! Here's the main stored proc that I use (usp_ChanageSAPassword). I simply loop through a list of servers and call this procedure for each one. It's worked pretty well so...

Donna, I'm experiencing the same thing. I have no idea what's going on. The only thing unusual that I can think of is that my install was different than my...

Thanks for the feedback! I already have a stored procedure that I use throughout our enterprise for removing old backup files. I was just hoping that I wouldn't have to...

Well, I figured it out. It was my own stupdity (most of life's problems usually are). When I copied the CDs locally, I copied the 2nd disk to the Servers...

I also like doing clean installs, but the problem is the password-protected DTS packages. I suppose I can hack the password via the parameter in the scheduled job. I know...

You're right! You got it! You're awesome! :>

The only difference with what you had above is that I was going from a SQL 2005 to a SQL 2005, with no...

No, unfortunately that's not it. I tried creating a test user and using him in the connection string. No luck -- it still rolls back. Well, at least the MSDASQL...

Well, I never was able to get that trigger to work. However, I found another way to do it: event notifications and the Service Broker. I created a Service Broker...