Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
emailuser
Yak Posting Veteran
74 Posts |
 Posted - 2011-03-24 : 09:10:44
|
| Hi, our SQL agent on our 2005 server will not start we always get the error any help greatly appreciated ....Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it. (System.Windows.Forms)------------------------------Program Location: at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay) at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy) at Microsoft.NetEnterpriseServers.ExceptionMessageBoxForm.CopyToClipboard() |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2011-03-25 : 11:41:58
|
| how and where do you get the error?--------------------keeping it simple... |
 |
|
|
emailuser
Yak Posting Veteran
74 Posts |
Posted - 2011-03-25 : 11:52:32
|
| Hi , the sql agent is always showing as not started , in enterprise manager and windows service , not sure how long it has been like this, right clicking and selecting start in enterprise manager gives the error below , also through windows services it starts and stops straight away |
|
|
|
|
|
|
SQL 2005 Agent error will not start