Viewing 15 posts - 1,741 through 1,755 (of 3,738 total)
I try killing the exe for DB Mail.
I Did stop & start DB Mail.
I guess that I could probably stop & restart the service via Services.
Thanks for the feedback.
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/
March 11, 2012 at 9:50 am
Goggle? What's that.:-)
Try Goggle Ignite.
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/
March 10, 2012 at 9:51 am
David, I think your right about Ignite.
It makes it a lot easier to get the information and get it fast as well as examine what has been going on from...
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/
March 10, 2012 at 9:39 am
ah. I will have to try that.
I ran sp's, search the DB Mails Tables in MSDB and basically went through the entire troubleshooting process so I would not double that...
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/
March 10, 2012 at 9:36 am
I had suggested SSIS and to stay away from Linked Server a week ago yesterday.
On Thursday, I temporary cut his permissions and created an SSIS Package.
The Linked Server Load did...
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/
March 10, 2012 at 9:32 am
I made sure that the Server was not restricted by the SMTP Server Relay.
I checked and the AV on that Server is the same as what is running on 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/
March 8, 2012 at 4:16 pm
Test did not work, checking into SMTP?
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/
March 8, 2012 at 10:03 am
No suggestions?:crying:
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/
March 7, 2012 at 10:11 am
Another consideration is that the AS400 is remote.
It would probably be faster to export the data from the AS400 to text and Load the text files into the AS400.
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/
March 7, 2012 at 7:47 am
I noticed that the the Primary Keys are created on the Tables before the load.
I noticed that there are 10 columns for the primary key on the Accounts payable Table.
Most...
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/
March 7, 2012 at 7:22 am
Indexes but no Primary Keys.
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/
March 6, 2012 at 5:31 am
Thanks for the information.
I did not mention that this data is from a legacy DB2 Database that is hosted outside of the company and soon to go away.
None of 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/
March 5, 2012 at 12:45 pm
Thanks!
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/
March 5, 2012 at 10:27 am
Rather than perform several SELECT DISTINCT to identify what combination of columns it takes to define the natural candidate composite primary key on over a hunded tables I would like...
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/
March 5, 2012 at 9:50 am
Sean,
Each table is duplicated in a different schema.
Unfortunately I do not see a way to include the schema as a column and include that in the sort.
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/
March 3, 2012 at 7:04 am
Viewing 15 posts - 1,741 through 1,755 (of 3,738 total)