Friday, March 23, 2012
how to use sqlmail
while with no success so I have to ask:
On a machine running win2k server and sql2k, what is required to make
SQLmail work?
Is an example procedure available?
Does it use the desktop owners email client or can it use the servers
IIS SMTP?Some links to how-to and troubleshooting articles, as well as alternatives:
http://www.aspfaq.com/2403
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"mmac" <no@.thank.you> wrote in message
news:#LX20Ix3DHA.2544@.TK2MSFTNGP10.phx.gbl...
> This may seem like stupid question but I have been plinking at this for a
> while with no success so I have to ask:
> On a machine running win2k server and sql2k, what is required to make
> SQLmail work?
> Is an example procedure available?
> Does it use the desktop owners email client or can it use the servers
> IIS SMTP?
>
>|||I browsed a bunch of the links you sent (thank you BTW) and it appears
that there isn't a way to use the smtp server built into IIS. All examples
use an email client. to send mail. I would prefer to use iis for this at
this moment. Alas...
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:Ou5J8Mx3DHA.560@.TK2MSFTNGP11.phx.gbl...
> Some links to how-to and troubleshooting articles, as well as
alternatives:
> http://www.aspfaq.com/2403
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "mmac" <no@.thank.you> wrote in message
> news:#LX20Ix3DHA.2544@.TK2MSFTNGP10.phx.gbl...
> > This may seem like stupid question but I have been plinking at this for
a
> > while with no success so I have to ask:
> > On a machine running win2k server and sql2k, what is required to
make
> > SQLmail work?
> > Is an example procedure available?
> > Does it use the desktop owners email client or can it use the
servers
> > IIS SMTP?
> >
> >
> >
> >
>|||You can use any SMTP server with the CDO and, more appropriately, the
xp_smtp_sendmail procedure referenced in the same article.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"mmac" <no@.thank.you> wrote in message
news:ew8Tzox3DHA.1052@.TK2MSFTNGP12.phx.gbl...
> I browsed a bunch of the links you sent (thank you BTW) and it appears
> that there isn't a way to use the smtp server built into IIS. All
examples
> use an email client. to send mail. I would prefer to use iis for this at
> this moment. Alas...
>
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:Ou5J8Mx3DHA.560@.TK2MSFTNGP11.phx.gbl...
> > Some links to how-to and troubleshooting articles, as well as
> alternatives:
> > http://www.aspfaq.com/2403
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
> >
> >
> > "mmac" <no@.thank.you> wrote in message
> > news:#LX20Ix3DHA.2544@.TK2MSFTNGP10.phx.gbl...
> > > This may seem like stupid question but I have been plinking at this
for
> a
> > > while with no success so I have to ask:
> > > On a machine running win2k server and sql2k, what is required to
> make
> > > SQLmail work?
> > > Is an example procedure available?
> > > Does it use the desktop owners email client or can it use the
> servers
> > > IIS SMTP?
> > >
> > >
> > >
> > >
> >
> >
>|||I guess I mis-browsed. It looked like it had to connect through a client
instead of simple drop . I'll look at it again. Thanks
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:OK4TItx3DHA.1936@.TK2MSFTNGP12.phx.gbl...
> You can use any SMTP server with the CDO and, more appropriately, the
> xp_smtp_sendmail procedure referenced in the same article.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "mmac" <no@.thank.you> wrote in message
> news:ew8Tzox3DHA.1052@.TK2MSFTNGP12.phx.gbl...
> > I browsed a bunch of the links you sent (thank you BTW) and it
appears
> > that there isn't a way to use the smtp server built into IIS. All
> examples
> > use an email client. to send mail. I would prefer to use iis for this
at
> > this moment. Alas...
> >
> >
> > "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> > news:Ou5J8Mx3DHA.560@.TK2MSFTNGP11.phx.gbl...
> > > Some links to how-to and troubleshooting articles, as well as
> > alternatives:
> > > http://www.aspfaq.com/2403
> > >
> > > --
> > > Aaron Bertrand
> > > SQL Server MVP
> > > http://www.aspfaq.com/
> > >
> > >
> > >
> > >
> > > "mmac" <no@.thank.you> wrote in message
> > > news:#LX20Ix3DHA.2544@.TK2MSFTNGP10.phx.gbl...
> > > > This may seem like stupid question but I have been plinking at this
> for
> > a
> > > > while with no success so I have to ask:
> > > > On a machine running win2k server and sql2k, what is required to
> > make
> > > > SQLmail work?
> > > > Is an example procedure available?
> > > > Does it use the desktop owners email client or can it use the
> > servers
> > > > IIS SMTP?
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
how to use sqlmail
while with no success so I have to ask:
On a machine running win2k server and sql2k, what is required to make
SQLmail work?
Is an example procedure available?
Does it use the desktop owners email client or can it use the servers
IIS SMTP?Some links to how-to and troubleshooting articles, as well as alternatives:
http://www.aspfaq.com/2403
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"mmac" <no@.thank.you> wrote in message
news:#LX20Ix3DHA.2544@.TK2MSFTNGP10.phx.gbl...
quote:|||I browsed a bunch of the links you sent (thank you BTW) and it appears
> This may seem like stupid question but I have been plinking at this for a
> while with no success so I have to ask:
> On a machine running win2k server and sql2k, what is required to make
> SQLmail work?
> Is an example procedure available?
> Does it use the desktop owners email client or can it use the servers
> IIS SMTP?
>
>
that there isn't a way to use the smtp server built into IIS. All examples
use an email client. to send mail. I would prefer to use iis for this at
this moment. Alas...
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:Ou5J8Mx3DHA.560@.TK2MSFTNGP11.phx.gbl...
quote:
> Some links to how-to and troubleshooting articles, as well as
alternatives:
quote:|||You can use any SMTP server with the CDO and, more appropriately, the
> http://www.aspfaq.com/2403
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "mmac" <no@.thank.you> wrote in message
> news:#LX20Ix3DHA.2544@.TK2MSFTNGP10.phx.gbl...
a[QUOTE]
make[QUOTE]
servers[QUOTE]
>
xp_smtp_sendmail procedure referenced in the same article.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"mmac" <no@.thank.you> wrote in message
news:ew8Tzox3DHA.1052@.TK2MSFTNGP12.phx.gbl...
quote:
> I browsed a bunch of the links you sent (thank you BTW) and it appears
> that there isn't a way to use the smtp server built into IIS. All
examples
quote:|||I guess I mis-browsed. It looked like it had to connect through a client
> use an email client. to send mail. I would prefer to use iis for this at
> this moment. Alas...
>
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:Ou5J8Mx3DHA.560@.TK2MSFTNGP11.phx.gbl...
> alternatives:
for[QUOTE]
> a
> make
> servers
>
instead of simple drop . I'll look at it again. Thanks
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:OK4TItx3DHA.1936@.TK2MSFTNGP12.phx.gbl...
quote:
> You can use any SMTP server with the CDO and, more appropriately, the
> xp_smtp_sendmail procedure referenced in the same article.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "mmac" <no@.thank.you> wrote in message
> news:ew8Tzox3DHA.1052@.TK2MSFTNGP12.phx.gbl...
appears[QUOTE]
> examples
at[QUOTE]
> for
>
how to use sqliostress.exe on remote server?
Hi,
Can anybody help me with the command to use sqliostress.exe on a remote machine.
I have,
SQLIOStress /Fc:\temp\Stress.mdf /Lc:\temp\Stress.ldf /N /S3072 /I32
but how do I mention the remote server to test this utility.
Regards,
zia
I don't think this is an option.
Why can't you run it on the server locally?
|||I am trying to calculate the IO operations and stress on the NIC card. Therefore I have to run it on remote server.
thanks.
Sunday, February 19, 2012
How to use 32-bit ODBC driver (sybase) at an ETL application running (deployed into SQL Server)
I am developing an ETL system on a 32-bit machine let's say, called 'dwdev'. The application connects to a Sybase database as a source system using ODBC connection. I am able to run this application directly from Visual studio 2005 and i am able to deploy it into SQL Server 2005 and run it from Server as a job. Both work. At this server i am connecting to a SQL Server instance called 'dwdev'.
When i transfer my application onto a 64-bit machine, let's say called 'dwtest', i am able to run my application from Visual Studio 2005 properly and it works, but when i deploy it into SQL Server (instance is called 'dwtest') and try to run it as a job just like the development machine, it gives an error and stops executing.
I was facing 'data source' type of error when i was first trying it from Visual Studio, but i solved this problem by setting Run64bitRunTime settings to FALSE on the Project's properties Debugging Page, at 64-bit machine. now it uses 32-bit runtime then 32-bit Sybase ODBC driver. But i cannot force the application to use 32 bit runtime when i am executing it from SQL Server as a job.
How can i do that? is there an alternative method?
Thanks for your help...
The solution in this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=603814&SiteID=1
worked for me(Thanks to Michael Entin) when i execute my application on SQL Server as a Job (SQL Server Agent) calling command line dtexec utility. I defined my job step as TYPE: Operation System (CmdExec) , RUN AS: SQL Agent Service Account
I used the follwing string as my command:
C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe /sq EXECUTE_ALL_S0_JOBS_FROM_SQL_SERVER_MASTER /ser dwtest
but i still wonder whether there is a solution for defining job step as a SQL Server Integration Services Package and executing the package EXECUTE_ALL_S0_JOBS_FROM_SQL_SERVER_MASTER in a 32-bit mode under SQL Server Agent?
Thanks
how to use .mdf/ldf file in network
Hi,
I have installed SQL server 2005 in my machine. Now when we restore the database, I have check the size of database file .mdf/.ldf is very large. So now I wants to place these two files in any other machine in network.
But when I try to do the same, I am getting "Error 5110: network device not supported for database files.".
Please anyone guide me about the process. So that I can place these 2 files in another machine in network or any sharepoint.
Thanks
Regards,
Nipun
The ability to run databases off network drives is not supported by Microsoft. However, it is possible by setting trace flag 1807. Read all about it in the following KB article:
http://support.microsoft.com/kb/304261
HTH!
|||To keep a long answer short, this is not suggested as network shares are (evil) unreliable as long as they are not build for storing and doing reliable processing (like NAS).
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||As Jens indicated, it is generally NOT a good idea to put the data files on a network share.
(Using a SAN or NAS is quite different and approved.)