Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MikeBronner

    General SQL Error

    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...
  2. MikeBronner

    General SQL Error

    ...SCHEMA CACHE FALSE SCHEMA CACHE DIR ENABLE BCD FALSE ROWSET SIZE 20 BLOBS TO CACHE 64 DB INFO TYPE Microsoft Access Driver (*.mdb) PATH Excel Files DB OPEN DATABASE NAME USER NAME ODBC DSN Excel Files OPEN MODE READ/WRITE SCHEMA CACHE SIZE 8 SQLQRYMODE...
  3. MikeBronner

    General SQL Error

    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
  4. MikeBronner

    General SQL Error

    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...
  5. MikeBronner

    General SQL Error

    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...
  6. MikeBronner

    General SQL Error

    ...by the actions we tool to attempt to resolve it: General SQL error. Native SQL error: 10025 Context: SQLQuery: GM_GMBase: set rowcount 1 SELECT * FROM dbo.CAL (NOLOCK) WHERE ALARMFLAG = 'Y' AND USERID = 'PKHANDJI' AND (ALARMDATE <= '01/28/2008') ORDER BY ALARMFLAG ASC, USERID ASC...
  7. MikeBronner

    Unable to run Pull Subscription

    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...
  8. MikeBronner

    Unable to run Pull Subscription

    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
  9. MikeBronner

    Unable to run Pull Subscription

    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
  10. MikeBronner

    Unable to run Pull Subscription

    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
  11. MikeBronner

    Unable to run Pull Subscription

    Yes, this is the one. Take Care, Mike
  12. MikeBronner

    Unable to run Pull Subscription

    ...filtrar por @PK (-1 no hace filtro) @strVALOR AS VARCHAR(10) -- Valor para filtrar por @PK ('-1' no hace filtro) AS ---------------------- -- * COMENTARIOS * -- ---------------------- -- El que no haya homogeneidad en cuanto a los campos clave de las tablas según el tipo y -- tamaño...
  13. MikeBronner

    Unable to run Pull Subscription

    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]...
  14. MikeBronner

    Unable to run Pull Subscription

    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
  15. MikeBronner

    VS2005 - Report Designer - System.OutOfMemoryException

    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...
  16. MikeBronner

    Merge many TEXT results into one TEXT field?

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

    Merge many TEXT results into one TEXT field?

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

    Merge many TEXT results into one TEXT field?

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

    Merge many TEXT results into one TEXT field?

    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
  20. MikeBronner

    Merge many TEXT results into one TEXT field?

    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 =...

Part and Inventory Search

Back
Top