Viewing 15 posts - 39,331 through 39,345 (of 39,456 total)
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
Can you upload into a temp table and then do a join to insert into the real table?
Steve Jones
August 23, 2001 at 10:46 am
August 23, 2001 at 10:45 am
If this is SQL 2000, you probably want the dynamic properties task. You can use teh results of a query to alter the data xfr task.
Steve Jones
August 22, 2001 at 10:11 pm
That will work, but uses system tables (unsupported). I'd try to avoid that if possible.
Steve Jones
August 22, 2001 at 4:41 pm
There is no stored proc, but the output of exec sp_who2 contains a lastbatch column. This is the last date/time when a batch (or command) was executed by the column....
August 22, 2001 at 2:33 pm
Viewing 15 posts - 39,331 through 39,345 (of 39,456 total)