We have been running SQL7 for about 1 and a half years, and it is great.
It is running on a PC with NT Server4.0, service pack 6a
There are a couple of nice features in Service Pack 2 (cell-level security in
OLAP), so I installed it yesterday
The installation went very smoothly for the SQL7 portion.
There are 2 complaints:
When installing the OLAP portion of the Service Pack, it failed with a message
about C:\NTSRV4\SYSTEM32\MSCAL.OCX , which it said was probably in use. I cannot
Even more important: next day I discovered that none of my Local DTS Packages
will run: On entering Package | Designer or Package | Execute, I get a message:
"Error occurred during creation of a DTS package" [Ok].
If I try to create a new package, I get:
"Could not create Component Categories Manager" [Ok]
followed by "Error occurred during creation of a DTS package" [Ok].