We run an Access/VBA appliation against our MS-SQL server. We're not highly experienced and haven't spent anytime fine tuning the server over the past couple of years.
Recently we've noticed a few oddities such as the inability to open rows in the database on the server. We are linked to those tables over an ODBC connection from Access and can get to them just fine. We have another table which we can now not open. Plus we'd like to fine tune the server to increase speed as much as possible.
So we need an expert who can logon, checkout the server setup and fine tune it as necessary. Plus fix any current problems. We'll provide a VPN or Remote Desktop connection to the Enterprise Manager.
For this first project presume it will take no more than four hours of your time. We can always authorize more later, if there are greater needs.
And we'll want someone who will be around for the future wo we can call on every now and then to help us out. And to make sure we're maximizing the server performance.
## Deliverables
See above
## Platform
Windows Server 2003 and Microsoft SQL and Enterpise Manager