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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|