Is it possible that someone recently setup a Severity 10 Alert in Sql Agent?

I believe that even if thier isn't an alert action setup it will still log errors in...

I agree with Antares... You'll want to check with the developers and ask them specifically why they think the account needs to be a domain account. Is thier...

I think what they are trying to say there is that you will impact performance if you use a cursor within your trigger to step through the inserted or deleted...

I think your best bet for seeing only MSSQL data would be through profiler... I believe you can capture reads and writes with it. But it's not going...

From Microsoft KB Article Q315886:

Q12: Why does SQL Mail stop responding (hang)?

A12: If SQL Mail hangs periodically, the most likely cause is the loss of a connection to the mail...

From Microsoft KB Article Q315886:

Q5: Why is my outgoing mail stuck in the Inbox?

A5: This problem is more likely to occur with Outlook 2002. To improve Internet e-mail performance, the...

I would never suggest doing this but you might need to change the IUSR account to a guest domain account and then grant that domain account access to your database...

It sounds like there were some nonlogged operations against your database and the job you setup is trying to run a transaction log backup before the full database backup. ...

I decided to write a stored procedure that reports on account changes based on the syslogins and sysusers tables only (there's no datetime column on the syspermissions table). This...

If you are trying to speed up your application then find a way to do the work without using a temp table. I have found that people often resort...

I've worked with both...

PostgreSQL definately has some pitfalls that you should be aware of,

but I've been able to work around most of them.

First off and most annoying is the lack...

I think you woul have to use either

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

GO

BEGIN TRAN

select INS_FK, PAC_FK, dbo.acc_calcbalance('B', PAC_FK, INS_FK, getDate(), NULL, getDate()) Balance

from ACC_BCA_Balance_Calc_Vw

group by INS_FK, PAC_FK

COMMIT

OR

select INS_FK, PAC_FK, dbo.acc_calcbalance('B',...

I think the only way would be to break the Sql Server encryption...

I've never tried it but it looks like it can be done:

http://www.sqlsecurity.com/uploads/sql2k_spcrypto.txt

Good Luck,

Dan

Oh and you can do the same for the master..syslogins table

You might be able to try something like this to catch changes to user permissions:

select * from databasename.dbo.sysusers

where updatedate > dateadd(dd,-1,getdate())

If you capture a copy of the table after...