Live Chat Software by Kayako |
Knowledgebase: Microsoft Outlook
|
How can I tell if dialog box messages are causing SQL Mail to stop responding?
Posted by - NA - on 22 March 2006 08:27 AM
|
|
|
Solution: Because SQL Mail is run through the SQL Server service, any dialog box messages that cause SQL Mail to stop responding do not appear on your desktop. To determine if SQL Mail is causing dialog box messages, you must run SQL Server as a console application, not as a service. To do so, use these steps: 1. Log on to the Windows server with the same account used to start the SQL Server service. 2. Open a command prompt window. If you are using SQL Server 2000, you must navigate to the directory in which the executable files for your SQL Server instance are installed. 3. Start SQL Server as an application by executing this command: sqlservr -c NOTE: For SQL Server 2000, if you use a named instance, you must add -s with the instance name. 4. Connect to SQL Server with Query Analyzer, and then run the xp_sendmail extended stored procedure to test sending a mail message. If you are not using SQL Server 2000, you may need to run the xp_startmail extended stored procedure to start SQL Mail before you try to send mail. 5. If a dialog box appears, you must correct the problem before you can use SQL Mail. | |
 (160 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)