Hi,

After changing the security audit level to all. I received an error from the SQL server log.

Error: 15457, Severity: 0, State: 1

Please advise.

Hi Guys,

If i having a duplication problem on table index. anyway to list the duplicated index and delete the duplicate once?

Thanks in advance.

Hi Steven,

I did it from both, EM and Backup maintenance plan. Backup operation failed. Please advise.

Hi Mccork,

Thanks for your reply! I found it. becuase the option is enable and I configured transaction log backup for every 10 minutes. The task will automatically run before the...

Yes, the task happened for every 45 minutes 1 hour. From sp_who2, I found that the program name "SQLDMO_1" was running the task. Any idea?

I am running ERP system. From profiler, the task ran from local host. I can't find any task in windows schedule as well. please advise!

Thanks for your reply!

Hi MarkusB,

May I know, how to drop a table in publication?

Thanks in advance?

For Running jobs. Need to know what jobs are still running? Ever come into work on Monday morning to find several critical jobs having ¡°piled up¡±, running way to long,...

I am updating MDAC to ver. 2.7 for clients and monitoring the status. Thanks for your advise.

I am very interested on this topic.

Anyone can share with me the trigger syntax to delete and insert into "pending deletes" table?

Hi,

I managed to get it right now. In order to configure the alert. The user account to start the Server server and SQL service agent services must be similar...

MarkusB,

Yes, I can find it. and now I can start the mail session. However, I encounter another problem when I send the mail

From QA.

EXEC xp_sendmail 'louis_see@Yahoo.com', 'The master database is...

Hi MarkusB,

Thank for your reply. May I know where can I change MSSQLService account? Because I only can find MSSQLServer and MSSQLAgent in Services.

Thanks in advance.

Actually, My senior DBA is helping me on this issue as well. He said by using QA and run the sp_configure. For more detail, can find it in book...