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.

I agree with Brian. You typically want to hash the password, then when the user enters his password, you hash it and compare the hashes. If they match, the correct...

This should give you an idea of how to set an alert

http://www.databasejournal.com/features/mssql/article.php/1498781/SQL-Server-Agent---Creating-Performance-Condition-Alerts-on-Database-Server-Objects.htm

To allow a Windows user access to a database, you need to add a user, then map that user to the login you added.

You can, and should, read this section...

Rows or columns?

You don't know about the table or the XML? I'm confused.

If you perform log backups, the log space is reused. Whatever is backed up is marked as such, and that space is reused. If you don't do log backups (and...

Added my vote. Did you try to alter the mirror db first?

I'm hoping that suggestion was a joke.

There are plenty of Americans getting jobs and posting on this site because they don't understand what they're doing.

My comment was that an Indian...

Implement some logging. I wonder if you have a rights issue.

I'd add a step that sends data to another table to be sure it's actually running.