Try using the LastWriteTime property instead of the CreationTime property.  Once the file exists, updates will not affect the CreationTime property, but each time it is written the LastWriteTime will...

tools that build databases.  what names can you be sure you customers are not going to use?

I use double underscores at the beginning and ending of a column name when I am writing an application that will have user named columns.  Its not a C++ thing, I just want...

You can use DNS names for your developers to reference the database with.  In our environment we have an alias for development, UA, and production for each application.  That way...

Each report parameter has properties that tell the system if it can be Blank or Null.  These are checkboxes are in the Report/Report Parameters menu from the Layout mode in...

yes, each error has a specific number, i don't recall off the top of my head which number is duplicate key violation but we use code that looks like

   if...

You could add an index to your table that requires the keys to be unique.  If you then try to insert a duplicate key, the server will refuse to add...

True, sounds like either you will need to have that directory cleaned out after you snag the files you want or you are going to have to keep a list...

regular old FTP has an MGET command that will allow you to fetch several files matching a pattern. 

OT: If anyone here has any Crystal Reports experience -- is there any way to change the data source of the report without having all the fields deleted (it took...

At one place i worked at, we had a web page that displayed the status of things.  A simple red, amber, green traffic light was displayed on a grid for...

If you are using a query or stored procedure to fetch the list of values to select, add a Union statement to add the null to the result set.  I...

Thats what the report Snapshots are for.  I've read about it but never set one up.  The idea is that you set up a snapshot schedule, and then the users...

Yes, the XML is defined to be case sensitive.  Its bitten me too.   For a universal data transfer language, it seems a bit silly...

check out http://www.sqlservercentral.com/columnists/cherring/replacingcursorsandwhileloops.asp

specifically the Replacing the Outer Cursor code sample.  The code needs a local variable to hold the strings, but you can concatenate the whole list into a...