I have a windows setup program (framework 1.1), this setup
program calls one util.exe with parameters. util.exe opens the connection
(SQL Server 2000, windows authentication only)  and does some db updations.
when i run thru setup exe fails throwing

Is there a way to extract information from the SQL Server logs about stored
procedure calls, triggers, etc. after they run? I'm trying to "reverse
engineer" and application I inherited. My plan is to run the application,
then look at the logs and see what it did under the covers.

I'm tring to insert a large data to image fields.
It is an Update query of 2 image fields in the same table.
The problem occurs when the data length of the second
field is more than 400K.

I get the following error when I try to do a query accross
a linked server. I am trying a select * from [server
name].master.dbo.sysobjects.
Server: Msg 7399, Level 16, State 1, Line 1

I am trying to read the results from a query like
select a, b
from mytbl
where col0 = ?

I have a need, unfortunately, to use a subselect as part of an IN clause
in a WHERE statement.  The subselect contains a parameter that must be
bound with SQLBindParameter.
However, when I run the code that binds the parameter I get an ODBC error:

Is there any file that shows every transaction log during
work on SQL 2000
regards,

Is Windows CE the correct choice for developing an
application which will be used on a laptop type of device
while disconnected from the main database (SQL Server
2000 Ent. Ed.) but when connection is available will

I need to change the computer name on my Windows Server 2003.  I am currently
running SQl Server, and I am trying to find out if changing the name will
affect the SQL server or not.  Is there a process for doing this, or if I
change the name and reboot, will the name ...

I am using DAO 3.6 to connect to a SQL Server db on a remote machine.
I can open and close the connection, read records, run stored procedures
but when I try to add a record I get "object or database is read only"
If I connect to the database using ADO I can add records.

How can I see the actual ( or can I ) SQL code when
embedded sql is used with a jdbc driver.  all that I see
is something like:
exec sp_execute 24138, 'ACQUIRED', '8988', 'Load Files'  

I'm totally new to sql server - 4 hours!
I have SQL 2000 server on a Windows 2003 Server.  My client computer is XP
SP2.  I have installed the client tools on my xp system, but now what?
Thanks.

I'm  looking to build an application that will get data
from an HR system (built in Visual FoxPro 7.0), import it
into SQL Server, and process it there. I'm trying to
figure out what the best approach to doing this would be.

Hi ...
I am having to switch from Access queries to Access pass-
through queries because the SQL Server 2000 tables are
getting too large (I connect to SQL Server with Access -

I have a Server with SBS 2003, Exchange 2003, SQL 2000 and Outlook 2003 all
with current service packs.  I am having a problem with SQL Mail. The problem
is the mail profile is grayed out in SQLServerAgent and I do not know why.
I created a mail profile on the server in exchange ...