August 15, 2012 at 5:27 pm
Hey guys. We've got a data warehouse at work which the vendor has built for us before I started. It seems to be working well most of the time, except for those special times when table is missing half of the correct values. The funny thing is I'm the one who has to keep track of that since vendor does not seem to care much about it.
Anyway, I'm looking for possible solutions to this issue. I was thinking that maybe there is a way to run a quick script to count the number of rows under different scenarios (different selects), and if the data is off, it would alert me. What would be a good way to keep track of something like this?
August 15, 2012 at 7:41 pm
This might give you a view ideas of what you can do
http://msdn.microsoft.com/en-us/library/bb522489(v=sql.100).aspx
The other item I would draw to your attention. What are the terms of the purchase/lease of the software. For example if you make any changes / anything at all does the vendor have the right to refuse fruther support for their product ?
August 16, 2012 at 11:00 am
Vendor will bill us if something gets broken through our tempering, but the problem is that to get any kind of response from them takes an ungodly amount of proof that something is wrong, and even when it has been proven, stuff does not get done either. If something is to get done, I'm the one who has to roll the sleeves up.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply