Viewing 15 posts - 2,266 through 2,280 (of 7,631 total)
GilaMonster (5/27/2009)
Lynn Pettis (5/27/2009)
Florian Reischl (5/27/2009)
@Lynn:Congratulation for 7k points! 🙂
Thanks! 😉
Yeah, congrats. Noticed that you were top of the 'most frequent posters' list yesterday.
Hey, congrats from me too, Lynn! ...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 27, 2009 at 1:54 pm
Also, a UNC working directory setting will only affect relative paths. It's won't affect any hard-coded paths with Drive letters or their own UNC paths in them.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 27, 2009 at 12:56 pm
You should probably try turning on logging to see what it is doing, and what it is seeing.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 27, 2009 at 12:54 pm
Attaching the database can definitely be done from SMO. A SQL instance, however, requires an install, AFAIK. Can't be done just from SMO.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 27, 2009 at 12:51 pm
Your send mail task should have an SMTP connection manager associated with it (SmtpConnection property). Open that connection manager to check its settings:
- SMTP server:
- Use windows authentication
- Enable...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 27, 2009 at 8:10 am
martin.edward (5/26/2009)
What am trying to do is copy data from table A to another table B, all new data from the table A should be copied to table...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 26, 2009 at 11:30 pm
Warwick Francis (5/26/2009)
Works great thank you RBarryYoung!
Glad I could help! 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 26, 2009 at 11:26 pm
Here's your problem:
ALTER proc [dbo].[VolunteerEventRegistrationEmail]
as
declare @last_id_sent int
DECLARE @sql varchar(2000)
DECLARE @File varchar(1000)
select @last_id_sent = max(last_id_sent) from WebTeamWebsitesData.dbo.tbl_2009_email
SET @sql = 'SET NOCOUNT ON SELECT *
FROM WebTeamWebsitesData.dbo.tbl_2009
WHERE id >...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 26, 2009 at 10:39 pm
You can change it's working directory, but it will still be executing wherever the DTexec is running. There's no simple fix for that.
Phil's suggestion is well taken, I always...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 26, 2009 at 10:13 pm
Jeff Moden (5/26/2009)
RBarryYoung (5/26/2009)
CDR = "Call Data Record"I used to work in that field too... 🙂
We used to call them "Call Detail Record". Either will do.
Actually I think you're...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 26, 2009 at 9:45 pm
CDR = "Call Data Record"
I used to work in that field too... 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 26, 2009 at 5:03 pm
What is the problem?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 26, 2009 at 10:24 am
You can just change it. You should make sure that no one else is in it (put it in single user mode first) just to insure that nothing freaky...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 26, 2009 at 6:37 am
Well, you do seem to be correct about this and I will note it on my earlier post.
Nonetheless, the article that you point to also clearly indicates that a lowered...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 25, 2009 at 12:25 pm
You're asking two different questions here. First "how to run a query every 5 minutes?" Answer: put the query in a stored procedure, then write a SQL Agent...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 25, 2009 at 10:05 am
Viewing 15 posts - 2,266 through 2,280 (of 7,631 total)