Archived Months
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
August 2008
all groups > sql server connect > august 2003 > threads for august 15 - 21, 2003

Filter by week: 1 2 3 4 5

Can't connect to a remote server?
Posted by Bruce W...1 at 8/21/2003 5:44:54 PM
I'm trying to connect to a remote SQL Server 2000, using TCP/IP at my web host company. I use the Client Utility to make an alias, then I register a new server in Enterprise Manager. The connection doesn't work and I know why, the wizard never asks me for the IP address! What am I missing he...more >>


Cannot open default database
Posted by Dwayne at 8/21/2003 4:35:22 PM
We have a datbase application that receives the following error: Cannot open default database '<ID>'. Using master database instead. This error happens inconsistently when accessing different parts of the database, and if you close the current screen and open it again you might not get...more >>

auto start service when OS starts
Posted by jim at 8/21/2003 4:19:38 PM
Is there a way to auto start sql service when OS starts w/out using sql server service manager? That is, via code. any help is appreciated jim...more >>

Memory just goes up and up and up...
Posted by george d lake at 8/21/2003 3:01:10 PM
Hi, I have SQL 2000 set to use 256MB to 400MB of RAM, but if I go to the Task Manager (win2K) I can see that sql is using 438MB or RAM and 438MB or Virtual Memory. The box was rebooted a few hours ago. How can I stop the memory getting so high? Thanks. ...more >>

Wait time increasing and users cannot edit records
Posted by Sarah at 8/21/2003 10:36:55 AM
I have an Access application that connects to a SQL Server database. Several times a day I get a situaion where one user seems to be able to lock up the database, and until they exit the application no one else can edit any records. When I check the proces information I see hat that user will ha...more >>

Posting from SQL to ASP.NET web page
Posted by Paul at 8/20/2003 12:10:03 PM
Hi all. Can anyone point me to some example code or a precompiled extended stored procedure that I can use so that an SQL trigger can call a web page ? Thanks ...more >>

Specified SQL server not found
Posted by Nurullah at 8/20/2003 9:21:53 AM
Hi, I have a client application written in VB, which is connecting to a SQL server 2000 database running on Windows 2000 server OS, using ADO. I am facing problem in connecting to the the database. The error i receive is "Specified SQL server no found". I restarted the SQL server. I am ...more >>

No Items in database tree
Posted by Eddie at 8/20/2003 8:10:40 AM
Hi I am trying to connect ti a database using em. The database tree shows 'no items' instead of the expected database tree. Any suggestions Eddie ...more >>



What does this mean? xpsql.cpp: Error 997 from GetProxyAccount on line 472
Posted by Pablo More at 8/20/2003 7:19:28 AM
Greetings, can someone please tell me what does this error mean? xpsql.cpp: Error 997 from GetProxyAccount on line 472 I tried searching the knowledgebase but found nothing. Thank you, Pablo...more >>

MSDTC start failed when start sql server
Posted by Scheng at 8/18/2003 4:49:57 AM
003-08-18 09:00:29.95 server Copyright (C) 1988-2002 Microsoft Corporation. 2003-08-18 09:00:29.95 server All rights reserved. 2003-08-18 09:00:29.95 server Server Process ID is 884. 2003-08-18 09:00:29.95 server Logging SQL Server messages in file 'G:\Program Files\Microsoft SQL ...more >>

Diagram..How to?
Posted by George at 8/15/2003 1:56:20 PM
Hi.. I'm somewhat new to SQL2K. Is there a way to take all the current user tables (58) and create a relationship diagram without to much manual work? I want to print this out and study our table structure. Thanks George .. ...more >>

cannot link a SQL2K named instance from SQL7
Posted by jlgervais at 8/15/2003 7:46:16 AM
From ServerA (SQL7 SP4) i can link ServerB (SQL2K SP3) no problem But when i try linking ServerB\Instance (SQL2K SP3), i get "Error6 : Specified SQL Server not found" any way to work around this ? Thanks...more >>


DevelopmentNow Blog