Are all of the backups being made to the same location?

One thing to consider, when you run the backup from QA you are doing that with whatever permissions YOU have. ...

BTW-checking BOL doesn't always work.  BOL can be updated by itself or by updating the Client Tools.  Also, there have been other updates to BOL since SP3a and I've applied...

Yes, I know MS says there's no need to apply 3a if you have 3 applied. However, our vendor's product apparently 'pulls' the version and won't work unless it's SP3a...

Or what happens if a male named KIM gets an official document that lists him as a Female? Lawsuit maybe? It is possible.

A lot depends on what this data will...

Maybe I meant 35 minute drive?

OPPS.

-SQLBill

BTW- if you have not made your hotel arrangements yet - the Gaylord is sold out. But PASS signed an agreement with another hotel, so you can get the same...

It still exists, but you can't use it. You will get login failures because the user SA can't authenticate.

-SQLBill

If sushila's suggestion doesn't help, provide us some sample data and that will help us to provide a better solution.

-SQLBill

You say <quote>when I installed mySql <end quote>

Is that true? You are having this problem with mySQL?????  This site is really for Microsoft SQL Server.  You might want to try...

You say it goes from 2003 to 2009.

Run this:

SELECT GETDATE()

That will show you what the server's date is set as. If you are getting 2009, it looks like your system...

Here's how I look at Stored Procedures...

Let's say you have an application (for example: Crystal Reports), that has 5 users. Each user queries the same data.

You have two choices....

1....

Here is another item of interest from BOL:

collation_name

Specifies the collation for the column. Collation name can be either a Windows collation name or a SQL collation name. The collation_name is...

<quote>I don't need an elaborate solution, it's a one-time submission? <end quote>

Beware of this.....usually once you show you can provide something, or provide it in a special format, the client...

A computed column doesn't really exist. Try this: DROP the computed column. Change the collation and then ALTER the table to ADD the computed column back in.

Before anyone 'jumps' on...

I don't run showcontig first.  I know my database has LOTS of INSERTS (no UPDATES). Very seldom are there DELETEs and they are only done by me. But when I...