So you've got the SQL service stopped, you've got one command window where you ran sqlservr.exe -m and left it running, and another command window where you're trying to connect...

If there was corruption of any form the query would not run forever. It would fail with an error,...

Is it blocked? Is it wating for a resource, if so what's the wait type and wait resource?

How many rows out of the 700000...

CREATE TYPE EDI

EXTERNAL NAME EDI.[PointlessClrTypes.EDI] ;

How many rows will that return?

Why?

There are no errors there. That's SQL's startup messages. You need to connect to SQL from another command window, using sQLCMD and restore the database.

Does the restore database give...

ps (12/22/2008)

---

You can do as Gail suggested OR you can build a DLL with your encryption/decryption logic and add it to ur SQL Server as extended stored proc and use...

They are SQL reserved words. Hence management studio highlights them as such.

Read the manual? What a radical, way out idea!

Your screen shot is too compressed to be readable. Please copy the error from the command prompt and paste it in a reply.

30 sec is still a long time for a query to run, unless it's some massive report. I don't know many users who will be happy waiting 30 sec or...

SQL 2000 doesn't have any native encryption functions. If upgrading to 2005 is not an option, you'll have to do the encryption and decryption in the front end app.

That means that the number of columns in the table don't match the number of values in the insert. What's the definition of the Log table?

In general, it it recommended...

Spatial, xml, hierarchy, etc. The 'rich' data types that some bright spark in marketing thought meant SQL was evolving beyond a relational database. I'd...