Thanks. I used WINZIP to extract the source for SQL Server 2008 R2 Standard. Looks like I need to get my server rebuilt.

Our problem has been resolved. Someone had made some SSL registry changes which affected SQL Server and other applications on the box.

Mohammed supplied the correct link.    

The server team added extra memory to the problem server and it sill hang.   The hotfix worked for our situation.

We were having hanging problem each week with one of our SQL 2000 servers last year.   We tried all sort of things to find out what was wrong.  I eventually ran...

Great article.  However, it would have been helpful if you would have provided the counter used for Low Memory.  I believe that you are referencing Memory: Available MBytes. 

Thanks

When my company merged with another company, the other company was using the basic Outlook client for email messages.  On my side we used stored procedures.  Refer to http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech.

There is an article that describes how to send email messages without using SQL Mail.  Refer to http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech.

I utilize a version of the stored procedure given in the above...

Jo is correct that the optimization job uses DBCC REINDEX.  Since your database is so large, the process probably takes hours to complete. 

I have noticed a large transaction log...

The STR command may be helpful. 

Hi Linda,

How do you handle pushing data to packed fields on a DB2 table?

The osql utility is described in Books Online. Example:   

osql -E -Sservername -Q"query"

When you create a job step, it normally defaults to T-SQL.  When you edit a job step, change...

Change the type to Operating System Command and execute the query using -osql command.  I learned this technique after searching the web for monitoring scripts.