Frank,

I had a very brief look at it.

My thoughts are that one of the reasons for using C++ is its ability to use pointers.  The point about managed code is...

The actual procedure is shown below.

The idea is that it returns a "page" of records.  A page defaulting to 10 records.

CREATE PROCEDURE dbo.usp_GetChildLinksNav 

 @lViewTreeId  Int,

 @lPageLength Int =10 ,

 @lPageNo  Int = 1...

OK, I've found it.

If you run SQL Profiler and look at the Stored Procedures events, if you run a stored procedure beginning with the letters sp_ then you will get...

So basically the real life query is some horrendous multi-table join with a vast number of records.

I would agree that a temporary table is the way to go but I...

I've tried running a SQL Trace on the MASTER and local database but cannot see any attempt to access the MASTER database.

I know that this is not conclusive because it...

The script doesn't switch to using TEMPDB.  It simply references temporary tables.

CREATE TABLE #Tbl_Tree1(...etc)

INSERT #Tbl(... etc)

It is a shame that there isn't a global setting for SET NOCOUNT.

It is one long stored procedure.  I am intending to break it out into smaller procedures later, but at this stage I am simply getting the procedure working.

What I am...

Sorry, half the post got lost for some reason.

It should have said that I have a stored procedure where SET NOCOUNT ON doesn't seem to work.

The procedure itterates down through...

I could be picky here and say that in addition to the "bouncing through the master database" thing having a different prefix for none Microsoft procedures aids identification.

Bert De Haes,...

Firstly you cannot TRUNCATE a table that has primary/foreign key relationships.

The only advantage to DROP/CREATE that I can see is that it takes care of situations where the source structure...

The problem I have with "how to program" type books is that at some stage there seems to be an example that is basically how to build a scribble or...

Given the importance of data in the corporate environment I think Microsoft have made a good call.

If YUKON is as big a jump forward as VS.NET then it will have...

This is assuming you have a reference to Microsoft Data Access Objects.

Public Sub sbRename()

    Dim db As DAO.Database

    Dim tb As DAO.TableDef

    Set db =...

I have an MS Access database that is blank apart from standard utility functions that I always use.

One of the routines loops through the tabledefs collection and removes any dbo_...

INSERT won't delete records because the virtual table "inserted" contains the appended records, not the "deleted" table.

This strikes me as a Dilbert trigger.  If anyone attempts to update records, punish...