|
||||||
|
|
While troubleshooting an existing 2008 R2 package the other day I received the following error. Error HRESULT E_FAIL has been returned from a call to a COM component. The error occurred when I was using breakpoints and watch windows to diagnose problems in the package. The breakpoint behavior was off because even when there wasn’t a [...] The Problem When you pass GetDate() as a parameter to a stored procedure, the following error is returned: EXEC dbo.ProcDate GetDate() Msg 102, Level 15, State 1, Line 1 When I ran into this problem, I found this helpful article which suggests that I should assign the value of GetDate() to variable and then pass [...] As I’ve mentioned before, the Made2Manage Favorites Bar is a buggy mess. I regularly get questions from my clients and readers of this blog asking why M2M screens return incorrect data or otherwise misbehave. One of my first suggestions to them is to disable the favorites bar. However, disabling the bar isn’t intuitive so I [...] Like many of you, I have been finalizing my PASS Summit plans, getting ready for the trip to Seattle. For the past week, my girlfriend has been asking weird questions like, “Have you packed your sun screen?” This makes no sense because there’s no way I’ll get a sunburn in Seattle in October. When I [...] “Why would you do that for free?” she asked. I was kind of surprised and paused for a minute because it had been some time since I had thought about it. To set the stage, I was visiting a relatively new client and since they have casual Fridays, I wore my speaker shirt from SQL [...] Like many other technical bloggers, I receive requests for help on a regular basis. Since I’m constantly learning and evolving I approach others for help as well. A couple of years ago, I received an email from a new reader which began with: Always two there are, no more, no less: a master and an [...] I haven’t been participating in many of these blog memes because I have been so busy lately. A lot of my time was occupied with job hunting and since I just finished a series of interviews with different companies, this meme is perfectly timed. My good friend Jen McCown (Blog/Twitter), the fairer half of the [...] Last week I saw a discussion on the LinkedIn Made2Manage Group about the Pros and Cons of using SSRS vs. VFP Reporting, and it amazes me that people are still arguing about it. So, I thought I’d reaffirm a stance that I’ve had for many years, which is VFP Reporting Must Die. I’ve [...] When was the last time you booked a trip through a Travel Agent? Rented a Video from an actual person? Have you ever seen a Milkman Telephone Operator, or Elevator Operator except in classic movies? Why do I ask? Well, technology is eliminating the first two jobs, and the last three are practically extinct. Which way [...] In a previous article, I listed the benefits of using a dedicated date table and included a customizable script which enables you to quickly create your own version. One of my readers pointed out that he uses the date datatype, rather than using the smart integer key method, when working with SQL 2008+ databases. The [...] |
|||||
|
Copyright © 2012 Made2Mentor - All Rights Reserved |
||||||
Popular Articles