Paul White (6/17/2009)

---

Yep. I have been quite a proponent of the UPDATE method in the past, but I must admit I am now concerned. The list of requirements...

Weren't you the one who said earlier in this thread that you'd never seen an update that didn't work...

I was going to say...

I know I've used ESCAPE on SQL 2000 before...

http://msdn.microsoft.com/en-us/library/aa933232(SQL.80).aspx

LIKE:

Syntax

match_expression [ NOT ] LIKE pattern...

Poor performance. Generally that kind of query does not use indexes effectively and often does table scans. On small tables that aren't used too often that won't be a major...

If you want the underscores to be treated as literals rather than wildcards, you need to escape them.

SELECT class_code FROM tbl_class WHERE class_code LIKE 'ep/_f/_%' ESCAPE '/'

Interesting.

I'm doing M.Sc at the moment and my study fees are R7000 per year. That's Masters by dissertation, so no course work involved.

They won't. The unofficial word from one of the guys who...

Just a couple things with that.

It's likely to perform badly. Take a look at the blog post I referenced earlier. Also, before you use nolock, read this: http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

Jeffrey Williams (6/16/2009)

---

Interesting you say that cause I have seen it a couple of times now. I think I have it...

Please post the exact messages from the SQL error log.

GilaMonster (6/16/2009)

---

Ooohhh... You're asking for...

Oh dear, this one's not going to be pretty....

http://www.sqlservercentral.com/Forums/Topic735954-357-1.aspx

Suspect DB, and a very new 'DBA'

In management studio open Object Explorer. Management - SQL Server Logs.

If there's a senior DBA there get him involved. Suspect database are serious issues. If not, consider calling MS's customer...

Is the D drive still accessible?

Is the .mdf file where SQL expects it to be? (D:\programfiels\michrosoft sql server\mssql\data\tiger_data.mdf)

Does the SQL Server service account have full rights (read and write) to...

How to recover depends completely on what's actually wrong. Check the SQL error log, there should be error messages indiating why the database is suspect. Check those messages, post them...