all groups > sql server clients > october 2003 > threads for october 29 - 31, 2003
Filter by week: 1 2 3 4 5
Why my client query occurs Access Violate frequently?
Posted by Ò»·É at 10/31/2003 11:16:58 PM
Cannot start more transactions on this session
Posted by CB at 10/30/2003 1:29:00 PM
A user received this message (subject line) while trying
to add a record to one table in a SQL Server 2000 database
accessed through VB 6 and ADO. The application was the
only one on his machine running against the database. The
Microsoft Knowledge Base has an article (316782) but it is
fo... more >>
ADO Error Help
Posted by Darren at 10/30/2003 12:59:18 PM
I have a tAdoConnection setup up to connect to a SQL Server 2k db. When
trying to connect i get the following error intermittently, but quite often.
[DBNETLIB][ConnectionRead(recv()).]General network error.
If I retry a few times then it will eventually connect. Like I said, it is
very unpre... more >>
MMC Viewing Database Tables
Posted by Suzanne at 10/30/2003 12:15:20 PM
I've been using Sql Server 7.0 and managing several
databases using the MMC for 3+ years.
About two weeks ago I lost the capability to view only
the tables for only one database.
Has anyone seen this? How do I correct this problem?... more >>
vb interface
Posted by Bob at 10/30/2003 9:17:33 AM
How do I update multiple tables in a sql database through
a VB interface. None of the table are updated when the
update button is pressed in VB interface.... more >>
Parameterised query error
Posted by Angeliki at 10/30/2003 5:54:38 AM
Hello.
I am trying to run the following query:
select t.orgname,s.descr,
sum(CASE WHEN cast((wl.durwaitmnt/30)as smallint)
<= 3 THEN 1 ELSE 0 END) "0 to < 3 months",
sum(CASE WHEN cast((wl.durwaitmnt/30)as smallint)
> 3 AND cast((wl.durwaitmnt/30)as smallint) <= 6 THEN 1
ELSE 0 END) ... more >>
SQL CAL
Posted by Lancer at 10/30/2003 3:39:08 AM
Hi,
Thanks for viewing my post? May i know...
If i'm using per-seat mode running with windows 2000
Advanced Server, now i am setting up a SQL server for
Development purpose, am i need to buy the SQL CAL for
those computer access to SQL Server?
Thanks for your answer.... more >>
Enterprise Manager
Posted by Bret Wilcock at 10/30/2003 3:13:39 AM
Hi
HAve installed SQL Server 2000 (Personal) and SP3a, but
still get the problem with Enterpise Manager and Query
Analzer reported in number BUG #: 351147 (SHILOH).
Can anyone advise what I may have missed out.
Many Thanks
Bret... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Starting MSDTC from Command Promt
Posted by Jai Shanker at 10/29/2003 10:38:55 PM
Hello,
I wish To start the Distributed Transaction Coordinator of
the SqlServer on Win 98/2000. Can I do it through a
command promt?
Regards
Jai... more >>
Starting MSDTC Service
Posted by jai Shanker at 10/29/2003 10:37:32 PM
Hello,
I wish To start the Distributed Transaction Coordinator of
the SqlServer on Win 98/2000. Can I do it through a
command promt?
Regards
Jai... more >>
SQL 7 query errors from dotnet but works from Query Analyzer
Posted by David P. at 10/29/2003 2:02:51 PM
We are running a query from a dotnet 1.1 client which is
working fine on SQL 2000 but times out on SQL 7. The
query does work on SQL 7 when using Query Analyzer 2000.
With the dotnet app the connection times out (a trace
shows the query finished). If we use Query Analyzer 7
(sp 4) the f... more >>
Unknown Error
Posted by Prade at 10/29/2003 6:32:58 AM
Hai,
I installed SQL Client 2000 i am able to connect to
database server, When i try to view a table on databse i
am getting an error message saying that "Unknown Error"
with a heding Sql Server Enterprises Manger, can some one
help to resolve this problem
... more >>
|