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 > june 2005 > threads for june 22 - 28, 2005

Filter by week: 1 2 3 4 5

Acess Denied SQL Server doesnot Exist
Posted by Shiv at 6/28/2005 4:43:03 PM
Hi I recently installed a copy of SQL Server 2000 and was unable to connect as my SQL server gives me the message "Acess Denied SQL Server doesnot Exist". I did use all the trouble shooting help but couldnot rectify it. The probelm seems to be with my logon. I am starting it with a single user...more >>


SQL Port Restriction
Posted by Wade Rocco at 6/28/2005 9:08:51 AM
Hello All, Which ports are necessary for SQL communication?? I have a test environment with a web server and a separate db server and I want to shut down any unnecessary ports on the web/SQL server. Any advice is appreciated. Thanks!! Wade ...more >>

how to determine the best timeout value
Posted by jalie at 6/28/2005 4:36:02 AM
Hi, I am trying to insert 75000+ records into a table via a stored procedure (the table is empty) - the information for all those records is contained in an xml document that is passed to the stored procedure in a string. I am using openxml to read the xml data and to insert the records int...more >>

Exchange Linked Server
Posted by Mike at 6/27/2005 12:00:00 AM
I'm trying to run a view that calls a table in a linked server (linked to Exchange on an SBS 03 box) The linked server shows the correct tables in the Exchange public folders. The query is; CREATE VIEW dbo.vw_Exchange_Contacts AS SELECT CONVERT(nvarchar(50), [DAV:id]) AS DAVUID, CONVE...more >>

Unable to connect to SQL Server Personal Edition
Posted by guian NO[at]SPAM att.net at 6/26/2005 1:42:18 PM
I'm trying to connect to a local SQL Server 2000 'Personal Edition' running on Windows XP Professional. I've tried everything, and searched the forums for similar problems, but I can't get the connection to work... :( Using jdbc, with the follwing URL jdbc:microsoft:sqlserver://localhost:14...more >>

Weird SQL behaviour
Posted by bthouin at 6/23/2005 11:54:46 PM
Hi guys, I have a simple problem, and on the paper I've solved it, but the results are absolutely baffling and inconsistent, hence my cry for help. My client has an SQLServer database (designed and fed by my software) at a hoster, with, for the sake of this exercise, 2 related tables, lets...more >>

Can no longer get dataset fill method to work after directory copy
Posted by HermanW at 6/23/2005 9:31:01 AM
I have been creating a small winforms app using VS 2005 and SQL Express. I create serveral tables in the database and added it as the datasource for the project. I created several forms, created several datagrids and regular design views. After I got several of the forms running, I decided to...more >>

Lost connection to sql server
Posted by JT at 6/22/2005 10:27:02 PM
Hi, I just installed a virtual sql server 2000 sp3a named instance on a MSCS cluster. I was trying to get the log files onto a separate LUN in my SAN. I changed the startup parameters in Enterprise manager to point to a new location for the -l parameter (log) and removed the previous -l par...more >>



Doubt about connections to sql server.
Posted by MariaGuzman at 6/22/2005 2:39:43 PM
Hi, i have some applications that use a sql server user to connect to databases. Sometimes i Check the las batch time in enterprise manager to see if the connection is active, and the date is expressed like this: "01/01/1900 12:00 am" Do somebody know why this happen?? Thanks a lot for your...more >>

SPIDs and processes
Posted by Jim at 6/22/2005 11:33:07 AM
Hello, I don't know much about SQL Server processes/SPIDs but everytime our web app creates a ADO.NET connection and closes it, the SPID is still hanging around in "sleeping status" well after it's closed in the ADO.NET code. Is this normal or I am making database calls inefficiently? I al...more >>

Unable to connect to sqlserver 2000 with SP4
Posted by ourspt at 6/22/2005 12:25:03 AM
Hi All, I am having my SQL Server 2000 with SP3 service pack on an Windows O/S 2003 server without any service pack. My client application was able to connect without any problems. Now recently I have upgraded my SQL Server 2000 with SP4 Service pack and also upgraded my Windows O/S 200...more >>

How to connect to a dedicated m/c
Posted by Lara at 6/22/2005 12:00:00 AM
Hi, Recently i installed SQL server 2000(EE)on my remote dedicated server( win 2003). I haven't installed ant Service packs. Now the problem is i am not able to connect to the SQL server either thru Query Analyzer or thru the application. I have disabled the firewall, still no use. Can anyone he...more >>


DevelopmentNow Blog