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...
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...
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.
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...
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...
April 2, 2012 at 8:18 am
I just turned it on but no e-mail?
April 2, 2012 at 7:59 am
Too bad April Fool's did not fall on a work day for most of us.:hehe:
April 2, 2012 at 7:32 am
Jeff Moden (4/1/2012)
April 1, 2012 at 9:03 am
Jeff Moden (4/1/2012)
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...
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...
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...
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...
March 31, 2012 at 2:09 pm
Jeff Moden (3/31/2012)
March 31, 2012 at 1:56 pm
The following link contains code for sp_who_3 up from Version 7 to SQL Server 2005:
March 31, 2012 at 11:40 am
Viewing 15 posts - 1,591 through 1,605 (of 3,738 total)