Viewing 15 posts - 1,501 through 1,515 (of 1,535 total)
I would do so with both. Depending on how the sqlmail is going to be used.
If you are just going to use sqlmail in sp's etc then just set up...
March 1, 2004 at 8:16 am
That's a toughie.
I don't know the best answer for this, what you would probably be best doing is to run performance monitors against the server and db with it in...
March 1, 2004 at 8:08 am
Sounds like an exchange issue.
Have you tried to send emails using outlook to external email addresses from that server? Exchange might have relaying turned off to anything outside the local...
February 27, 2004 at 7:07 am
Absolutely a select statement may cause blocking and locking if you are reading committed, this mainly happens when you are attempting to do a large select. The worst is when...
February 27, 2004 at 6:52 am
Login using the SQL Server Agent account, and map a drive to the location (being sure to set the checkbox for Reconnect At Logon).
February 27, 2004 at 6:46 am
BOL = Microsoft Books Online...essentially what you get when you hit the F1 key when in Query Analyser or Enterprise Manager. A most excellent and highly used piece of documentation,...
February 27, 2004 at 6:40 am
That's what I figured, thanks for the confirmation.
February 27, 2004 at 6:08 am
The hardware is made up of a SAN, running RAID 7 with 3 LUNS and 3 logical drives. There is also a local internal raid array configured to RAID 10....
February 27, 2004 at 5:24 am
Another way to do it, instead of leaving the data in an .ini file is to put it into the registry. You can then use regread functionality to pull the...
February 26, 2004 at 8:00 am
Did you set up the profile in outlook(when logged in as the SQL service account), ensure it's the default profile and that outlook is the default mail client?
February 25, 2004 at 7:11 am
I'm not sure if it's a bug, or has been designed that way, but it does not work.
We spent a good 3 weeks attempting to get it to work at...
February 25, 2004 at 7:09 am
Check the scale and precision for both sides.
February 23, 2004 at 11:42 am
Have you checked the data type on the Oracle side matches the data type on the SQL Server side. You might have to either change the column data type or...
February 23, 2004 at 10:32 am
In a job step select "Operating System (cmdexec)"
In the step information use
DTSRUN /S<servername> /N"<job name>" /E
<servername> is the name of the server, <job name> is the name of the job,...
February 19, 2004 at 7:29 am
I would never call the dts by the guid you might pull the wrong version should you change the DTS in any fashion.
February 19, 2004 at 6:59 am
Viewing 15 posts - 1,501 through 1,515 (of 1,535 total)