Lower performance for non-dbo users (SQL 6.5 SP4, NT 4.0 SP4, Access 2.0 client) 
Author Message
 Lower performance for non-dbo users (SQL 6.5 SP4, NT 4.0 SP4, Access 2.0 client)
When logged into NT under my own ID (admin group and database DBO) some MS
Access queries on SQL Server attached tables seem to execute much faster
than if I log into the same box under anyone else's ID. The queries still
complete but take up to 50 times longer.

Does anyone know anything about this? Can anyone help?

Thanks
Aidan Gibson



Fri, 04 May 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Help Please, SQL 6.5 NT 4.0 SP4 performance issues

2. NT 4.0 SP4 with SQL 6.5

3. Network problem with SQL 6.5 SP5 and NT Server 4.0 SP4

4. NTS 3.51,SP4/SQL 6.5,SP1 to NTS 4.0/SQL 6.5,SP1

5. Cannot access SQL Server 6.5 SP4 databases via Access 97

6. SQL 6.5 W9x client upgrade to SP4

7. SQL 6.5 sp5a replication, NT SP4 problem??

8. Cannot Set SQL 6.5, SP4 master DB to Single User Mode

9. SQL 6.5 rinstall on NT 4 sp4 problem

10. Help! NT SP4 then ERRORS in SQL 6.5

11. Installing SQL SERVER 6.5 with NT SP4


 
Powered by phpBB® Forum Software