there are some network throttling (and monitoring) tools that you can download (we used them to simulate moving from citrix published apps to a Client/server app over the WAN.

i'm not...

not quite that way,

access calls gets the results steadily using as much network bandwidth as it can.

the reult set is available immediatley, (which is why you can navigate quickly...

if this is a one way process (from pub to sub) then have you considered using log shipping ?

according to microsoft docs you can't.

what you could do though is back up your user databases and uninstall sql server - then install sql standard and restore your databases.

proboably best...

just out interest, if you switched to simple mode, why did you back up the log ??

just run a checkpoint command????????

sql server and access will drip feed the results through the connection.

what you can do to give your users the perception of a faster connection is use the FAST...

you could write out the stored procedures to text files and then use ISQLW.exe to run them.

that way you can use xp_cmdshell to call ISQLW

declare @strsql nvarchar(4000)

if (select system_user)='mike'

begin

print 'True'

set @strsql='create procedure usp_test as select NULL'

exec sp_executesql @strsql

end

else

begin

print 'False'

set @strsql='create procedure usp_test as select NULL'

exec sp_executesql @strsql

end

you can import data from foxpro fairly easily.

right click on your new database and select all tasks, then choose import data.

as your source choose the driver for Visual...

the problem is that your stored procedure is returning the nuber of rows inserted into you temp table as the first result (which the app will pick up)

all you...

we support several systems that fall into these categories.

you were wondering if your front end application will work with a clustered active/active (load balancing) solution - most likely...

try the query

select name from sysobjects where id=2057058364

this should tell you the table name

can you post the view code.

not as far as i'm aware.

but what you could do is set the idle state in SQL AGENT as below 80% for 2 minutes.

what you can then do is perform...

from books on-line

***********************

SQL Server Agent polls the performance counters at 20-second intervals.

Important Using a frequency higher than 20 seconds increases the processing overhead for SQL Server.

If a counter...