I have absolutely no intention of running SQL Server at all on this machine with Vista Home. Never did. I had to have a laptop for basic internet...

Of necessity, I bought a new laptop recently that came with Vista Home Premium installed. It's pretty and has some "fun" features but I'm not all that impressed. ...

I just now noticed you did a physical only check. Try running a generic DBCC CHECKDB first if you can.

Good luck!

What's the query plan look like for that thing? Check in both 2000 and 2005.

As the errors indicate hardware failures, you probably have something wrong in the setup / hardware configuration.

Regardless, you really only have two options at this point to fix the database...

http://msdn2.microsoft.com/en-us/library/aa275735(sql.80).aspx

There's links to the rest of the errors on the left-hand side.

Your best bet is to restore the database to a previous backup. If you don't have one, run...

Sounds to me like you have an orphaned user.  MSDN has a buncha info on them.

Take a look at this: http://support.microsoft.com/kb/314546/

Yes, I am well aware that they don't and shouldn't *run*. The issue is the install / creation of the stored procedure which will, when called, run the update...

Heh.  Maybe that's why I like being a DB Developer.  My very first "professional" computer job was updating / upgrading a Lotus 123 spreadsheet (back in the DOS days...) that...

Sure thing.  Have a look at this article:

http://www.sqldts.com/default.aspx?246

(This is much, much easier in 2005 SSIS if you have access to it.)

Try LEFT(LTRIM(addressno),1) .

Of course, that only lets you know about the very first non-blank character.

SSC at my first response…

I’m guessing from your post that you’re not US-based so all...

Well, that woirks for me in 2005.  Unfortunately I don't have 2000 to test there.

Try this, though:

SELECT Col_1, COUNT(1