Search results for query: *

How do I reindex DBASE III/IV specific table from a command prompt?

I have a weird problem, I have created a linked server to a Dbase database. It works perfectly from SQL Server A, but not from SQL Server B. On SQL Server B, I am getting this error: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData (CheckforData()). Server: Msg 11, Level...

The Storeprocedure works fine in SQL 2000, but not in SQL 2005. I am getting the error: Invalid column name '19' when running the Storeprocedure. However, if I just run this as query it works fine (on both 2005 and 2000). Once it is a store procedure, and I call for example dbo.testprocedure...

Have a valid certificate and correct DNS entries, but getting this error id: 1019 When contacting https://..... /autdiscover/autodiscover.xml receive the error the underlying connection was closed. An unexpected errored on a send. And then on the next row: xml received the error authentication...

Getting this error when creating a DTS PACKAGE that has a data driven query task. ActiveX scripting requires script TEXT AND LAGNUAGE AND AT LEAST ONE PHASE FUNCTION TO BE SPECIFIED INSERT INTO TEST (aa, ba,ca) VALUES (?, ?, ?)

We have bought CAL Enterprise licenses for Exchange 2007 server via MS Open License program. The licenses have been activated on the MS Eopen website and everything looks OK. The question how do we make our Exchange Server (Standard) 2007 recognize these CAL Enterprise licenses. I have been told...

How do I create a linked server to a DBASE database. I have the ODBCD connection set up. Does anyone have an example?

Trying to insert data from SQL to Dbase using DTS. The problem is that I have it just "cloning" the data, only inserting data where the record already exists (so I end up having two record in the Dbase table), and it is ignoring any new records that exists in the SQL table. Obviously I need an...

Getting error converting to float when comparing (greater than) two values although both values are float. I have even tried to convert to values to float, and still getting the error (see down at the bottom). CREATE PROCEDURE dbo.SetNTP as SET QUOTED_IDENTIFIER OFF declare @SQL...

I have a program where the user can modify a user query, but how do I validate (in SQL) that the query is OK??

I have the above statement in a where clause, but it doesn't work. The accountinfo.NTP is an INT value and has the value of 4, and Y.CALLNUM is a calculated value (COUNT) and has the value of 1. So if 4 is greater than 1 how come it doesn't recognize it?? I tried everything. It works if I remove...