Hi,

In 2000 xp_eventlog is used to write to application log.

In 2000 xp_eventlog has following parameters:

ERROR#,Message,Severity

where ERROR# must be user defined, Message = any str, severity: WARNING, INFORMATIONAL or ERROR

I've been...

Hi all,

thanks for the replies.

It's not that I need a maintenance window. I want to check the status of the db's 24hrs/7days. When at night a db is not 'open...

Antares,

I can't find any more info, I'm afraid.

With Kind Regards/Met vriendelijke groet

Schil

'It's never ending and never surrendering' Unida 1999

Some more 'news'.

When I run the exe msmdsrv.exe via the Run I get an error in the event log stating: Server

With Kind Regards/Met vriendelijke groet

Schil

'It's never ending and never surrendering'...

As I'm on NT I can't follow the suggested path, but via the registry I found out that the exe is msmdsrv.

The version tab is there. I can't...

Antares,

I already reinstalled three times. And every times the install itself seems to run ok.

Thanks for your fast answer!

With Kind Regards/Met vriendelijke groet

Schil

'It's never ending and never surrendering' Unida 1999

Thanks Brian.

With Kind Regards/Met vriendelijke groet

Schil

'It's never ending and never surrendering' Unida 1999

Paul,

what version of SqlServer and SP are you on?

For SqlSrv2000 you'll need Sp1 or 2.

With Kind Regards/Met vriendelijke groet

Schil

'It's never ending and never surrendering' Unida 1999

Hiya,

Both SqlServer and SqlAgent run under the same NT account.

Does this account actually need Admin rights? I rather not use an admin for running SqlServer and SqlAgent (some extended xp...

Nope I'm not using SMTP. And for SqlAgentMail all works fine. But for SqlMail I'm having troubles with specifying the correct mail mapi. If I do a test I...

Hi all,

Thanks for all your replies.

Alas I use eval software so installing/de-installing Sp's will not work.

But I noticied something elese. I use Notes for emailing alerts to my email account....

Well, I duplicate dthe error:

via service manager I stopped the agent.

Checked ctrl panel: service does not run

Checked task manager: sqlagent.exe no longer exists.

So it is truely stopped.

Then via servic emanager:...

Antares,

Problem is solved by shutting down and starting up the machine.

There are no more servers in this Em to compare.

Services panel showed started. SqlServerError log contains nothing relevant.

SqlAgent log...

Antares,

After the previous actions I tried to change something in an alert and got error 14258: 'Cannot perform this operation while SQLServerAgent is starting'.

Anatares,

Refreshing did not help.

Stopping via Services ctrl panel and then start via EM, didn't work either: I do right click on Sql Server Agent -> start. No messages. In...