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

You'd have to search code in other dbs for the 3 or 4 part naming against that db. There isn't anything tracking this as a db should be a self-contained...

Well, I do #2 to build a bond. I think there's more to the interview than technical knowledge. But cap it, don't do it too much, or you're wasting time....

I'd be sure that you are running 2005 code and are in compat mode 90.

However from there what you might want to do is refactor code where you can to...

Absolutely it counts. I interview the company as much as they interview me. The more talented the candidate, the more important it is for the interviewer to do a good...

Are you talking upgrading from SQL 7/2000 to 2005? Or 32bit to 64?

The default trace should be available if that wasn't what you checked.

Otherwise, not sure you can find this. You can use a DDL trigger, like ALZDBA mentioned, to prevent this...

Nice to see an apology though.