That's what I was going to post 🙂

Basically a lookup. Find the hash, look up the possible plaintext(s)

I like the car analogy!

And I hope they don't start charging more for SQL without Windows, but I wouldn't be surprised.

SQL 2005 Express is a database engine, not a management tool.

SSMS would be used in either case to "manage" the database.

The temptable approach (or table var) is what I've done in the past.

You can use TVF's, as Flo suggested, if you can rewrite the code.

It depends, and that's the best answer. It's how you use the keywords, not the keywords.

I'd say that you ought to engage someone to help you tune things if you...

I'm sure there's a use, but not a common one. Certainly I didn't quite get it.

I think half the questions we ask sometimes are trivia, or tightly focused, but it's...

Manage your online presence. It can help you, and it isn't that much work.

Employers not seeing what you've done online? I disagree. Don't post if you don't want it to...

I'm not sure that I agree with size as a good measure of skill. I think size comes into play if a company has large databases and needs someone to...

Log in with the current service account, and then try to access the share. If that works, you're one thing down.

Can you run the backup command interactively in SSMS/SQLCMD?

If...

Nice feedback.

FYI on replying, there's a "last 10 posts" section below the reply window. Open it by clicking the + on the right.

First, it doesn't matter what the job is run under, or what Agent runs under. Just like when you connect to SQL Server, it's not your credentials used for the...

Arup has updated the content and I have replaced this content with the updates.

The hash should be one way. I'm not going to commit that it cannot be decrypted, especially if the length is known. There are rainbow tables to help here, but...

This says NTFS: http://msdn.microsoft.com/en-us/library/bb933993.aspx

Don't attach. Shut down SQL and copy files

http://weblogs.sqlteam.com/mladenp/archive/2007/03/12/60132.aspx