Viewing 15 posts - 2,311 through 2,325 (of 4,272 total)
hein-1120388 (4/20/2010)
I'll have to look at the firewall route for blocking the ranges, but then some clients connect from anywhere in the...
April 20, 2010 at 1:58 pm
I think it shows as cancelled. But I completely agree it will die.
CEWII
April 20, 2010 at 1:31 pm
I would echo what Lynn and bterraberry have said. Having a SQL Server open to the world is asking for trouble. You should have an idea of what...
April 20, 2010 at 1:30 pm
I did a quick search to see if NT AUTHORITY\NetworkService would normally have enough rights to stop/start a service, but I didn't see any answers or anything pointing me that...
April 20, 2010 at 1:26 pm
In general indexes increase SELECT performance but any kind of insert/update/delete activity requires the data AND index be modified so there is a cost there. So by taking the...
April 20, 2010 at 12:07 pm
The item that struck me was "at my ISP". What it sounds like is that SQL does not run as a priviliged account (in the administrators group) and therefore...
April 20, 2010 at 11:14 am
While I agree with Brian, I challenge the requirement.
This is a lazy requirement in my book. In my experience it comes from fear and from someone reading a whitepaper...
April 20, 2010 at 11:08 am
The first thing that came to mind is that this might be a scheduled job and that other database maintenance tasks like re-orgs/re-indexes may have been conflicting either directly with...
April 20, 2010 at 10:38 am
So how is the parent package calling the child package. Also you said you know the filename is correct, is it hard coded?
Are the paths on your local the...
April 19, 2010 at 2:57 pm
I am not sure how to get around that but you could send email from a Script Task directly. You might look at this code:
Code to send mail for...
April 19, 2010 at 2:53 pm
Steve Jones - Editor (4/19/2010)
anthony_merriwether (4/19/2010)
April 19, 2010 at 2:46 pm
I don't view using a copy of the solution as important, but you might make sure that the copy was good.
As far as the verification.
In the Control Panel...
April 19, 2010 at 1:49 pm
Ok, you have verified that the login used by SQL Agent has access not only to the path the package resides at but the package itself. You might consider...
April 19, 2010 at 12:50 pm
I cant answer the question yet..
Is the package file located on the same server as the SQL Server?
CEWII
April 19, 2010 at 12:32 pm
Sorry, I can't help you there.
I don't use that option.
CEWII
April 19, 2010 at 12:22 pm
Viewing 15 posts - 2,311 through 2,325 (of 4,272 total)