If you are sticking with SQL2K Std, then RAM isn't an issue. You can only use 2GB, so I'd go with 3 or 4GB for the server to give the...

Is there a question here

Does a WHERE clause not handle this for you with one of the effective dates? Seems like you are...

What's weird? Do you have long strings in there?

I don't think that osql will produce an easily readable format. It's designed to retrieve the data, but not for something like...

No, you would need to use patindex/charindex to get the positions and then substring to find the data. You are dealing with a string here, not a function call or...

They are stored in msdb. You can restore a previous backup of MSDE and get the information from sysjobs and sysjobsteps.

Note: You do not need to overwrite msdb, nor is...

It does impede point in time recovery, but it does allow recovery to the last transaction log as well as recovery afterwards.

Perhaps you might describe your problem as you seem...

If you read the entry, it allow recovery while increasing performance during bulk loads. There are some limitations in how the data is recovered, but assuming you do not fail...

I know most of this is possible today, but it's not easily integrated. Nor does it work with most phones or cars. Yet I think it's an easy one.

To me,...

There are some third party product, Protegrity, Netlib, application secrurity, etc. Use the site search as we have a few reviews posted.

Even this: http://www.sqlservercentral.com/columnists/mcoles/freeencryption.asp

Be careful when you do this and...

You can use create a table and then run a "dir" or some other mechanism to get a list of files and load into the table. you'd need to then...

Pls don't cross post.

You can

Merry Christmas and enjoy the holiday!

I usually put the update and select inside the transaction.

Am I the only one with kids here? I thought I'd be low man on the totem pole with this one!

I tend to agree that I rarely decorated anything until...