Viewing 15 posts - 39,346 through 39,360 (of 39,466 total)
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
August 22, 2001 at 2:23 pm
August 22, 2001 at 2:22 pm
Not that I know of. These are encrypted with the understanding that they will never be decrypted.
Steve Jones
August 20, 2001 at 12:17 pm
I think you need to monitor the page splitting. When you have the low fillfactor, if the insert occurs in the middle, then there can be a performance issue due...
August 20, 2001 at 12:13 pm
You need to change the server name in SQL.
Use sp_dropserver, sp_addserver with the LOCAL option.
Steve Jones
August 20, 2001 at 12:09 pm
Viewing 15 posts - 39,346 through 39,360 (of 39,466 total)