|
|
|
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 |
Filter by week: 1 2 3 4 5 How to display the command text when a long transaction is on proc Posted by Jason Zhang at 9/14/2005 9:23:02 PM One connection is using a few store proc to do some transactions. It takes a
long time to complete. I want to know if it's possible to show the particular
SQL statement when the connection is running, e.g. the statement "select *
from staff" is bottleneck as it consumes the most effort.
Th...more >>
SQL Server not found or access denied Posted by Olav at 9/14/2005 10:44:07 AM We get this meesage if we try to connect to the database from a client
computer. It works fine if we connect locally on the 2003 server.
The MSDE was installed from another maker and we have changed it to use
mixed mode. We log on using SQL server auth.
We have used svrnetcn.exe and added TCP/...more >>
Event ID: 17830?? Posted by Mike at 9/14/2005 7:23:14 AM All,
Can't figure out why I am getting this message in my event log...
Event Type: Error
Event Source: MSSQL$SQLSERVER2005
Event Category: (4)
Event ID: 17830
Date: 9/14/2005
Time: 7:06:03 AM
User: N/A
Computer: ADDVMFM12
Description:
A network error occurred while establishing a con...more >>
SQL connectivity issue only from one server to another Posted by mzamborini NO[at]SPAM gmail.com at 9/13/2005 10:36:29 AM Hello
I am having a SQL connectivity issue (Query Analyzer or Enterprise
Manager connection) - from specifically one server to another. Lets
just call them ServerA and ServerB. I cannot connect from ServerA to
ServerB in either QA or EM. BUT, I can be on any other SQL server box
and connec...more >>
connection failed... not associated with a trusted SQL Server connection Posted by keithb at 9/13/2005 9:48:40 AM Using Query Analyser, I cannot log in using the SQL 'sa' user name and
password. I get an error saying "connection failed... not associated with a
trusted SQL Server connection" When and where can the 'sa' credential be
used without creating this error?
thanks,
Keith
...more >>
insert temp with linked server Posted by dp at 9/13/2005 9:44:25 AM
Hi,
I have a problem with insert temp table with linked server. I have a sql
2000 with sp4 and I have a dozen linked servers. All of them work except one
which is running on windows 2003. I didn't get any error message and the
transaction just open and never stop. I have to kill it manual...more >>
Can't connect after change the security setting Posted by luvgreen at 9/13/2005 7:13:04 AM Hi, Experts! I very new to SQL server. I made a stupid movement by mistakenly
change the security of property of local(windows NT) from log in using this
account to system account. After the machine restarted, i can't no longer
start up SQL server. When I click local (window NT) in enterprise...more >>
[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found. Posted by SiJP at 9/13/2005 4:44:36 AM I am trying to connect to a SQL server that is on a remote network,
using Enterprise Manager. However, I am getting server not found
errors.
Here is my setup:
My PC, connects to the internet via a PDC, which has a cisco router
attached.
Web Server has SQL installed on it, I have TCP/IP co...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Server doesn't respond to broadcast request Posted by Sylvain at 9/13/2005 1:53:01 AM Hi,
A problem since few weeks, all my SQL servers located on the LAN (clients
too) don't respond to the broadcast request (255.255.255.255:1434), so my
clients must set manually the TCP/IP port of their named instance. No
firewall are placed between servers and clients. Any help appreciated...more >>
Error 9003 Posted by Mike at 9/10/2005 1:50:01 AM Hi
I have been using SQL server with the web matrix project whilst I learn
ASP.net. (I am new to both). At some point this week the SQL server stopped
working (It may be linked to my computer crashing whilst another program was
running). It now will not run from the web matrix or the SQL se...more >>
Server Does Not Exist or Access Denied error Posted by Terry Holland at 9/9/2005 10:41:06 AM I have a asp.net application that connects to a SQL Server DB. I have been
connecting to SQL Server on local machine and now Im trying to test
connecting to another test server.
I have setup my connection string in my web.config file as follows
<appSettings>
<add key="DB:CSA"...more >>
settings for CLICONFG Posted by Steve Everington at 9/8/2005 12:00:00 AM Hello,
I have an issue with a number of the Windows XP workstations on my network
not wanting to talk to my SQL server. I have traced the problem down to the
appropriate protocols not being enabled on those machines (which I can fix
using CLICONFG). What I am now trying to find out is how...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |