Hi Has anyone used the SQLHDTST.EXE utility before? if so, hae you come up with an error right in the beginning of the test? Error Text: App Screen Output: ==================================== The starting time is: 03/12/02 , 11:01:29 Process priority set to: NORMAL_PRIORITY_CLASS Creating simulated SQL Server device... Device "ftest.fil" created. File size: 512000 2kb pages, […]
2002-03-12
3 reads
I am trying to convert a series of processes currently using BCP, into Bulk Insert on a SQL7 server with SP1. However, I seem to be having issues trapping error conditions. The code below works fine if there are no errors, but if the file does not exist or the format of the file is […]
2002-03-11
3 reads
hi! im having a rather complicated query to be written There are 2 tables members and franchisee in two different databases which are in 2 different locations.It is not possible to copy the tables to a common database. I have the following problems 1)How to do a join on the 2 tables? 2)i need to […]
2002-03-09
Normally I use identity columns for indexes (if no integer candidate keys are available), but in this case, I am very much in doubt. We need a currency table for a project. This will contain the ISO code for the currency and a name. The other DBA wants to use an Identity PK, I imagine […]
2002-03-08
132 reads
I'm running a SQL 6.5 server with SP5a. We are getting the message "NO READ AHEAD SLOTS AVAILABLE. RUN SP_CONFIGURE TO INCREASE THE NUMBER OF SLOTS". Does anyone know what this message means and/or what might be causing it? All I've been able to find in MicroSoft's documentation is that the read ahead slots configuration […]
2002-03-05
1 reads
I have a major situation.....Is there a way to recover data from db that was not backed_up? Edited by - ayisat on 03/04/2002 4:57:18 PM Edited by - ayisat on 03/04/2002 4:58:24 PM
2002-03-04
Hi, Does anyone have a nices SQL script/SP which gives the total disk space a table and its indexes takes up? TIA Rob
2002-03-04
I heard (from a guy at MS) that the DTS packages when run will only run about 4 operations in parallel. There is a tweak that can be used to increase this. I was wondering if anyone can tell me what it is. Thanks.
2002-03-03
2 reads
Please can anyone help ? I'm over in USA. I've got USA VB apps talking to USA SQL SERVER 2000 database. I need to bring this back to England and demo over there - however, when setting the computer's regional settings to British UK from English(American), I get: out-of-range datetime value Microsoft OLE DB Provider […]
2002-03-01
2 reads
I have a DTS that I can execute manually. It extracts data from SQL01 server to SQL02 server. However, when I try to run this job automatically by scheduling the DTS or Start Job it produces the following error: DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_11 DTSRun OnStart: DTSStep_DTSDataPumpTask_12 DTSRun OnStart: DTSStep_DTSDataPumpTask_13 DTSRun OnError: […]
2002-03-01
6 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers