all groups > sql server clients > january 2004 > threads for january 29 - 31, 2004
Filter by week: 1 2 3 4 5
SQL Server 2000 CE Edition Problem
Posted by Derek at 1/30/2004 4:31:14 PM
Hi,
I have install the SQL Server 2k Eval version on a Win2K computer and update
to SP3.
the computer also running the IIS too.
When I install the server tools of SQL Server 2000 CE Edition, I got the
following error message:-
"SQL Serve CE Server Tools is compatible only with SQL Server 20... more >>
isql generates "error: insufficient memory to continue"
Posted by Paul at 1/30/2004 3:16:09 PM
When I launch a big script (~30mb) with the isql or osql command-line utility, I get this error. There are go statements every 100 statements and I have plany of available memory on my machine. Does anyone know what could be causing this or have a solution
Thanks in advance
Pau
parmitage@lgc.c... more >>
error 547
Posted by VA at 1/30/2004 12:31:20 PM
I got an error 547 INSERT statement conflicted with TABLE
FOREIGN KEY constraint. Please let me know how to resolve
this issue.
... more >>
ASP Connection
Posted by Eduardo Gamboa at 1/30/2004 10:13:59 AM
Hi,
I have a SQL Server 2000 and an ASP that execute a stored procedure. It
works fine for a moment, then it suddenly stop working.
The ASP reports "Timeout Expired", but from another application developed in
delphi and from the sql query analyzer I can execute the SP.
I have to restart the... more >>
Which one is optimized
Posted by Noorali Issani at 1/29/2004 6:29:16 PM
I just wanna know that which one query is more optimized one....
1)
select COUNT(*) from patient a where NOT exists (
select PP_VPatientID
FROM PatientPersonnel b
where b.PP_VPatientID = a.PA_VPatientID)
2)
select COUNT(*) from patient where PA_VPatientID NOT IN (
select... more >>
run SQL scripts from DOS
Posted by Laurentiu at 1/29/2004 4:49:04 PM
How can I execute a SQL script from DOS?
... more >>
Connection could not be established in accessing SQL Server from Client Computer
Posted by Lans at 1/29/2004 1:26:11 AM
Hi All
I have installed a SQL Server Client Standard Edition. I am trying to establish a connection using the Enterprise Manager in accessing the SQL Servers of our company. The error message that was displayed is
A Connection could not be established to <server name>
Reason: Invalid attribute... more >>
|