Viewing 15 posts - 1,591 through 1,605 (of 3,738 total)
SQLDBA360 (4/2/2012)
here you go http://www.microsoft.com/download/en/details.aspx?id=16978
When you download it downloads the following text file:
SQL Server 2008 R2 Feature Pack Instructions.txt
The file contains the following:
SQL Server 2008 R2 Feature Pack Instructions
The links...
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/
April 2, 2012 at 9:50 am
I could not get Database Mail to work on a Server so I tried CDONTS.
I used the following code:
DECLARE @From varchar(100)
DECLARE @To varchar(100)
DECLARE @Subject varchar(100)
DECLARE @Body varchar(4000)
DECLARE @cc varchar(100)
DECLARE...
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/
April 2, 2012 at 9:15 am
anthony.green (4/2/2012)
only other thing I can think of now is permissions to the procedureswhat level of access is the user which is running the mail task?
sysadmin.
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/
April 2, 2012 at 9:11 am
I sent email via telnet using port 25.
If it was an AV Issues then it should block an email sent via telnet.
I don't know what else to test or check...
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/
April 2, 2012 at 8:59 am
anthony.green (4/2/2012)
also is that email address right in the snippet or was it modified?
is there anything in the database mail log?
av blocking...
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/
April 2, 2012 at 8:18 am
I just turned it on but no e-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/
April 2, 2012 at 7:59 am
Too bad April Fool's did not fall on a work day for most of us.:hehe:
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/
April 2, 2012 at 7:32 am
Jeff Moden (4/1/2012)
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/
April 1, 2012 at 9:03 am
Jeff Moden (4/1/2012)
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/
April 1, 2012 at 8:07 am
Jeff Moden (4/1/2012)
Welsh Corgi (3/31/2012)
Load times are slow because we have to deal with linked servers (which only have PK's).
If that's the case, wouldn't it be better if they exported...
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/
April 1, 2012 at 8:02 am
PaulB-TheOneAndOnly (3/31/2012)
Welsh Corgi (3/31/2012)IMHO it would be better to purge the records loaded via the incremental load as opposed to having a script doing a compare.
Agreed.
It is usual for...
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 31, 2012 at 3:17 pm
When I asked about not having a dateTime Stamp to distingish when the data was loaded after packaging the incremental loads into a SSIS Package so that if one step...
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 31, 2012 at 2:22 pm
PaulB-TheOneAndOnly (3/31/2012)
Welsh Corgi (3/30/2012)
Any ideas would be greatly appreciated.
It all depends on the design and how the architect decided to track changes - I have seen cases where the DWH...
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 31, 2012 at 2:09 pm
Jeff Moden (3/31/2012)
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 31, 2012 at 1:56 pm
The following link contains code for sp_who_3 up from Version 7 to SQL Server 2005:
http://www.tek-tips.com/faqs.cfm?fid=6561
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 31, 2012 at 11:40 am
Viewing 15 posts - 1,591 through 1,605 (of 3,738 total)