But there is a limit on the number of email addresses we can add in operator. Is there any way we could increase the character length that it would accept....

Thank you all for the details. 🙂

You are right. I contacted the IT administrator, and he was able to give me the right SMTP server.

That worked.

Thanks for the help.

It is an email list like "sqldba@company.com" that actually consists of multiple emails.

Do you think the SMTP server might be the reason for this error.

It is just not...

Yes I did. The alerts are working fine only for individual ids

But I surprised it doesn't work for group email.

Just to make it clear, my query is this

-> I want to run this query on a database instance. This should run for all the user databases on the instance...

I found this script to be useful for sql server 2005 as well.

We do have DMV's for this purpose in 2005. But still nice to have this script.

Well, if we...

Oh. Thank you. I didn't know I will get an answer so quickly.

Thank you very much.

Our access is restricted. And also, SQL server 2000 is also configured.

This is Sql 2000 replication issue.

Actually the distribution,publisher,subscriber are all on the same server.

Getting the same error message.

The process could not connect to distributor 'server name'

The process could not connect...

I was testing both the scenarios.

Thanks for the response. I will dig in more to see if I am missing anything.

Scenario 1

This is the message on the error log continously related to the restore job.

The log shipping secondary database server\instance.dbname has restore threshold of 45 minutes and is out of...

Master db:

Records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings. Also, master is...

You are trying to copy the files over the network across servers.

I guess, we need to have the drives mapped accordingly otherwise it wouldn't be useful if we use...

You could use it on the same device provided you have a mechanism to backup those files onto tape drives. In my company, this is the process being following that...