Hi,

You can add a step to each of those transaction log jobs which get created from the logshipping wizard. In that step you can add the send mail details based...

hi,

Try running the service with a domain account & make sure this domain account has sysadmin priveleges.

Have a nice day !!!

hi,

After restoring the Dbs normally the user loses its logins/permissions when restored over a different DB. Please try executing the stored proc

use master

go

sp_change_users_login 'Auto_fix','loginname'

Have a nice day !!!

Hi,

Please specify on what aspect you would like to monitor the SQL servers. Is it the jobs, services, etc.

Thanks,

Have a nice day !!!

Hi ,

This is actually a bug in MS SQL Server 2000. When you run a four-part name query on a table in an Oracle data source, if the table name...

Hi,

Check if the TCP/IP protocol has been enabled & also if the SQL services are started & running fine.

Thanks

Have a nice day !!!

Thanks. But i need to run it on on-going basis. Will this not cause an overhead on performance if I run daily?

Thanks

Are you refering to Perfmon? If not then please provide me the details on server side trace.

I haven't received any reply yet. Can someone help me out urgently?

Thanks.

Hi,

You may go to the Job being created by that Maintenance plan and there go to the Job properties. Under 'General' Tab, you will find a field 'Owner'. Change it...

Hi,

I have resolved it myself... 🙂

Thanks

Hi,

You can create a txt or .sql file & include all the commands there. then you may refer to this file while using the SQLCMD ... I have used this...

Hi,

Since you are using DB mail to send mails, Db mail uses SMTP relay server for sending mails. Just check if you have access to SMTP relay mail server &...

Hi,

You need to provide the server name to your System Administrator and check if they have given access to SMTP server for your IP. If not then get the access...

Hi,

Database Mail makes use of SMTP mail server to send the mails. Make sure you have access to the SMTP mail server. Then you need to use this server name...