You'll also want to a process to delete (drop) snapshots after a specified period of time. You can't just keep creating them as you will run out a of...

How about my other question??

Actually, start with BOL. It should be able to help you get started with understanding Dynamic SQL.

Because the DataServer you are connecting to is SQL Server 2005 not SQL Server 2008.

The only things that comes to my mind is Toad for SQL and ApexSQL Edit. Haven't used Toad, so can't give you an assessment of the product. I...

I may not have much time during the day, we are finally getting some of our new servers for a PeopleSoft Tools/App upgrade. It may be tonight before I...

May be a dumb question here, but are you sure you are using SSMS 2008?

Then SQL Server install should have asked for a sa password. If you have forgotten it, you will have to change it as there isn't any way to find...

You need to use dynamic SQL. You can do it directly in the T-SQL job step or as a stored proc executed in a T-SQL job step. Personally,...

Looked back at when this was posted. That was right around the time my oldest daughter left for Basic Training for the Army. I may have just overlooked...

Brain Dead. IIRC, Quest LiteSpeed, Redgate SQL Backup, etc support log shipping and they can encrypt the files. Also, HyperBac can also encrypt the backups, and since it...

This is why I suggested UNC's, from your previous post:

The external folder has been mapped on the server where SQL is installed.

I created some batch file and scheduled it and...

What version of SQL Server are you using?

Looks like selecting 60 days of data and a pivot to boot. Am I correct?

YSLGuru (12/16/2009)

---

Drew,

Thanks for replying and I know this is a few months old now (Just now getting time to go back and deal with this one) but unfortunately that will...