My SQL Server 2003 machine has been taking very long to preform transactions and i am getting locked objects.
I back up the server daily.This is also a production server.
I checked the Logs and I saw I keep getting this error
Autogrow of file 'My_DATABASE' in database 'MY_DATABASE' cancelled or timed out after 30641 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size.
I have noticed that the SPID used is the same that is locking my Objects.
Does anybody have any suggestions how I can fix this problem.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…