RPC Problem & SQL Not Shutting Down
May 25, 2000
Hi All,
I am currently facing two problems. Any help will be appreciated. We are using MSSQL SErver 65 , sp5a.
Problem 1: RPC Error....
Has anyone rcvd. the following message & how do we resolve this. ?
Unexpected end-of-message encountered in RPC response
from site 'SGPINT'. (Message 7224)
Problem 2: Shutting SQL Server
We shutdown SQL Server every day by running a dos script with the following command
net stop SQLExecutive & net stop MSSQLServer.
This has been working fine till a few days back. Currently, the SQLExecutive service is shutting down & SQL Service does not shutdown. There are no entries in the errorlog or event logs. The SQL Server hangs & then no-one can connect to it.
Any help will be appreciated.
Thanks !!!!!
Vedanth
View 1 Replies
May 4, 2004
I have a job that runs daily that imports a huge text file to my database. I do not want the transaction log to track every transaction log in this DTS. Is there a way to import it using my DTS and have the log ignore it?
View 4 Replies
View Related
Jan 25, 2008
I have setup database mail on my SQL 2005 server. It works fine. I am using it to send subscription mail. If the email addresses are good, it works fine. If there is a bad email address rather then skipping that email address, it shuts down and quits the rest of the process.
Is there a way to configure it to log the error and move on? With SQL 2000 all it did was toss it into a queue and hope. The SMTP server dealt with the problems. Now it seems Database Mail is determining there is a problem and giving up.
While I love the new sysmail tables that allow me to track what happened, I hate the fact the the system decides if is too frightened by an error and it needs to runaway and hide. [:D]
Also, does anyone know of a good resource for describing the sysmail table relationships?
Thanks in advance for the help,
Thom
View 2 Replies
View Related
Jan 24, 2008
I have setup database mail on my SQL 2005 server. It works fine. I am using it to send subscription mail. If the email addresses are good, it works fine. If there is a bad email address rather then skipping that email address, it shuts down and quits the rest of the process.
Is there a way to configure it to log the error and move on? With SQL 2000 all it did was toss it into a queue and hope. The SMTP server dealt with the problems. Now it seems Database Mail is determining there is a problem and giving up.
While I love the new sysmail tables that allow me to track what happened, I hate the fact the the system decides if is too frightened by an error and it needs to runaway and hide.
Also, does anyone know of a good resource for describing the sysmail table relationships?
Thanks in advance for the help,
Thom
View 6 Replies
View Related
Aug 27, 2014
When I start SQL Server Agent it's shutting down minute after starting. I tried to set Alerts to send email. After I configured Database Mail ,I was able to send test email , however after that SQL Server Agent started to misbehave.
View 3 Replies
View Related
