R
RJ
I seem to have a problem…
SQL Server 2000 sp4 Acc 2003 sp3
I have several forms all of which have fetch defaults set to NO. Yet when I
specify to add a record, as soon as the record goes dirty (first user
keystroke) SQL Server is calling the dreaded sp_Mshelpcolumns. This slows the
initial entry down enough to interfere with the users entry. I don’t have
any problems with an existing record.
The recordsource for all these forms is set dynamically (in code) based upon
user selection. All calls to recordsource are in the form of
Me.RecordSource = "Exec dbo.spfm_Event_Functions " & EventId, all stored
procedure retrievals are against the PK or a FK.
So even though Fetch Defaults is set to NO it seems to be fetching them!
Here is an example from Profiler as soon as the record goes dirty
EXEC sp_MShelpcolumns N'dbo.TB_Events_Functions' , NULL, 'id', 1
SELECT IDENT_SEED('TB_Events_Functions')
SELECT IDENT_INCR('TB_Events_Functions')
… Followed by defaults from the table being selected
How do I shut this off??? Is it related to SP3?
Help from anyone is truly appreciated!
SQL Server 2000 sp4 Acc 2003 sp3
I have several forms all of which have fetch defaults set to NO. Yet when I
specify to add a record, as soon as the record goes dirty (first user
keystroke) SQL Server is calling the dreaded sp_Mshelpcolumns. This slows the
initial entry down enough to interfere with the users entry. I don’t have
any problems with an existing record.
The recordsource for all these forms is set dynamically (in code) based upon
user selection. All calls to recordsource are in the form of
Me.RecordSource = "Exec dbo.spfm_Event_Functions " & EventId, all stored
procedure retrievals are against the PK or a FK.
So even though Fetch Defaults is set to NO it seems to be fetching them!
Here is an example from Profiler as soon as the record goes dirty
EXEC sp_MShelpcolumns N'dbo.TB_Events_Functions' , NULL, 'id', 1
SELECT IDENT_SEED('TB_Events_Functions')
SELECT IDENT_INCR('TB_Events_Functions')
… Followed by defaults from the table being selected
How do I shut this off??? Is it related to SP3?
Help from anyone is truly appreciated!