Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««34567»»»

How to use Database mail feature in SQL Server 2000 Expand / Collapse
Author
Message
Posted Thursday, April 1, 2010 11:47 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, February 11, 2011 8:31 PM
Points: 297, Visits: 277
Any suggestion on this will be highly appreciated.......
Post #895460
Posted Friday, April 2, 2010 1:46 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:11 AM
Points: 230, Visits: 505
If you want to send query result using link server approach , you need to create two way link server and provide access to databases in sql 2000 to the user in sql server 2005

Post #895481
Posted Saturday, April 3, 2010 12:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, February 11, 2011 8:31 PM
Points: 297, Visits: 277
Only one Linkserver need to be created .....
Post #896150
Posted Saturday, April 3, 2010 4:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:11 AM
Points: 230, Visits: 505
Since the query is referring to the database in SQL Seerver 2000, when I creaetd the query to call sp_db_mail in SQL 2005 through link server , It came out with databse objet not found

After creating two way link servr it worked.

Provide me how to create a query out put from SQL Server 2000 in dbmail using the specified approach

Post #896198
Posted Saturday, April 3, 2010 11:39 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, February 11, 2011 8:31 PM
Points: 297, Visits: 277
srinivas please go for this blog which might clear ur doubts.....

http://databasemail.blogspot.com
Post #896356
Posted Wednesday, April 14, 2010 2:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 22, 2012 6:44 AM
Points: 18, Visits: 71
HI, I got a error using this way:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.

But the mail was sent by sql server. How to fix the error message


C.G
Post #902919
Posted Thursday, April 15, 2010 3:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, February 11, 2011 8:31 PM
Points: 297, Visits: 277
Colin please let us know which method u r using Mohammed or saby
Post #903858
Posted Friday, October 14, 2011 2:04 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, August 16, 2014 12:36 PM
Points: 31, Visits: 378
Thank you Moin Sir I read this article today.Just awesome.!!!!
--Boj
Post #1190775
Posted Thursday, November 3, 2011 11:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 15, 2011 2:01 PM
Points: 8, Visits: 51
Does this only run if the job fails? Can you make this run when jobs also complete? On our 2005 machines
we have all jobs will email on failure except the user databases we have email upon completion.

I am also not sure about this,

exec SQL_Server_2005.msdb.dbo.sp_send_dbmail
@profile_name = 'SampleSQLServer2005dbmailProfile',
@recipients='yourname@email.com',
--@copy_recipients = 'yourgroup@email.com',
@subject='Job test_db_mail failed on SQL Server 2000 server',
@importance='HIGH',
@body ='Job test_db_mail failed on SQL Server 2000 server'
--------------------------------------------------------------

Profile name is the name of the account with no @companyemail.com at the end.

Is that also reentered in the @recipients only with the @companyemail.com at the end?

I am assuming that we don't have to use copy_recipients if we don't want, that is optional?

Any help is appreciated.
Post #1200077
Posted Friday, November 4, 2011 6:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 8, 2014 6:15 PM
Points: 2,278, Visits: 3,793
danskisanjar (11/3/2011)
Does this only run if the job fails? Can you make this run when jobs also complete? On our 2005 machines we have all jobs will email on failure except the user databases we have email upon completion.


This is just an example. It shouldn't matter if job fails or not.\

I am also not sure about this,

exec SQL_Server_2005.msdb.dbo.sp_send_dbmail
@profile_name = 'SampleSQLServer2005dbmailProfile',
@recipients='yourname@email.com',
--@copy_recipients = 'yourgroup@email.com',
@subject='Job test_db_mail failed on SQL Server 2000 server',
@importance='HIGH',
@body ='Job test_db_mail failed on SQL Server 2000 server'
--------------------------------------------------------------

Profile name is the name of the account with no @companyemail.com at the end.


Profile name is the database profile you configured in SQL Server 2005

Is that also reentered in the @recipients only with the @companyemail.com at the end?

No, @recipients is your email address

I am assuming that we don't have to use copy_recipients if we don't want, that is optional?

Yes, it is optional



Mohammed Moinudheen
Post #1200527
« Prev Topic | Next Topic »

Add to briefcase «««34567»»»

Permissions Expand / Collapse