Stephen, >>But you can write that as a developer as part of your app.<<
Sure you can work around the missing SQL Server Agent, but it sure is nice to have it built in and accessible without the need for me to write something myself. It works great and is reliable. I believe several developers are surprised by this. I know I was when I heard about it in Jim Duffy's session at Advisor DevCon. Also, I do not have to worry about the user killing a task out of the Windows Task Scheduler, and it is one more thing to worry about when deploying a vertical market application, and even a custom app. I know the user can shut down SQL Server Agent, but when the job does not complete successfully I can have it email me. Now it just does not run. A poor design decision by Microsoft in my opinion. Rick White Light Computing, Inc. www.whitelightcomputing.com www.rickschummer.com 586.254.2530 - office 586.254.2539 - fax -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen the Cook Sent: Friday, October 27, 2006 03:04 PM To: [EMAIL PROTECTED] Subject: RE: Anyone used SQL Express? Rick Schummer <> wrote: > Derek, > > While MSDE (SQL Server 2000) has a performance governor on it, SQL > Server 2005 Express (the version Paul is asking about) does not. They > also raised the database size limit to 4GB from 2GB. One thing in MSDE > not in SQL Server 2005 is the SQL Agent used to schedule things > like backups. But you can write that as a developer as part of your app. Or follow the crap that M$ says: SQL Agent SQL Agent is a SQL Server service that is used to automatically schedule job execution for SQL Server. It is typically used to schedule the execution of DTS packages or to perform system maintenance tasks like database backups. While MSDE includes the SQL Agent service, SQL Server 2005 Express does not. However, you can use the Windows built-in Task Scheduler to schedule jobs for SQL Server 2005 Express. You can use Task Scheduler in combination with the downloadable DTS runtime to automatically schedule the execution of DTS packages. Likewise, you can use Task Scheduler in combination with the SQL Server 2005 Express command-line SQLCMD tool to regularly execute SQL Server 2005 Express system maintenance jobs like database backups and other database access jobs. In all honesty the backup time for a 4 gig max db is a min or two. Granted you don't get the log files every X min, but who needs them anyway. ;-> Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr. http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.408 / Virus Database: 268.13.11/496 - Release Date: 10/24/2006 [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
