If you like to paste scripts into the command window when creating SQL Server 2000 jobs in Enterprise Manager, you should be aware of the 3200-character limit. You won't get a warning unless your script does not parse correctly because of the spot where it was cut off. You will get a warning if you choose Open to open a script file.
I just discovered the SqlBulkCopy class in .Net 2.0, and it seems awesome! Now I don't have to shell out to BCP anymore! We'll see though, I haven't done any performance testing yet...
How is it possible that I'm just learning about the "GROUP BY ALL" option? It sounds like it would save a lot of time. It worries me though that Microsoft says not to use it anymore because it will be removed from a future version. Is there a good alternative?
For any telephone/cellular service provider who cares, you should be implementing the option of caller-specific voicemail greetings on your system. The scenario happens quite often: I know somebody specific is going to call me during a period in which I'll be unavailable, and I have a specific message just for them, e.g. "I'm mowing the lawn but I'll be ready when you get here" or something like that. Also, having a web page to administer the whole voicemail system and contacts would be great. Feel free to pay me for the preceding advice.
[][]
>
`---
If you want to build your own composite control for ASP.Net and you want to create in such a way that when you set a property in the designer window, the setting is reflected in the aspx code, placing this attribute on each public property is the key:
[DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]