|
Hi any spatialware gurus, When things go right, spatialware has been working
well. However, when I get something go wrong, it can trigger a whole
sequence of issues, eg. if one of the stored procedures fails midway, I
may have dropped the rtree index in a stored procedure and not recreated
it at the end. Then the next time I run the stored proc, I get an error saying
that I cannot run the stored procedure as I get the error. [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop
the function 'dbo.T_GPS_LOCS#p#SW_GEOMETRY#p#SW_MEMBER', because it does not
exist in the system catalog. Then worse, I get the following error because SQL server has
stopped. Connection Error was: [Microsoft][ODBC SQL Server
Driver][Shared Memory]SQL Server does not exist or access denied. I have seen a number of stored procs in the database like sp_sw_predrop_rtree,
sp_sw_rtree_is_precreated, and thought that perhaps these could be used to
check before I run the drop rtree procedure. I am not sure how to though.
It would be better if these sort of checks were simply included in the create
rtree stored proc….. Any suggestions? TIA. R ------------------------------------------- |
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
