I have table A and populate table B with table A but before I do that I
need to compare records in between those two tables....
       If there are new records on table A, I need to insert it into
newTable and if there are records that has changed then I need to insert

Data Link Properties, open by test.udl file, when open don't show any
istance of MSDE sp3 installed.
By Visual Studio.NET 2003 Server Manager I can see the server and database.
If I insert manually name istance and try test connect it return me this

I could sure use some help.
I'm running Sql Server 2000 on a windows 2003 server using windows
authentication only. I can successfully run the following opendatasource
sproc from query analyzer on the windows 2003 server, however when I try to

There are 2 SQL databases involved and an MS Access program.... also using
windows authentication...
The Ms Access program executes a stored procedure that resides in SQL
database#1, the stored procedure updates data in SQL dataabase#2..

the error string is as follow:
"The text, ntext, and image data types cannot be compared or sorted, except
when using IS NULL or LIKE operator."

HI, i am a newbie of SQL server.
What I got is an error shown as the title in which an ASP file made the SQL
call.
The script is just as follow:

I have successfuly link Exchange to my sql server...what i
am trying to do is fetch all the data of the Exchange and
archive it to an SQL database... my question is it
possible when i got all the information from exchange and

I'm opening an ADODB connection to an SQL database in VB6 using the
adModeShareExclusive mode for the connection object.  The connection opens
successfully, but I'm still able to modify records in the database using
Enterprise Manager.  Why is this?  I want to open the SQL ...

Hi,
My company is running:
SQL Server 2000 SP3 on Windows 2000 Advanced Server SP4
System Config:

SQL Server 2000 standard, sp3
Win2K Adv. Server, SP4
CLients are XP SP1, WIn2k Pro
Server has two named instances, no default.

Here is my problem:
I have a sqlserver SQLA which I have registered in EM with a sqlserver
authentication with a uid and password and that connection works fine. The
problem is that when I look at the security log of SQLA, i see continuous

I have a asp.net and SQL 2000 db ecommerce site template I purchased. I
installed the database via running a script in QA and have connected to the
DB through QA and EM with no problems. However, when I try connecting via a
Connection String I get the error "The ConnectionString ...

I am unable to get xp_fileexist to view files on a SAMBA-mounted Unix/Linux
share using SQL 2000. I have successfully mounted the drive as a mapped drive
on the SQL server. I am using UNC to reference the share.
Is this possible? Am I missing a network or security setup ...

I have a stored proc on a server called lax-dd and the
stored proc name is test.  Both servers are in the same
domain and the sa passwords are the same on both servers.
I in query analyzer run exec lax-dd.dbname.dbo.test.

A quick question from an SQL novice trying to debug problems of connection
link failures between client and server.  Here is the scenario:
- application opens connection from client to SQL server
- lots of intermittent activity between client and server (connection to