Years back I worked for a marketing firm that accidentally mailed coupons for free oil changes to thousands of people at a specific car dealer, due to a software bug. ...
I couldn't do my job well without SQL Compare and SQL Data Compare. Great tools, although occasionally SQL Compare hangs on me. Also UltraEdit; especially useful are its macro and...
This is nice, but what if I want to see available space for all databases on my server? I tried doing this by using the sp_msforeachdb proc, but for some...
Per the sample script, you may want to place brackets around the ? in case you have database names containing periods, etc. There's also a couple minor syntax problems in the...