Glenn - in that case you definitely need to bug it with MS PSS
Quote:> Yes, I have tried recreating the sp's and the proc does not use a view.
Q. Who are Microsoft Product Support Services and how do I contact them?
A. These are people who support all MS's products, write fixes, take the
calls, sort out workarounds etc. They work 24x7x365. The only way to contact
them to place an initial call is by phone (unless you have a premier support
contract in which case there are web based methods). For details of your
nearest PSS support centre go to.
All calls are chargeable either to your credit card or an existing account.
Your call fee WILL be re-imbursed if the problem turns out to be an MS bug, or
a feature that hasn't been publicly documented. The person answering the phone
cannot know it's a bug, so they have to take details of your credit card before
passing you on to a technician. When the call is closed the technician decides
whether to mark the call as "free" in which case you get a refund
Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (356 entries) see
or www.ntfaq.com/sql.html (+ ntfaq download)