Some error messages are template and need to raiseerror first, check for the error number and get error description, at that point, you will get the target objects (table name,...

MS SQL 2000 already has system stored procedure in msdb that returns error description from messages table. The system stored procedure is named "sp_get_message_description"

Thank you all for your responses.  I found out that the account running SQL Server does not have permission on SQL server folder where binn files are located.  I grant...

Check "Publishing SQL Server in Active Directory" article in SQL Server Magazine, the document ID is InstantDoc ID 41841.  This may help.

Mohamed 

Since tables are experiencing heavy inserts check if you have indexes on these tables, if yes try to minimize index usages because server may be spending most of the time updating indexes in each...

Yes I did have the same problem, I use temp tables to store the result then run a query on the temp table.  I am not sure about views though,...

Check this stored procedure  sp_makewebtask on BOL to build an html template and populate it with the data then use master.dbo.xp_smtp_sendmail stored procedure to send your email as an HTML...

I just saw your question online, I am sorry for being late to give an answer, but the following query allow you to iterate through each table in each database...

Write script to start trace and stop it, save the result into a table.  Put this script into job ans schedule to run on daily basis.  You can then:

-- Use sp_makewebtask...

you can explore the transaction log as Lumigent does by checking the following:

--#1 in SQL 7.x & above

DBCC LOG (database)

--#2 in SQL 2000

SELECT * FROM ::fn_dblog(1,NULL)

TRY UPDATE FROM as follow:

UPDATE a

SET c1 = b.c1

FROM b

INNER JOIN a

ON a.c1 = b.c1

WHERE b.c2 = 'some condition'

AND a.c2 = 'some condition'

Edited by...

quote:

---

I will create a new job again and check if I have the proper permission on the location of the backup files....

quote:

---

Try

http://support.microsoft.com/?id=810885

http://support.microsoft.com/default.aspx?scid=kb;en-us;319892

I already installed the security patches ...

---

quote:

---

What about running Profiler and Perfmon to monitor whats happening on the server when the problem occurs. This will hopefully enable you...

quote:

---

In fact that's what I did. As I mentioned, I already installed the security patches located on the links you specified....