Viewing 15 posts - 39,586 through 39,600 (of 39,716 total)
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
Why do you want to do this? (curious). You can't join the tables. Even a linked server requires the FQname. Easiest way is to build views on the tables using...
August 27, 2001 at 11:37 am
The easiest method might be a linked table in Access. I've used this before. Setup a login specifically for the tables, then link a table in Access and send the...
August 27, 2001 at 11:36 am
MS reserves the right to alter "system tables" during upgrades or even service packs. I have built processes in the past that used system tables and when upgrading, my solutions...
August 23, 2001 at 2:19 pm
Viewing 15 posts - 39,586 through 39,600 (of 39,716 total)