1,757 reputation
69
bio website
location Rochester, NY
age 53
visits member for 3 years, 11 months
seen Sep 2 at 1:11

Jul
14
awarded  Editor
Jul
14
revised Add DEFAULT to existing column
added 252 characters in body
Jul
14
answered Add DEFAULT to existing column
Jul
9
answered SQLCMD Mode in SSMS and @@variable expansion
Jul
9
answered More Databases Per Sql Server 2005 Instance
Jul
6
comment LDF and MDF file sizes for a dynamically created Database
You could set up SQL Agent alerts, use the performance condition alert, and the Databases object to alert on Data File/Log File size > xGB. But the alert won't stop the database from growing, only setting a max on file size will do that.
Jul
4
awarded  Critic
Jul
4
awarded  Citizen Patrol
Jun
24
answered A query submitted from different applications has differing DOP
Jun
1
answered SQL Server Backup Process Tuning
Apr
4
awarded  Teacher
Apr
3
answered Redgate SQL Compare vs Visual Studio 2010 Premium/Ultimate database project
Mar
29
comment SQL Server 2008 R2 Express for a single website?
One downside of no agent is you'll need some other mechanism to schedule backups, the Windows task scheduler works fine.
Jan
22
awarded  Supporter