Archived Months
March 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
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 >>



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 >>


DevelopmentNow Blog