Viewing 15 posts - 39,766 through 39,780 (of 39,899 total)
I am split here.
I think change control is critical and dev people (DBAs, programmers, etc) should not change production. I know someone has to wear both hats (I know I...
September 6, 2001 at 10:46 am
The best solution, IMHO, is to use one of the commercially available and readily known encrpytion algorithms. They biggest part of the encryption is the key. Keep in mind that...
September 5, 2001 at 10:31 am
I've had a sproc that will decrypt SPs, triggers, views, etc.
It is a deterrent, but not follproof. A good DBA and compentent Internet snooper will crack the code.
Steve Jones
September 5, 2001 at 10:29 am
September 5, 2001 at 10:25 am
this is (theoretically) correct. The way backups work, is that once you start, you want a backup of every page in it's state when the backup STARTS. This way you...
September 5, 2001 at 10:23 am
Have you changed any security settings within SQL Server?
Do SQLServer and SQL Agent run under the same account?
Steve Jones
September 5, 2001 at 10:15 am
Can you use SMTP and have Exchange forward to Lotus? If you can get Exchange to forward, that is the best solution.
Check out this article:
You can use Lotus, but it...
September 5, 2001 at 10:08 am
September 5, 2001 at 10:01 am
In v6.5, sysobjects in tempdb would get locked and cause problems. This is les problematic in v7/2000, but you should still avoid this if there is another way to rewrite...
September 5, 2001 at 10:00 am
BE sure you have the proper spacing included in your strings. Looks like you are missing a space. Try a response.write(strCriteria) and see what is returned. Be sure this is...
September 5, 2001 at 9:58 am
September 5, 2001 at 9:54 am
I work like Brian. One backup only locally and then 2 days remotely.
The remote backups are on tape within 20 minutes of being copied.
I use FTP because it is the...
September 4, 2001 at 11:57 am
One more things:
Keep the Server patched, but test the patches elsewhere. Most downtime will come from poor QA and poor change control.
Steve Jones
September 4, 2001 at 11:54 am
Backup (full, log, diff) as often as you can. I backup locally and then immedaitely copy to a remote drive. Let the tape grab it from the remote drive. Of...
September 4, 2001 at 11:53 am
Instead of letting a user run sp_start_job, let another job do it. Let the user insert a row in a table and then have a job run every minute or...
September 4, 2001 at 11:44 am
Viewing 15 posts - 39,766 through 39,780 (of 39,899 total)