sql mail

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

How do I configure SQL mail in SQL Server 2000?

As a database administrator, I like automation. When it comes to my backups, I like to automate as much as possible. SQL Mail gives me the ability to know when my backups are successful and when they fail. SQL Mail is a component of SQL Server that...

Tags: Microsoft Outlook, Microsoft SQL Server, Microsoft SQL Server 2000, Server, SQL, E-mail, SQL Mail, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Steven Warren

Blog posts 2008-05-21

Part IV: Configuring SQL Mail

We will finish off this series with showing you how to take advantage of the stored procedure xp_sendmail through T-SQL. Note: Select the link to read the entire blog series on SQL Mail.Configure xp_sendmailNow that you have configured SQL Mail, you can take advantage of the xp_sendmail stored procedure...

Tags: Programming languages, Databases, xp_Sendmail, SQL Mail, SQL

Blog posts 2006-07-20

Part II: Configuring SQL Mail

Configure the Outlook Client In Part I of configuring SQL Mail, we showed you how to create the proper profile in order to use SQL Mail. In this post, we will show you how to properly configure your Outlook client.In order to configure your Microsoft Outlook client, you first need...

Tags: Microsoft Outlook, Outlook Client, SQL, SQL Mail

Blog posts 2006-07-12

Part III: Configuring SQL Mail

Configure SQL Mail In order to configure SQL Mail, you must open the SQL Server Enterprise Manager from the Start menu, then explore your SQL Server and expand your Support Services folder, as shown in Figure A.Now right-click on Support Services and choose Properties. From the dropdown menu, choose the...

Tags: e-mail, Microsoft SQL Server, SQL, SQL Mail

Blog posts 2006-07-13

Part I: Configuring SQL Mail

As a database administrator, I like automation. When it comes to my backups, I like to automate as much as possible. SQL Mail gives me the ability to know when my backups are successful and when they fail. SQL Mail is a component of SQL Server that allows you to...

Tags: Microsoft SQL Server, MSSQLServer, server, SQL, SQL Mail, SQLServerAgent

Blog posts 2006-07-10

Automatically send mail in SQL Server with xp_SMTPSendMail80

Build your Microsoft SQL Server skills with TechRepublic's Fast Track: Microsoft SQL Server CD-ROM. Learn at your own pace, no matter your SQL skill level, utilizing 87 computer-based lessons to develop the knowledge needed to program, administer, back up, and optimize SQL Server 7.0 and 2000.When my company decided to...

Tags: Microsoft SQL Server, server, SQL, Joshua Hoskins, SQL Mail

Technical articles 2004-07-14

Set up SQL Mail to send SQL Server alerts

As a database administrator, I like automation. When it comes to my backups, I like to automate as much as possible. SQL Mail gives me the ability to know when my backups are successful and when they fail.SQL Mail is a component of SQL Server that allows you to send...

Tags: Mail, Microsoft SQL Server, server, SQL, SQL Mail, SQLServerAgent, Steven Warren MCSE, MCDBA

Technical articles 2003-11-04

Additional Resources

SQL Mail

Sir,We are trying send reports from sql server usingsql mail, but message was successfully send fullyafter that also messsage not send to destination email id.Message only send after opening outlook by stopping server sql agentPls provide me an solution for sending sql mail without opening outlook.Regardssathish kumar

Tags: Programming languages, Databases, SQL

Q&A 2005-05-04

SQL Mail

How to configure SQL mail to send messages without opening outlook.At present, we have configured sql mail but message is not delivered using sqlmail, message is only send after stopping sql server agent and opening outlook.Pls provide me an solutionregardssathish kumarGood Morning,You can really do it just with the new...

Tags: Programming languages, Databases, SQL

Q&A 2005-05-04

SQL Mail in SQL 2005 64bit server

i have job with the last step as "send email" but the job fails giving error message sql mail has not been enabled. when i was trying to enable through SQL Server surface area manager it gives message it does not support with SQL 64bit server. Someone please help me...

Tags: Programming languages, Databases, dal9798@..., SQL, server

Discussion threads 2007-11-24

SQL PathFinder for Oracle (msi)

SQL Pathfinder is for Oracle SQL programmers who live in an environment where multiple versions of SQL scripts and multiple SQL execution environments exist. Pathfinder determines the SQL path that SQL Plus will use, and traces and displays all of the script dependencies for your SQL script. The dependencies are...

Tags: Oracle Corp., SQL, SQL PathFinder, Pathfinder, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2006-11-21

SQL 2000 server/ODBC

Hello. I have installed SQL server 2000 personal edition on a desktop PC to establish a local SQL server for databases connecting via ODBC data source. When I attempt to SQL server verify authenticity of the databases login id, it tells me "connection failed"...SQL server error 11001...SQL...

Tags: hardware, Microsoft SQL Server, ODBC, rcelentano@..., server, SQL

Q&A 2005-04-26

Setting up Database Mail in SQL Server 2005

64 bit sql server 2005We are planning to go to 64 sql server2005. The following on-line manual reference says that database mail and SQL mail are only supported in a 32 bit environment."ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/81f3e917-884a-4cc8-aca2-0a5fea89f355.htm"Do you know if hardware is required that can run both 64 and 32 bit apps to have...

Tags: 64-bit, 64bit sql server database mail, database, feedback, jaschellenberg@..., Microsoft SQL Server, Microsoft SQL Server 2005, software, SQL

Discussion threads 2007-02-27

Firefly Query by Email (msi)

Firefly offers you the ability to query your databases just by sending an e-mail. Simply send an e-mail with a report name in the subject and get the results e-mailed back to you attached as an Excel spreadsheet. Advanced users can put a database name in the Subject and an...

Tags: SQL, E-mail, Databases, Online Communications, Enterprise Software, Software, Data Management

Software downloads 2007-03-18

Database mail in sql 2005, how to save profiles & account, smtp

hi,i have a sql 2005 with database mail configured, one profile with more than one accounts configureds inside, how can i save all that in a single script ?something like reverse engieneering for all my configs.regards,victor

Tags: Programming languages, Databases, Storage, victor.shahar@..., SQL, database, SMTP

Discussion threads 2007-10-23

How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000

This white paper details the steps involved in upgrading from SQL Server 6.5 and SQL Server 7.0 to SQL Server 2000. Microsoft SQL Server 2000 improves on the performance, reliability, scalability, quality, and ease of use of its predecessors, SQL Server 7.0 and SQL Server 6.5. SQL Server 2000 offers...

Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft SQL Server 6.5, Databases, Enterprise Software, Software, Data Management

White papers 2001-07-19

TechNet Webcast: Managing and Administering SQL Server 2005 (Level 200)

Microsoft SQL Server 2005 offers some new features for database administrators and Information Technology IT professionals. This webcast explains new administration tools, including SQL Management Studio; SQLCMD, the new command-line utility and its GUI equivalent in SQL Management Studio; and SQLiMail, the new Simple Mail Transfer Protocol SMTP-based replacement for...

Tags: Webcast, Microsoft SQL Server, SQL, Microsoft Corp., Microsoft SQL Server 2005, Microsoft TechNet, E-mail, Databases, Programming Languages, Digital Media, Enterprise Software, Online Communications, Software, Data Management, Software Development, Software/Web Development, Consumer Electronics, Personal Technology

Webcasts

Cache Monitor (zip)

Cache Monitor is the SQL development tool designed for InterSystems database Cache. It supports developers with features, like advanced SQL Query Editor with foreign key join suggestion, Cache-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting, Graphical SQL execution plan. Version 0.34 is...

Tags: Monitor, SQL, Cache Monitor, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-05-11

Sending E-mail with Database Mail in SQL Server 2005

gmail accountno problem with configuration and email sending but... have you tried with an gmail account???i can send email from another clients from the same mechine, but not with sql server.any help?:p

Tags: E-mail, Databases, oordaz@..., Microsoft SQL Server, Microsoft SQL Server 2005, database

Discussion threads 2007-09-17

What is the difference between Oracle, SQL and PL/SQL?

Recently, Sudhat read my Introductionto Basic SQL and had this to say:The article is very interesting. Too Good!And also please describe what is the difference between SQL and Oracle and PL/SQL.Sudhat, thanks for the comments. Ilove to hear feedback.And your question is a common one so Ithought I would...

Tags: Oracle Corp., PL/SQL, SQL

Blog posts 2006-05-30