Viewing 15 posts - 976 through 990 (of 1,319 total)
Do you have the luxury of renaming the two new machines, and their IP address to the same as the originals? Thats what I've done in the past and had...
-- You can't be late until you show up.
August 7, 2008 at 8:49 am
Not in native SQl 2000 or SQL 7. See the prior posts for the solutions for these platforms. Also, if you have a solution, please state it. Simply writing "there...
-- You can't be late until you show up.
August 7, 2008 at 6:31 am
I think (and it's been awhile since I've used it and I don't have any samples here) you need to run the query, sending the results to a text file...
-- You can't be late until you show up.
August 5, 2008 at 2:43 pm
Actually it was under "more comprehensive example". Plus, you're supplied with the entire lsit of parms for the stored proc in the article. Sometimes the simplest solutions are the easiest...
-- You can't be late until you show up.
August 5, 2008 at 2:18 pm
I believe you're missing the smtp server specification -
@server = N'mail.mydomain.com'
-- You can't be late until you show up.
August 5, 2008 at 2:06 pm
If I remember correctly, you download it and create before you can use it. I'm also on S2KSP4 and I don't see it.
-- edit - Beaten by 2 seconds. 😛
-- You can't be late until you show up.
August 5, 2008 at 1:06 pm
Yes but with serveral hundreds jobs already in place, all using Outlook, I can't justify the time spent, although, reading what I just wrote, we could save a license fee...
-- You can't be late until you show up.
August 5, 2008 at 12:34 pm
Jack Corbett (8/5/2008)
-- You can't be late until you show up.
August 5, 2008 at 12:07 pm
Glad I could offer some assistance. Just a quick side note, my servers are all Windows 2003 and Outlook 2003.
edit - Also, at my last job we used SMTPMail. It...
-- You can't be late until you show up.
August 5, 2008 at 11:04 am
This is what I do within a SQL Agent Job Step, works every time.
DECLARE @query varchar(1000)
BEGIN
EXEC master.dbo.xp_sendmail @recipients='myname@mycompany.com',
@message='The attached text file contains a list of active employees.',
@query= 'select CompanyId as...
-- You can't be late until you show up.
August 5, 2008 at 8:53 am
Denby (8/1/2008)
-- You can't be late until you show up.
August 1, 2008 at 1:16 pm
California (7/24/2008)
My understanding is - what ever is allocated to SQL - it wont grab it until it's required. Atleast on SQL 2005...
-- You can't be late until you show up.
July 28, 2008 at 6:39 am
BAD-DBA-DAB (7/27/2008)
. in the mean time u cud try shrinking the database.
Do not shrink the database unless disk space has become a critical issue....There is nothing to be gained by...
-- You can't be late until you show up.
July 28, 2008 at 6:23 am
sam (7/25/2008)
To add to this:the database must be totally locked to grow
That's not true, I have users in when an autogrow is initiated....
sam (7/25/2008)
Like he...
-- You can't be late until you show up.
July 25, 2008 at 11:16 am
What OS are you running? Google "Not enough server storage is available to process this command." It returns a lot of hits, some from MS pointing to changing reg values,...
-- You can't be late until you show up.
July 25, 2008 at 8:50 am
Viewing 15 posts - 976 through 990 (of 1,319 total)