The firewall comment is simply hilarious. Anyone who actually believes that doesn't really know how servers work. Web servers are on the internet to serve out pages. ...

The values you enter will be passed to the procedure as you enter them and they need to be enclosed in single quotes in the EXECUTE statement. Once they're...

It isn't much to go on, but the words "perhaps more" are a little vague. This might mean more data tables; it might mean lookup tables with key/description pairs....

1. Please tell me you have a good backup you can use for restoration.

2. If the application is on the internet, don't forget to include the web servers in your...

The datetime data type is meant to store a point in time, not a duration of time. If you ever have to store a duration greater than 24 hours,...

Perhaps I put too much thought into this, since I figured that we all actually do lock our computers when we're not using them. I missed it, but also...

Your max time is now very close to a whole day. I would at least consider converting this to a numeric data type. As soon as you cross...

If you convert everything into seconds and then save the decimal portion of the number for the fractions of a second, you'd have a maximum value of 86,400 seconds in...

This probably isn't what you want to hear, but I believe the time data type is meant to store a point in time, not a duration of time. So...

That's really good - thank you.

The Windows SFTP server depends on whatever software you buy and install. We have one here, but I don't administer it. It's pretty...

Chris: Nice work.

Todd: Welcome to the life post-Access. I think you'll find a lot more power and flexibility here than in your previous life. Warning - you'll probably...

I don't know about using SFTP, but I have implemented FTP. I'd imagine they would be similar, but you will absolutely need SFTP client software that supports command line...

In that case, go with the FTP approach.

It's a good question because it's one of the basics we've all run into at one point or another. I usually handle it by using an ALTER TABLE later...

You can FTP from within SQL Server, but I've never gotten SFTP to work properly. That's not saying it can't be done, but I don't want to install an...