Hi,
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
Ana
Read about sp_send_dbmail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test mail without a problem. I
> also managed to create a job which would execute a query. I'd like now the sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-6164310-2.html#Listing%20B
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
Showing posts with label ent. Show all posts
Showing posts with label ent. Show all posts
Monday, March 26, 2012
Emailing results from query
Hi,
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
AnaRead about sp_send_dbmail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test m
ail without a problem. I
> also managed to create a job which would execute a query. I'd like now the
sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-61...tml#Listing%20B
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
AnaRead about sp_send_dbmail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test m
ail without a problem. I
> also managed to create a job which would execute a query. I'd like now the
sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-61...tml#Listing%20B
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
Emailing results from query
Hi,
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
AnaRead about sp_send_dbmail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test mail without a problem. I
> also managed to create a job which would execute a query. I'd like now the sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-6164310-2.html#Listing%20B
--
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
AnaRead about sp_send_dbmail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test mail without a problem. I
> also managed to create a job which would execute a query. I'd like now the sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-6164310-2.html#Listing%20B
--
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
Friday, March 9, 2012
EM vs QA login
This morning I have a (2000) server that continually
times out when I try to connect via Ent. Manager. It is
registred through an sa Sql Server login that has not
changed in months. Also, I upped the login timeout in EM
to 10 seconds and it still timed out.
The odd thin is this: I can connect instantly through
Query Analyzer through this same sa login and the server
looks very quiet in Perf Mon.
Is there something different about how Sql Server logins
through Enterprise Manager? Any ideas what would cause
this?
The login process should be the same. Though, EM will try to execute a bunch
of queries after a successful login to get server/database properties.
Try up the timeout to at least 60 seconds.
-oj
"Stsh" <anonymous@.discussions.microsoft.com> wrote in message
news:057301c53ebe$672f0410$a501280a@.phx.gbl...
> This morning I have a (2000) server that continually
> times out when I try to connect via Ent. Manager. It is
> registred through an sa Sql Server login that has not
> changed in months. Also, I upped the login timeout in EM
> to 10 seconds and it still timed out.
> The odd thin is this: I can connect instantly through
> Query Analyzer through this same sa login and the server
> looks very quiet in Perf Mon.
> Is there something different about how Sql Server logins
> through Enterprise Manager? Any ideas what would cause
> this?
times out when I try to connect via Ent. Manager. It is
registred through an sa Sql Server login that has not
changed in months. Also, I upped the login timeout in EM
to 10 seconds and it still timed out.
The odd thin is this: I can connect instantly through
Query Analyzer through this same sa login and the server
looks very quiet in Perf Mon.
Is there something different about how Sql Server logins
through Enterprise Manager? Any ideas what would cause
this?
The login process should be the same. Though, EM will try to execute a bunch
of queries after a successful login to get server/database properties.
Try up the timeout to at least 60 seconds.
-oj
"Stsh" <anonymous@.discussions.microsoft.com> wrote in message
news:057301c53ebe$672f0410$a501280a@.phx.gbl...
> This morning I have a (2000) server that continually
> times out when I try to connect via Ent. Manager. It is
> registred through an sa Sql Server login that has not
> changed in months. Also, I upped the login timeout in EM
> to 10 seconds and it still timed out.
> The odd thin is this: I can connect instantly through
> Query Analyzer through this same sa login and the server
> looks very quiet in Perf Mon.
> Is there something different about how Sql Server logins
> through Enterprise Manager? Any ideas what would cause
> this?
EM vs QA login
This morning I have a (2000) server that continually
times out when I try to connect via Ent. Manager. It is
registred through an sa Sql Server login that has not
changed in months. Also, I upped the login timeout in EM
to 10 seconds and it still timed out.
The odd thin is this: I can connect instantly through
Query Analyzer through this same sa login and the server
looks very quiet in Perf Mon.
Is there something different about how Sql Server logins
through Enterprise Manager? Any ideas what would cause
this?The login process should be the same. Though, EM will try to execute a bunch
of queries after a successful login to get server/database properties.
Try up the timeout to at least 60 seconds.
--
-oj
"Stsh" <anonymous@.discussions.microsoft.com> wrote in message
news:057301c53ebe$672f0410$a501280a@.phx.gbl...
> This morning I have a (2000) server that continually
> times out when I try to connect via Ent. Manager. It is
> registred through an sa Sql Server login that has not
> changed in months. Also, I upped the login timeout in EM
> to 10 seconds and it still timed out.
> The odd thin is this: I can connect instantly through
> Query Analyzer through this same sa login and the server
> looks very quiet in Perf Mon.
> Is there something different about how Sql Server logins
> through Enterprise Manager? Any ideas what would cause
> this?
times out when I try to connect via Ent. Manager. It is
registred through an sa Sql Server login that has not
changed in months. Also, I upped the login timeout in EM
to 10 seconds and it still timed out.
The odd thin is this: I can connect instantly through
Query Analyzer through this same sa login and the server
looks very quiet in Perf Mon.
Is there something different about how Sql Server logins
through Enterprise Manager? Any ideas what would cause
this?The login process should be the same. Though, EM will try to execute a bunch
of queries after a successful login to get server/database properties.
Try up the timeout to at least 60 seconds.
--
-oj
"Stsh" <anonymous@.discussions.microsoft.com> wrote in message
news:057301c53ebe$672f0410$a501280a@.phx.gbl...
> This morning I have a (2000) server that continually
> times out when I try to connect via Ent. Manager. It is
> registred through an sa Sql Server login that has not
> changed in months. Also, I upped the login timeout in EM
> to 10 seconds and it still timed out.
> The odd thin is this: I can connect instantly through
> Query Analyzer through this same sa login and the server
> looks very quiet in Perf Mon.
> Is there something different about how Sql Server logins
> through Enterprise Manager? Any ideas what would cause
> this?
EM vs QA login
This morning I have a (2000) server that continually
times out when I try to connect via Ent. Manager. It is
registred through an sa Sql Server login that has not
changed in months. Also, I upped the login timeout in EM
to 10 seconds and it still timed out.
The odd thin is this: I can connect instantly through
Query Analyzer through this same sa login and the server
looks very quiet in Perf Mon.
Is there something different about how Sql Server logins
through Enterprise Manager? Any ideas what would cause
this?The login process should be the same. Though, EM will try to execute a bunch
of queries after a successful login to get server/database properties.
Try up the timeout to at least 60 seconds.
-oj
"Stsh" <anonymous@.discussions.microsoft.com> wrote in message
news:057301c53ebe$672f0410$a501280a@.phx.gbl...
> This morning I have a (2000) server that continually
> times out when I try to connect via Ent. Manager. It is
> registred through an sa Sql Server login that has not
> changed in months. Also, I upped the login timeout in EM
> to 10 seconds and it still timed out.
> The odd thin is this: I can connect instantly through
> Query Analyzer through this same sa login and the server
> looks very quiet in Perf Mon.
> Is there something different about how Sql Server logins
> through Enterprise Manager? Any ideas what would cause
> this?
times out when I try to connect via Ent. Manager. It is
registred through an sa Sql Server login that has not
changed in months. Also, I upped the login timeout in EM
to 10 seconds and it still timed out.
The odd thin is this: I can connect instantly through
Query Analyzer through this same sa login and the server
looks very quiet in Perf Mon.
Is there something different about how Sql Server logins
through Enterprise Manager? Any ideas what would cause
this?The login process should be the same. Though, EM will try to execute a bunch
of queries after a successful login to get server/database properties.
Try up the timeout to at least 60 seconds.
-oj
"Stsh" <anonymous@.discussions.microsoft.com> wrote in message
news:057301c53ebe$672f0410$a501280a@.phx.gbl...
> This morning I have a (2000) server that continually
> times out when I try to connect via Ent. Manager. It is
> registred through an sa Sql Server login that has not
> changed in months. Also, I upped the login timeout in EM
> to 10 seconds and it still timed out.
> The odd thin is this: I can connect instantly through
> Query Analyzer through this same sa login and the server
> looks very quiet in Perf Mon.
> Is there something different about how Sql Server logins
> through Enterprise Manager? Any ideas what would cause
> this?
Subscribe to:
Posts (Atom)