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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Mail

Author  Topic 

brendalisalowe
Constraint Violating Yak Guru

269 Posts
Posted - 2004-12-01 : 13:52:47
When I run this:

exec xp_startmail

It says this:

Could not find stored procedure 'xp_startmail'.

Why?

Brenda

If it weren't for you guys, where would I be?

Kristen
Test

22859 Posts
Posted - 2004-12-01 : 13:58:16
'Coz its in master database?

exec master..xp_startmail

Kristen
Go to Top of Page

brendalisalowe
Constraint Violating Yak Guru

269 Posts
Posted - 2004-12-01 : 14:06:38
Thanks!

Brenda

If it weren't for you guys, where would I be?
Go to Top of Page

brendalisalowe
Constraint Violating Yak Guru

269 Posts
Posted - 2004-12-01 : 14:25:43
Another question: When I right-click on SQL Server Agent, the Mail Session is grayed out. Anyone know why it would do that? I have a mail profile setup already. Weird huh?

Brenda

If it weren't for you guys, where would I be?
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts
Posted - 2004-12-01 : 16:33:04
Are you the DBA?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

brendalisalowe
Constraint Violating Yak Guru

269 Posts
Posted - 2004-12-01 : 16:38:34
I'm pretty much everything. I am in charge of all the IT stuff. Fun huh? Especially since I don't know much. Anyway, any ideas?

Brenda

If it weren't for you guys, where would I be?
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts
Posted - 2004-12-01 : 16:45:01
Are you an administrator when logged onto the server? Is the SQLServerAgent and SQLServer services running under the same user? What user is it?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

brendalisalowe
Constraint Violating Yak Guru

269 Posts
Posted - 2004-12-01 : 16:47:42
I created an account(SQLAdmin) and I am logged on as that. Then SQLSERVERAGENT and MSSQLSERVER both are set to startup with that account.

Brenda

If it weren't for you guys, where would I be?
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts
Posted - 2004-12-01 : 17:20:47
???? Is the SQL Server Agent turned on???

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

brendalisalowe
Constraint Violating Yak Guru

269 Posts
Posted - 2004-12-01 : 17:34:07
Yes, it is started.

Brenda

If it weren't for you guys, where would I be?
Go to Top of Page

izaltsman
A custom title

1139 Posts
Posted - 2004-12-01 : 17:57:42
Is Outlook set up as the default mail client for your service account?
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts
Posted - 2004-12-01 : 17:57:48
:) Stop and restart it. The SQL Server mail is setup fine, correct? What service pack of SQL Server are you on?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

brendalisalowe
Constraint Violating Yak Guru

269 Posts
Posted - 2004-12-02 : 16:25:47
I have SP3 installed.

I uninstalled Office 2000. I was just thinking of using Outlook Express. I can do that right?

When I uninstalled it, the Mail Session is NOT grayed out anymore. But now when I go to Control Panel, there is no Mail thing in it. Why would that be?

I am sick of this whole mail stuff. I just don't get why it won't work.

Brenda

If it weren't for you guys, where would I be?
Go to Top of Page

benwilson
Starting Member

6 Posts
Posted - 2004-12-02 : 16:52:05
Nope, needs to be Outlook as SQL mail needs a mail profile and Outlook express doesnt set one up. Check out this article for some help:

[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;263556[/url]

Ben
Go to Top of Page

brendalisalowe
Constraint Violating Yak Guru

269 Posts
Posted - 2004-12-02 : 16:55:48
What article? That link didn't work.

I used to have Outlook 2000 on there, and it still wouldn't work, so I don't think it will solve the problem.

Brenda

If it weren't for you guys, where would I be?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2004-12-02 : 16:57:23
SQLTeam software doesn't always display urls correctly. Put semi-colons in the url where you see the spaces in his post.

Tara
Go to Top of Page

Pace
Constraint Violating Yak Guru

264 Posts
Posted - 2004-12-03 : 06:52:35
Sorry to hijack your thread but it may be relevent, I came across this the other day, what is the double dot for on master..xp, I was reading on bcp and I noticed you use a double dot their too, I cant seem to find an explanation as to why...
quote:
Originally posted by Kristen

'Coz its in master database?

exec master..xp_startmail

Kristen
Go to Top of Page

Kristen
Test

22859 Posts
Posted - 2004-12-03 : 06:53:28
Its shorthand for "dbo"

master..xp === master.dbo.xp

Kristen
Go to Top of Page

Pace
Constraint Violating Yak Guru

264 Posts
Posted - 2004-12-03 : 06:54:48
Ahhh thank you
Go to Top of Page

brendalisalowe
Constraint Violating Yak Guru

269 Posts
Posted - 2004-12-03 : 15:17:39
I am trying to Install install SP1 for Exchange Server, but it says I need to install a hotfix first.

Do you think that is why I am having problems? Because I haven't installed SP1 yet? Would that make me not be able to logon to the MAPI?

Brenda

If it weren't for you guys, where would I be?
Go to Top of Page

Pace
Constraint Violating Yak Guru

264 Posts
Posted - 2004-12-16 : 04:48:12
cant you use automatic updates to get your patches up to date ?
Go to Top of Page
    Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site