I think you should look at your application code, to see what happens when the form is processed prior to updating the database.  To me, it looks very likely that...

Changing the service account PASSWORD using control panel/services should never cause you a problem.  The only thing that EM does with the password is to store it in the same registry...

You need tempdb to be big enough for your daily and peak workload, without it needing to grow while the work is running.  You should not plan to shrink tempdb...

You can get an update to SP4 that just includes the 2040 hotfix.  However you should also consider moving to the latest post SP4 hotfix rollup (build 2187).  Google will...

As far as I know, @recipient must refer to a e-mail address, not to a SQL operator.

If you want to put a layer of indirection into the process, you can...

Your problem appears to be lack of memory for client connections.  How many concurrent connections do you need to support?  You may be able to fix this by changing some of...

It seems that some people are confusing two completely different things.

a) Realeasing space in a log file via a log backup

b) Reducing the size of a log file via a...

If you use PSExec, be aware that it requires that the caller (on server A) be a member of the local Administrators group on the targer (server B).  Before building an...

If you are thinking of using the job completion notification functionality in Agent, then you are stuck with the standard mail format used by Agent.

The best you can do is...

We run the 2187 level in production without the -T3625 flag.  As described in KB 900625, the 3625 flag masks potentially sensitive user data.  It is up to you to...

I had the same issue.  It looks like the SP2 install places a new version of the Resource DB and distmdl in the same folder where master.mdf is located.  BOL...

It should work, but I have experienced the following problem...

When SQL Server installs the SQL services, some of the path names are in 8.3 format (e.g. mssqls~1, mssqls~2, etc).  I...

I think you are saying server A is Teradata, server B is Teradata, these are linked to server C which is SQL.  You want to join data in server A...

I would only put SQL on a domain controller if it was the only machine in the domain.  It seems you have at least 35 other machines in the domain......

What does the SQL ERRORLOG file show for the attempted start.  Also, is there anything relevant in the Windows System or Application Event Logs?