Search results for query: *

Thanks for the info on the SQL version. I have the SELECT as you described with the following result: Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) So...

BDE Version: 5.01 SQL Server Protocols have both Named Pipes and TCP/IP. I have saved the BDE config file and pasted the content here:  SYSTEM FORMATS DATE SEPARATOR / MODE 0 FOURDIGITYEAR FALSE YEARBIASED TRUE LEADINGZEROM FALSE LEADINGZEROD FALSE NUMBER DECIMALSEPARATOR...

Sorry, I need to clarify on the SQL client tools installed on the workstations: We DO have the client tools installed: SQL Server 2000 Client tools with SP4. Take Care, Mike

Our specs are: Goldmine SQL Server Version: 8.0.194 (SP4) Workstation SQL Client: None, we run Goldmine off the server install (on db server). Protocols / ports: Runs on the db server (local). Server OS: Windows NT 5.2 Build 3790 (Windows 2003 SP1) Thanks for taking the time to help on this...

Thanks for the reply. We run database maintenance on a nightly basis, which does a backup, shrinks the logs, and checks the integrity. Additionally, I have run many DBCC tests of my own on the various tables that the Goldmine errors list. (Un?)Fortunately they don't report any issues. However...

Hi All, We have been experiencing this problem for many years now, and even calls to Frontrange tech support didn't result in any lasting results. I'll show the error, followed by the actions we tool to attempt to resolve it: General SQL error. Native SQL error: 10025 Context: SQLQuery...

Thanks so much for your help! You pointed me in the right direction. The actual problem is not with the database settings, but the developers of the database. There are only two "rogue" stored procedures that use the double-quotes (erroneously). I am assuming these are unused stored procedures...

Following this thought through, I should theoretically then turn QUOTED_IDENTIFIER off in the replication scripts. Is there any way to do that? I have not see a flag that enables this setting under the various replication areas. Take Care, Mike

Looking at this article (http://doc.ddart.net/mssql/sql70/set-set_30.htm), it seems that QUOTED_IDENTIFIERS should be turned off, as otherwise the quoted text will be interpreted as a database object (i.e. column or table). Take Care, Mike

Sorry for the confusion. The last post with code (above) is the actual script. The file name is TabAux_Traducciones_441.sch. Take Care, Mike

Yes, this is the one. Take Care, Mike

HI mrdenny, Thanks for your response. The next file in the sequence seems to be TabAux_Traducciones, and it has the following code: SET QUOTED_IDENTIFIER ON GO drop procedure [TabAux_Traducciones] GO CREATE PROCEDURE [TabAux_Traducciones] @TABLA AS VARCHAR(50), -- Nombre de la tabla de...

As a follow-up: the error references HD_Problemas_Productos_437.sch. Here's the content of that script: SET QUOTED_IDENTIFIER ON GO drop table [HD_Problemas_Productos] GO SET ANSI_PADDING OFF GO CREATE TABLE [HD_Problemas_Productos] ( [IdProblemaProducto] [int] NOT NULL , [IdProblema] [int]...

Hi All, I have set up a pull subscription, but everytime I run it, I receive the following error (I have captured this to an output file): I have been absolutely unable to find any help googling the error. Does anyone have any ideas? Thanks! Take Care, Mike

Hi All, I am developing some reports in VS2005 in a Reporting Service project using the integrated report designer. The query runs just fine in the data tab and returns about 5000 rows. However, when I run the report in the preview tab, set my applicable report parameters (which should further...

*bump* This hasn't been tried before? Take Care, Mike

The above should read: How do I update ... Take Care, Mike

Yes, thanks sweth. I have that part figured out. How do I the one pointer with results from multiple records, though? Take Care, Mike

Yes, but how to I append the multiple TEXT field resulting from the join condition (one-to-many) in the single TEXT field? Take Care, Mike

Hey All! I've been reading up on the UPDATETEXT functionality, and it seems like a step in the right direction, however: I am unable to find any examples that update text fields based on query results. I'm looking for something like this: UPDATE target_table SET target_field =...