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...

For what reason?

Krishna_DBA (12/21/2008)

---

I think you should delete your post for further newbies that they will not get to know about this link and also as Gail said this forum which...

Those are all copyrighted materials, and hence it is illegal to freely distribute...

Meaningless marketing drivel. I doubt the people who though that up even...

Not possible without recreating the table completely, which is what Management Studio does.

Why do you need the columns in a specific position? Technically, column order has no meaning in SQL....

Krishna_DBA (12/21/2008)

---

Yes, using Testking, Pass4sure are brain dumps and it is not advisable to go through them unless you are confident that you have practiced a lot and grasped the...