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
all groups > sql server connect > december 2004 > threads for december 1 - 7, 2004

Filter by week: 1 2 3 4 5

sql server connection not reliably available to asp
Posted by JJ at 12/7/2004 4:11:07 PM
Hi, I have a webserver with sql server on it. All was working fine until a few days ago, when now sometimes it refuses asp a connection. In other words, I have an asp page which accesses the database, but sometimes it says the connection is not allowed. The only significant thing I have do...more >>


Need to interface MS SQL in C++...
Posted by acoquinar at 12/7/2004 2:24:16 PM
Greetings ! We need to find if MS SQL has an API for connecting C++ components to it. We don't know if "extended stored procedure (xp)" is the way to go. Why do we need that ? We must implement a synchronization software layer to make sure an ODBMS has the same values as tho...more >>

Linked Server connections
Posted by Cintia Goncalves at 12/7/2004 11:45:05 AM
I have a server in my office which is configured as a linked server on another one. How can I configure the connections between them to be killed after a period of non-useness. As the connections are not killed after some time the limit of connections in my server is exceeded. The connections...more >>

Server Registration
Posted by Jay Zee at 12/7/2004 7:37:15 AM
If another sql server has my server registered is there any way for me to find out?...more >>

local sql server not visible for 'Users' on the same PC
Posted by Steven.Dahlin at 12/6/2004 11:09:04 AM
Users on the same PC who do not have admin rights cannot see or logon to the sql server/msde that exists on the PC. Any user with admin rights can see it, of course. I have waded thru lots of hits in my searches but none of them describe this behavior and whether I can surmount this or not. ...more >>

Port 1433 doesn't listen
Posted by Morten Snedker at 12/3/2004 2:31:44 PM
I've Googlet alot, but can't find my solution. 1. I cannot telnet on port 1433 2. SQL Server Network Utility shows 1433 on the TCP/IP. 3. netstat -an doesn't show anything using port 1433 4. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\Tcp\DefaultPort has the va...more >>

Via group membership problem
Posted by KK at 12/3/2004 9:29:24 AM
Hi, I want to grant login for whole domain and then add certain domain users to certain user defined sql server database roles. I'm using SQL Server 2000. 1. I have created login for my domain user using Enterprise Manager (group name is MyDomain\Users). 2. I have added a role member usi...more >>

BCP server not found failure
Posted by Pirulo_y2k at 12/3/2004 6:29:03 AM
Hi..im trying to use BCP to transfer data from text file to a SQL table and give me an error. I have access to the db table with the 'sa' user and both input and format files are in the directory. This was working well, but suddenly stop working. This is the complete command and the error a...more >>



ORDER BY question.
Posted by Greg Collins [InfoPath MVP] at 12/2/2004 2:31:05 PM
I have some data that I want to select with an ORDER BY statement and be = able to have it sorted in a hierrarchical order. There will be essentially 1) and ID, and 2) a ParentID. I would like to have the data returned sorted such that any row with a = ParentID =3D to an ID is under that ID ...more >>

SQLMail through webmail?
Posted by vgv8 NO[at]SPAM -NOSPAM-yahoo,com.br at 12/2/2004 7:02:00 AM
I am developer and not db admin. My boss wants that his clients would have possibility to use SQL Mail without installing MS Exchange or any mail server. I.e. using webmail. I configured and tested POP3 client (MS Outlook) to use account tstvgv@hotpop.com (i.e. webmail with free support of ...more >>


DevelopmentNow Blog