Viewing 15 posts - 76 through 90 (of 3,738 total)
Lowell (12/6/2016)
The server response was: 4.3.2 Service not available,
which would be an SMTP service exists, but is not available.
so the issue is not database mail,...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 6, 2016 at 10:05 am
ZZartin (12/6/2016)
My guess would be that the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 6, 2016 at 10:03 am
J Livingston SQL (12/6/2016)
what script did you use......?
--work file
--USE msdb
--GO
--exec dbo.sysmail_start_sp
--exec dbo.sysmail_stop_sp
--use master
--go
-- exec sp_configure 'show advanced options', 1
-- reconfigure
-- exec sp_configure 'Database Mail XPs', 1
-- reconfigure
SELECT * FROM msdb.dbo.sysmail_profile...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 6, 2016 at 9:57 am
Chris Harshman (12/1/2016)
https://msdn.microsoft.com/en-us/library/ms190307.aspx
I prefer to use the @attach_query_result_as_file=1 option, because the results are often easier to read in the text file than in the body...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2016 at 1:24 pm
Thom A (12/1/2016)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2016 at 11:32 am
Thank you for your help.
What was I thinking.
I do need to read from a query and send the results as an e-mail attachment or in the body of the message.
My...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2016 at 10:27 am
Thom A (12/1/2016)
Welsh Corgi (12/1/2016)
Thom A (12/1/2016)
Welsh Corgi (12/1/2016)
I just ask for guidance.I think that it is pretty clear what I want.
All you've asked is "How do you get all...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2016 at 10:21 am
Thom A (12/1/2016)
Welsh Corgi (12/1/2016)
Thom A (12/1/2016)
Welsh Corgi (12/1/2016)
I just ask for guidance.I think that it is pretty clear what I want.
All you've asked is "How do you get all...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2016 at 10:16 am
Thom A (12/1/2016)
Welsh Corgi (12/1/2016)
I just ask for guidance.I think that it is pretty clear what I want.
All you've asked is "How do you get all the rows from a...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2016 at 10:10 am
DamianC (12/1/2016)
Create an sp that performs your select.
Use the sp as the source using with result sets followed by all the columns you require along with their...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2016 at 10:08 am
Thom A (12/1/2016)
Welsh Corgi (12/1/2016)
I just ask for guidance.I think that it is pretty clear what I want.
All you've asked is "How do you get all the rows from a...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2016 at 10:06 am
Thom A (12/1/2016)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2016 at 9:45 am
I just ask for guidance.
I think that it is pretty clear what I want.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2016 at 9:37 am
Luis Cazares (12/1/2016)
Welsh Corgi (12/1/2016)
The following article is great but it does it drops off on returning full record set.
https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-execute-sql-task-to-generate-result-sets
I need to get the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2016 at 9:28 am
ok, I'm sorry for not being clear.
The following article is great but it does it drops off on returning full record set.
https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-execute-sql-task-to-generate-result-sets
I need to get the result set into a...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2016 at 9:05 am
Viewing 15 posts - 76 through 90 (of 3,738 total)