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.

I'd go with the solution from GSquared; it will work for you and it's easy to understand.

Test is on another db first, be sure it clears up what you...

MSDE is the free version, but doesn't include all the functions. If you have a license for SQL 2000 at your company, you can install Personal edition, but you will...

Validation and calculations looking from one XLS to the other can cause problems as you scale it. It works, but it isn't designed for lots of users.

Excel can do a...

http://www.sqlservercentral.com/articles/Miscellaneous/2996/

When you run the script, it will appear.

The script has calls to sp_create_job, etc. that is exactly the same things run by SSMS when you build the job in the...

1. yes, connection strings need to change if they are not using trusted connections.

2. you can't. the Sa account cannot be used as that is for SQL authentication only. You...

The code is re-entrant. Both can run together.