Search results for query: *

Hi, I hate to re-introduce an old topic but I'm seeing a similar problem after our application install. I've verified that the path under: HKEY_LOCAL_MACHINE/.../RunOnce is valid but for some reason it generates an error on restart. The particular path points to a setup folder and uses the...

Unless I'm mistaken, it seems to me that you can't use the 'EXEC' function for dynamic SQL with variables. SQL treats the EXEC statement as it's own private batch so it can't see any variable declarations outside the specific dynamic SQL statement. I think you might be able to use...

Has anyone had experience with the new criteria added to recompile stored procedure execution plans in SQL7/2000? I'm working on an App originally developed in SQL 6.5 with a specific process of using #temp tables to allow for maximum speed and minimal user concurrency issues. The process runs...

Hi, I'm having an unusual problem with a datawindow that is used for a simple report in PB7. The report prints service carts which can have multiple locations for each cart and multiple rooms for each location. Therefore the report is written using nested datawindows, the outermost retrieves...

I have a problem using sp_droptask within a trigger in a Powerbuilder application on a SQL database. The existing code worked in SQL6.5 but is failing since converting to SQL7.0/2000. There are two processes the "compile" and the "analysis" with separate status tables...