And more refer this link: http://support.microsoft.com/kb/322140

I have checked all cause, everything is correct

I found one error in sql agent error like

[364] The Messenger service has not been...

Thanks steve Jones for reply..

I am using SQL server 2000 version and sp3.

I could not found any error in event logs regds sql agent services.

resolved issues, to change the database owner

thanks

Hi Jeff Moden Thanks for your reply ..

One of my client installed this software and configured database, this is totaly web based application, once installed this s/w still...

Jeff Moden Thanks for your reply ..

It is a good script. For find out unused spaces for all tables.

I could executed this script, but i am getting afried on my...

As a datacenter part, we want know who was last login the sq server 2005? and we need to execute the script once in a week. If you provide the...

thanks for your reply..

I could tried the query as follows

select b.name as DBName,a.login_time,a.last_batch,a.hostname,a.program_name,a.hostprocess,

a.nt_domain,a.nt_username,a.net_address,a.net_library,a.loginame

from sysprocesses a, sysdatabases b where a.dbid=b.dbid order by a.last_batch desc

It was written the Info from only...

Thanks for yours reply...

Windows authentication worked for me.

I added my domain user in sql server login, and then given sysadmin permission, so now i can able to access...

I resolved the issues with help of below URL

http://support.microsoft.com/kb/827422

Sql server agent could not running on under windows account, after delete or deny builtin\administrators from sql server 2000.

How to resolve this issues?

thanks

Thank you for reply.. Now i got clear idea about mail server.

I had created profile through control panel->

creatting email account as below.

1. User Info

user name - ananda

Email-address - ananda.murugesan@ril.com

2....

Thanks for your reply

It was woking fine through QA,

One more question?

How to create smtp mail account not in POP3? we are using only smtp.

I could tried but it was not...

Thanks for your reply

It was woking fine,

One more question?

How to create smtp mail account not in POP3? we are using only smtp.

I could tried but it was not hope.. the...

Have you check sql service account running either Local System account or user account?

Hi, Lempster thank you very much for your help....

This script CC copy was working fine.

Regards

Ananda.