Viewing 15 posts - 22,591 through 22,605 (of 39,824 total)
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...
August 25, 2009 at 7:22 am
This should give you an idea of how to set an alert
August 25, 2009 at 7:21 am
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...
August 25, 2009 at 7:14 am
Rows or columns?
You don't know about the table or the XML? I'm confused.
August 24, 2009 at 11:02 am
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...
August 24, 2009 at 11:01 am
Added my vote. Did you try to alter the mirror db first?
August 24, 2009 at 9:28 am
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...
August 24, 2009 at 9:16 am
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.
August 24, 2009 at 8:59 am
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...
August 24, 2009 at 8:58 am
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...
August 24, 2009 at 8:57 am
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...
August 24, 2009 at 8:56 am
August 24, 2009 at 8:55 am
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...
August 24, 2009 at 8:50 am
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...
August 24, 2009 at 8:43 am
The code is re-entrant. Both can run together.
August 24, 2009 at 8:42 am
Viewing 15 posts - 22,591 through 22,605 (of 39,824 total)