How big it will get depends on how big the transactions are. Is the database set to SIMPLE recovery mode?

If the job is running when the cluster fails over the job will fail.

Before your queries are you using the command

use YOURDATABASENAME

go

Will it always be the same SQL Server table exporting to the same Access table? Why not just

create an SSIS package and then you can schedule it to repeat whenever...

Well then like ravikanth said looking at the System logs in the Event Viewer would be your best bet.

You could check SQL Server Logs also..

HA! No need to feel stupid.. after not being able to figure out why you would get that error considering it was the right syntax I noticed you are on...

They would need the VIEW SERVER STATE permission. I would say it would be fine to give them this right.

View button will only show for SQL 2000 servers.

Kenneth Langner Jr. (4/9/2010)

---

Hello

If you click the 'help' button on the top of the job properties form books online opens up and explains:

View

In Microsoft SQL Server 2005, this button...

Hello

If you click the 'help' button on the top of the job properties form books online opens up and explains:

View

In Microsoft SQL Server 2005, this button is disabled for...

If you didn't want to do that you could just tell them to execute the query 'sp_who2' which shows pretty much the same thing.

You would have to create a login for the user for them to connect to the server, then creating the user gives them permission to connect to the database.

Also make sure that SQL server is using Mixed mode server authentication..

It almost has to be the password. Are you sure your typing it correctlY?