Viewing 15 posts - 31 through 45 (of 46 total)
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...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
April 1, 2009 at 4:41 am
hi,
Try running the service with a domain account & make sure this domain account has sysadmin priveleges.
Have a nice day !!!
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
April 1, 2009 at 2:52 am
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 !!!
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
April 1, 2009 at 1:04 am
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 !!!
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
March 31, 2009 at 12:35 am
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...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
March 30, 2009 at 11:44 pm
Hi,
Check if the TCP/IP protocol has been enabled & also if the SQL services are started & running fine.
Thanks
Have a nice day !!!
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
March 30, 2009 at 10:12 pm
Thanks. But i need to run it on on-going basis. Will this not cause an overhead on performance if I run daily?
Thanks
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
February 27, 2009 at 12:43 am
Are you refering to Perfmon? If not then please provide me the details on server side trace.
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
February 26, 2009 at 3:56 am
I haven't received any reply yet. Can someone help me out urgently?
Thanks.
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
February 25, 2009 at 8:56 pm
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...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
February 1, 2009 at 11:02 pm
Hi,
I have resolved it myself... 🙂
Thanks
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
October 28, 2008 at 4:38 am
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...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
October 15, 2008 at 9:08 pm
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 &...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
October 15, 2008 at 5:23 am
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...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
October 15, 2008 at 5:12 am
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...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
October 14, 2008 at 4:40 am
Viewing 15 posts - 31 through 45 (of 46 total)