I really can't remember having a hero as I grew up. However, as I got older my younger brother became my hero.

My mom had German measles when she was pregnant...

This may be a real simple error. Use Enterprise Manager. Go to Jobs. Open the job. Go to the Steps tab. Open the step. Go to the Advanced tab. What...

Best practices for this type of activity.

1. Switch the database recovery mode to FULL. Do a Full backup. When it's done, stop all jobs (stop the SQLServerAgent service(s))....

The error means that the log you are trying to restore was created earlier than the last file that was restored.

Whenever your database says Loading, that normally means that the...

Two other issues:

1. How are you VIEWING the data? If you are using Query Analyzer, on the menu bar there is Tools. Go there and select Options. Go to the...

#1 consideration. You are using home-grown and vendor created databases. The #1 consideration has to be support. Most vendors do not permit changes to their database(s). If you do...

Cool!!!!!!! Yes, I am the same SQLBill. Good to see another Tek-Tip'per on here.

-SQLBill

SDM,

The poster's original string DOES have a year - it's at the very end.

I want to know how you get "2006/12/13 16:26:13:00" from "Web Nov 15 07:20:46 GMT -07:00 2006"...

You cannot use a column alias in the WHERE.

The issue is the order that SQL Server performs a query. The query looks like it works in this order:

1. SELECT titleid...

There's too many things that could be causing this for us to give you a solution. But here's a couple of the big possibilities:

1. Timeout on the network or SQL...

What do you mean by backing up onto another SQL Server?

SQL Server does not like to do backups across a network. It works best doing backups to attached hard drives...

On the server, open Enterprise Manager. Register the instance if you haven't already. Right click on the instance and select Properties. On the General tab, click on the Network Connection...

Dave I,

quote: That's probably meant to be a 2.

You might be correct and that's what I assume the poster meant, but too many times I've provided a solution (and seen...

You're welcome.....when you get the final solution, post it here. It might help someone in the future (since it did affect your SQL Server).

-SQLBill

Couple of suggestions....

Is your MDAC 2.8??? You can find a tool called Component Checker on Microsoft's website, that will tell you what MDAC version you have.

Can you reinstall the client...