Also regarding the company providing training; it's nice when they do, but in the end it is up to us to keep ourselves current and relavent in our rapidly changing...

Magy (12/16/2009)

---

Using an order by clause on the newly populated table will not work because there is nothing unique about the data. That's why I was hoping the...

The error message pretty much tells you what is wrong. The password for the account attempting to login to the server has expired. You need to change the...

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...