Yes, exactly....Thank you also for taking the time to respond and help...Joe Wolfe
Sorry for the late reply, I've been traveling and super-busy but have been meaning to get back to this post. I'm sorry to say that I don't have much of a solution, it just looked like people in this thread were not understanding your problem. I have seen other equally weird behavior in BIDS (Business Intelligence Development Studio) that I was fixed by a re-install.
The problem you are having appears
to be related to BIDS (if that is what you are using). You said that you tried re-installing SQL Server - did you reinstall BIDS as part of that? Either way you may want to re-install BIDS (e.g. run the installer, do add/remove componants, remove BIDS... run the installer again and add BIDS. You may also check for updates. If you are using full blown Visual Studio instead of BIDS then re-installing SQL Server would not have fixed anything and you may want to re-install Visual Studio.
My world is mostly SSRS these days and, I'll be honest, I just use this stuff and have not installed/configured VS/BIDS in a few years so take what I said with a grain of salt. The best advice I can give is to re-post this problem under Reporting Services 2008 Development
with the Title, "Problem with BIDS". I think you'll get a better answer. Hope that helps.
P.S. If you are at SQL PASS (I could not go this year
) - go talk to the CAT
people. They'll figure it out in 30 seconds (they're real good)
-- Alan Burstein
Best practices for getting help on SQLServerCentral
Need to split a string? Try DelimitedSplit8K
Need a pattern-based splitter? Try PatternSplitCM
Need to remove or replace those unwanted characters? Try PatExclude8K
. "I can't stress enough the importance of switching from a 'sequential files' mindset to 'set-based' thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code. " -- Itzek Ben-Gan 2001