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 > january 2005 > threads for january 1 - 7, 2005

Filter by week: 1 2 3 4 5

How to access SQL Server on another domain with Windows authentica
Posted by CyberDigger at 1/7/2005 2:51:02 PM
I have two computers, client and server. The client is running Windows 2000 Professional and is in a workgroup, say "MyWorkgroup". The server is running Windows Server 2003 Standard Edition and is in a domain, say "MyDomain". The server has SQL Server 2000 Standard Edition with SP3a install...more >>

Can't connect to SQL 2005
Posted by Scott McNair at 1/7/2005 2:49:36 PM
Hi, I just installed MSDE 2005 (or, rather, whatever it's called now) on my machine. I'm trying to connect to it using Enterprise Manager, but I keep getting Unable to connect/connection refused messages. I've tried giving it my machine name, the word (local), localhost, 127.0.0.1, my m...more >>

Problem Transact-SQL Statement
Posted by Allen Yu at 1/7/2005 12:36:32 AM
I've come across a Transact-SQL statement as follows: -- Statements start here select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from sysobjects where type = 'U' -- end here Questions: (1) How should the 'select' statement be interpreted? (2) What are the rules for u...more >>

Unusual AS400 Linked Query problem
Posted by Simon Prince at 1/6/2005 11:46:09 AM
Hi, I hope someone may be able to shed some light on my problem... I am using as AS400 as a Linked Server from SQL 2000, and have been for 2 years or so, with good success, but I came across an issue this morning I just can't solve. I am querying a table using the syntax (simplified) ...more >>

installiation error help plz
Posted by Wouter at 1/5/2005 12:15:45 PM
when i start to install SQL and followed this guide: Run SQL Setup Select "SQL Server 2000 Components" 1. Click "Install Database Server" 2. Click Next 3. Select "Local Computer" and click Next 4. Select "Create a new instance of SQL Server,or install Client Tools" and click next 5. Put ...more >>

Microsoft JDBC Driver Performance Degradation
Posted by Brian Luo at 1/4/2005 5:07:05 PM
We have been using Microsoft SQL Server JDBC Driver 2.2.0040 in our products to connect to SQL Server 2000 Standard Edition SP3 (8.00.760). Our functional testing went fine but we have run into serious performance degradation under simulated heavy loads. Our server crashed with OutOfMemor...more >>

Connect not working from one machine
Posted by murphy NO[at]SPAM murphysw.com at 1/4/2005 2:32:56 PM
I'm trying to create an ODBC DSN from client A to server B via the control panel applet. I receive the "Server does not exist or access denied". >From A I can connect to other database servers in the office. Other clients in the office can connect to server B. I've reinstalled MDAC 2.7 s...more >>

Connect through NAT router
Posted by Bill Todd at 1/4/2005 10:31:18 AM
I need to connect to SQL Server 2000 across the Internet. SQL Server is behind a NAT router. What port(s) do I need to forward to be able to connect with Enterprise Manager and ADO? -- Bill Todd...more >>



Error 1069
Posted by ryan at 1/2/2005 7:59:05 AM
I am getting this error when I try to start my service in win xp pro. any suggestions on how to reslove this?...more >>


DevelopmentNow Blog