... I had more to say but for some reason my submission got cut off.  Generally though, I just said that using the question to promote a site is ok,...

I have 2 issues with this question:

1) since it was put under "Category: humor" I assumed that any answer would do so I picked sqlservercentral just because I like the...

Also consider http://www.idera.com/Products/SQLdm/

Just thought I would mention that I had the same issue.  see:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=116003#bm116046

ok, I'm confused though, are you encountering an error when trying to change the password or not?

Interesting, thanks for the reply.

It ended up being that after yet another reboot it automagically fixed itself up!  However, I think you may be onto something regarding the NET VIEW...

Try something like this:

sc \\Servername config "SQLSERVERAGENT" password= <new password> >> c:\sc.txt

Replacing <new password> with your new password.  That is, perhaps you missed the quotes around the service name?

I don't have a complete solution for you, but here are bits and pieces to help you along the way:

Services

The Windows 2000 Resource Kit utility sc.exe can be used to...

Perhaps I did not make myself clear previously... there are no cache misses or checks into sysobjects for the internal "guts" of the stored procedure.  Instead, these cache misses, etc...

Not sure I agree with the answer to this.  That is, on my site where we have Oracle, Sybase and SQL Servers the call to this DMO returns Sybase and...

I have been meaning to respond to this one for a while now, so hopefully someone is still listening to this...

I actually don't agree that one will be faster than...

I too am disappointed with this question.  When I initially saw it this morning and the possible answers I thought “good, someone is deliberately asking a question in which BOL...

Here is my contribution to this old question:

CREATE  FUNCTION dbo.udf_ProperCase

 (@StringVal AS Varchar(8000))

RETURNS Varchar(8000)

AS

/*******************************************************************************************

<cdCmnt>

    <descr>Returns a string as proper case using ASCII values

  After scouring the internet, found many, many proper...

I thought I would post a quick update on this...

- any hotfix after .818 is returning job steps in alphabetical order instead of job id order (when right-clicking job and...

GO's are T-SQL batch separators.  As a result, the SQL you mentioned above is actually 2 pieces.  The first gives you a stored procedure that inserts into Address and only...