Viewing 15 posts - 4,201 through 4,215 (of 9,715 total)
I don't know any of the new books, but I do recommend studying recovery / backup, learning all variations on the SELECT statement, and security.
July 10, 2012 at 8:37 am
rmechaber (7/10/2012)
http://www.bidn.com/blogs/Daniel/ssas/2313/force-a-sql-agent-job-step-to-fail
I just tested this by creating a dummy Agent job with 2...
July 10, 2012 at 8:20 am
I've never heard of disabled indexes causing any problems.
July 10, 2012 at 7:52 am
Are your execs logging into Integration Services and executing the package from the Stored Packages folder? Or are they running them from the child jobs?
July 10, 2012 at 7:44 am
So far as I know, it's not possible to pass an error outside of a jobstep to cause the job itself to fail. The error is only relevant inside the...
July 10, 2012 at 7:30 am
Thank you for letting us know. That will help with future questions.
Glad you got it working.
July 10, 2012 at 6:20 am
Koen Verbeeck (7/9/2012)
These are the types of bugs that can drive you really mad 🙂
Tell me about it!
Sure enough, same issue on the other packages that are having the exact...
July 9, 2012 at 5:27 am
Oh, for the love of ...!#(*%$#W$
I think I just found out what the issue is. EDIT: Forget the screenshots.
I have a file that comes over from a vendor named MyFile...
July 9, 2012 at 5:06 am
GilaMonster (7/6/2012)
July 9, 2012 at 4:21 am
mehmet.erbay (7/8/2012)
Hiuse
"SET ANSI_WARNINGS OFF"
in your stored procedure
Can I ask what makes you think this will work?
July 9, 2012 at 4:07 am
You said nothing about distribution, so here's a link. Check everything:
July 6, 2012 at 12:33 pm
tim.cloud (7/6/2012)
For my business, it begins on the first day of October and ends on the last day of the following September.
In addition to what everyone else has already added,...
July 6, 2012 at 12:31 pm
What error is it giving you?
I'm betting the distributor is still set up. Or the subscribers.
July 6, 2012 at 12:15 pm
Viewing 15 posts - 4,201 through 4,215 (of 9,715 total)