Microsoft SQL Server Forum

Need to get some Pervasive SQL or Btrieve data into a SQL Server database? For those needing to do so, we sell a very useful tool for Btrieve and Pervasive SQL Databases. Has an explorer type interface. Lets you browse and edit your Btrieve and Pervasive SQL database DDF and data files. Lets you see everything as it's native type or hex,...

Hi everybody, How can I Update a field from another table by Trigger? Can someone send me the statment to do it? I have a table called Clients with fields : ID_Clients, Client And Another called Doc with fields : ID_Doc, ID_Clients, Client These tables are in different databases and I would like to esure the integrity by add a Trigger...

I use Blanks in ColumnNames ( I know that this isn´t very good, but a lot of code and querys had to be changed if I would remove all blanks in all columnnames). When I link this tables with ODBC in my ACC97 - project, some of the tables causes an ODBC-Error. Are there possibilities to workaround this error? Thanks, Andreas Lauffer,...

Hi, Plz, I need some info (SQL2000) :) A stored procedure is like this: "Select table1.id, table1.txt, (select table2.nr from table2 where table2.fk_table1=table1.id) as nr where table1.id<>10" The essence here is that "select table2.nr from table2 where

After applying security patch MS03-031 (Sql server ver 8.00.818) a query that used to execute in under 2 seconds, now takes over 8 Minutes to complete. Any ideas on what the heck might be going on? I have tested this extensively and can say for certain that installing this hot fix is what has caused the performance problem. I just don't...

Hello - Anyone have any thoughts on which API to use - ADO or ODBC? I have a fat client written in C++ using MFC ODBC classes to access a Jet database. The app is going to be modified to write to a SQL Server central database with multiple users accessing their local copies of the database ( using replication technology on the clients...

Hi, The following parameter query resulted the error below. Is the following syntax correct? select * from branch where branch_code = ? COUNT field incorrect or syntax error

Hi, I'm using SQL Server 2000 MSDE on a laptop running Windows XP. I have a couple of SP's that that quite some time to compile. So I was wondering: is there any way to have the database *not* recompile them every time after a reboot? BOL says: "As a database is changed by such actions as adding indexes or changing data in indexed...

Hi, I am having an issue with SQL server that slows everything to a crawl, and makes almost any query impossible to complete. Here are the symptoms: I stop SQL, I start SQL. The task manager shows SQL starting up and quickly allocates 50 MB of memory. I then open SQL Manager and I can open up the instance of SQL Server and I expand to...

Hi, The application setup is: Access frontend + ODBC (TCP/IP) + MSSQL7 Few days ago i was informed that the app generates high network traffic. Thus i started to look for some savings. I found out (sniffer) that even if the client is idle every 30sek. a TCP packet comes from client to server, then answer goes back. The

Hello! I have a problem. I'm using a dataset in VB.NET with multiple tables with relations between them. I would like dataset to update to all related tables with right identity, when certain record is added. The problem is that I don't know how to do it, when I'm not using stored procedures. I found an article in which OnRowUpdated event...

Hi,, I'm having a problem with calling a function from an activex script within a data transformation. the function takes 6 inputs and returns a single output. My problem is that after trying all of the stuff on BOL I still can't get it to work. It's on the same database and I'm running sql 2000. when I try to call it I get an error...

In our database is a decimal field with format YYMMDDhhmmss.9999999999 where the 9s are random digits. I'm trying to strip off just the YYMMDD and put it in date form. So far I came up with: SUBSTR(TO_CHAR(rec_num,99999999999),1,6) AS Date which returns YMMDD. For example where the rec_num is 30608124143.47069519725 the above functions...

I have an entry form allowing customers to enter up to 15 skus (product id) at a time, so they can make a multiple order, instead of entering one sku, then submitting it, then returing to the form to submit the second one, and so forth. From time to time, the sku they enter will be wrong, or discontiued, so it will not submit an order. ...

How do you find the number of licenses that are installed on a SQL Server 2000?

How to encrypt a column in a table (i.e. which might contain passwords)?

Bonjour, Je viens d'installer SQL Server 2000 Dev edition. J'ai créé des connexions sécurisées SQL Server et pourtant lorsque j'essaie de me connecter avec PHP (mssql_connect('localhost', 'uselsC', '333')) j'obtiens cette erreur:

Hi, I have two tables in differents databases : Master database : ServerInformation where there is a table called "Clientes" and Table "Documentos" in the Database Index2003 What I need to do via Trigger is update the table "Documentos" in the field "Cliente" everytime the "Clientes" table change the field 'Cliente'.

Just a quick question about connection management. My application will never need more than 1 or 2 connections about at any given time. Also, I do not expect many users to be connected at any given time. For efficiency, I would like to keep connections alive throughout the lifetime of the objects requiring them, rather than opening a new...

Hi all, I have an invoice table query that returns 10 records. ie. there are 10 invoices. When I try to join a subjects table to retrieve the subject name associated with an invoice it returns 11 records. I know this is because for each invoice, there might be multiple subjects. So when I join the subject table to get the subject's name,...

Hello, I need help in writing a SQL statement in MS SQL Server 2000 to select the latest date (i.e., the date closest to or equal to the current date) for a given date. For example, in a table I have the following records: Date Exchange-Rate 01/Sep/03 0.55 05/Sep/03 0.59

I got help from Dan Guzman on how to set single-user-mode. Thank you very much. After seting single-user-mode, I run DBCC CHECKDB ('MYDATABASE',REPAIR_REBUILD) Tehre are error messages. How can I repair torn page problem? Thanks.

I need a query that will select the closest date. I have to tables Pricing and InventoryItem. tblInventoryItem InventoryItemID <- Pk Description tblPricing

use database db1; use database db2; use database db3; .... Duration for this example is 3 second, size of database db1, db2, db3 is 100MB each, Does anyone know how to speed up this !!! Win2000SP2, MSSQL 7.0 SP4

Hi I'm want to create OLEDB connection in Crystal Report 9 to Informix database using IBM Informix OLEDB Provider and got this error message. Logon failed