Tip Bank

Question: I would like to build a stored procedure that will receive a table name as a parameter. It then will select the data I want into whatever table name

Question: I noticed that MSDN contains sp_OAStop, which shuts down the OLE environment that starts inside SQL Server the first time you call sp_OACreate. But I can’t figure out what

Question: How do I create a new table? Answer: The DLL syntax for creating a table intuitively is the CREATE TABLE command. You can specify all the options for the

By default IIS 4 doesn’t permit to use the Server.CreateObject command with an out-process ActiveX EXE component. To do so, you must manually create the AllowOutOfProcCmpts registry value under the

When you pass a non-existing key to the WriteProperty method of the PropertyBag object you get an error 327 “Data value named ‘namekey‘ not found”. This is more or less

At times you may need to access the command line passed to the application from within an ActiveX DLL. Unfortunately, when inside a DLL the Command$ function returns a null

Before going to production, you should ensure that the server-side script debugging is off for your ASP application. In fact, not only does server-side debugging slow down your application, it

As explained elsewhere in this knowledge base, you are suggested not to rely on the OnStartPage method to get a reference to the main ASP objects, if your component is

When an interpreted client running in the IDE enters debug (break) mode, all the ActiveX DLL it’s using continue to be in run mode as usual, even though you won’t