If you run osql from the command line, does it run? might not be in the path.

What's the issue? Do those queries not work? Or do you need them in one query?

Use and AND in the WHERE clause and include both criteria.

Run the log backups on your interval and note the sizes. This will help you figure out how big to size the log. The more often you backup the log...

Not sure what you can do there other than look for another job.

You want to perform lots of due diligence, meaning talk to more than the hiring manager. Talk to...

They should all be there. Might be some search default for the current year, but you should be able to find them all.

Thanks, fixed.

If you give more information on why you are doing this and what your requirements are, we can give you more guidance.

please post a question. the subject is not part of the question.

Your logic makes sense to me. You might some slowdowns on loads, but most likely the R10 will help your queries (reads) and the logs with the OS won't slow...

Check that the time passed is really 1 day. It doesn't remove the files when the next backup has occurred, but when a full day has passed between backups. you...

Please don't cross post. Answered here: http://www.sqlservercentral.com/Forums/Topic572937-146-1.aspx

However, if you don't use the WITH INIT option, they'll get to be the same size :hehe:

You really should be creating temporary tables (#tablename) in your proc, and not a permanent table if you are constantly dropping them. You'll run into concurrency issues at some point.

There are a few things. There isn't a client per se. There are client tools, which you will find in a group in Programs ( SQL Server 2005), but every...

This typically happens when you run a backup, and add a new backup file in the "Backup Database" dialog. Since the new file is highlighted and the one that was...