No need of the SQL Agent... Just schedule a task in windows, to execute a SQL script and a vb script ...
http://www.mssqltips.com/tip.asp?tip=1486

With SQL Server Express, i had 2 different databases in the App_Data folder of an application, and i was getting constant connection errors.

After googling, i tried any solution, from changing cacls on the db folder, adding users in the sql server security, database roles, to changing identity of the iis application pool, and so on...

NOTHING Worked !

Even with 1 database alone, i was getting errors if the database was opened at the same time in visual studio and by IIS...

I ended up by regrouping the 2 databases in one,
and attached it the classic way to the server through sql server management studio.

with this connection

<

Getting this error when accessing the database during YAF Setup ?

"System.Data.SqlClient.SqlException: INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods."

Solution: rise the compatibility level of your SQL Server to SQL Server 2005 (90)
http://msdn.microsoft.com/en-us/library/bb933794%28SQL.105%29.aspx