too late

Cheers,

- Mark

I've successfully tried:

alter database xxxxx modify file (name = 'old_logical_name' , newname = 'new_logical_name')

You should get the confirmation message:

The file name 'new_logical_name' has been set.

Cheers,

- Mark

Is any report produced by the restore attempt?

If not, can you try a manual restore from QA and see what errors you get?

Cheers,

- Mark

I've worked with such a scanario before... a large log-shipped database that was also the publisher for transactional replication. We had no problems.

Can you get more details as to...

How about getting the server to BACKUP DATABASE either to a share on the workstation, or to an alternative commonly-accessible share?

Cheers,

- Mark

Try:

SELECT DISTINCT

WorkerI

FROM tblWOWorkOrder

WHERE ISNUMERIC(WorkerI) = 0

ORDER BY WorkerI DESC

Cheers,

- Mark

I agree with Dan. The MS Press books for exam prep, backed up by those other 2 titles for bookshelf reference.

For day to day reference though, I...

Frank,

You betcha. 3 points for me!

Cheers,

- Mark

Mike,

Honest, I did test it before submitting it... I didn't want to be caught out by 30,000 irate DBA's.

The 'chicken AND NOT soup' syntax is ok. ...

What are you entering at the command line?

Cheers,

- Mark

I spent a couple of hours scratching my head at a client's site, over a similar (non food related) query and the unexpects results I was getting.

When you do "CONTAINS...

your last statement needs to be:

exec (@query)

Cheers,

- Mark

Check the contents of the INSERTED and DELETED tables. For Updates, the 2 tables will contain equal number of rows. For Deletes, INSERTED will contain zero rows, and...

Does it happen EVERY time you try to restore with EM, or just randomly?

There may be more useful details about the error in your SQL Error Log, or even in...

Yes, it's linked to contributions/posts. Note, that it doesn't reflect WORTHWHILE contributions.... which explains my 4 star rating.

Cheers,

- Mark