Microsoft SQL Server Forum

Hi, I am currently working on a VBA project that links to a SQL Server 7.0 database using a connection string. When I use a SQL user account in the connection string, everything works fine. However, when I use a SQL user account with NT authentication , the login attempt fails every time. I have checked all the individual settings for each...

Hi- Is it possible to do a trusted connection for a web server not on the same physical machine. By this I mean can I make a remote connection from a web server to a sql server using a trusted connection. If so, how? Thanks, Dave

When I try to connect to a MS Access 2000 database in enterprise Manager , i get an error "Login failed - Catalog information cannot be retrieved". I get this error message in a dialog box about 5 or 6 times. The

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

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

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

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.

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

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

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, 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'.

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:

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

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

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

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

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, 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

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

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

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

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