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 > march 2005 > threads for march 8 - 14, 2005

Filter by week: 1 2 3 4 5

SQL Server 2000 SP3a and Windows Server 2003
Posted by Matt Soukup at 3/14/2005 1:57:02 PM
I have a Windows Server 2003 Standard that I have installed MSDE with SP3a on. This server is running only as a file server on a workgroup, no Active Directory, DNS, or DHCP servers are running. I can connect to SQL locally with no problem. When I tried to connect a Windows 2000 workstation at...more >>


Need help with stored procedure.
Posted by Vanessa Lee at 3/13/2005 7:28:44 PM
Hi, I am using SQL Server 2000 on Windows 2000 server. Here is my problem: @String = 'word1word2word3word4word5' - This value is passed to Stored Procedure from the script. Column1 in a table1 has many rows with "words" . One row in this column1 will have 'word3'. Notice that this 'word3' i...more >>

Connection between SQL Server 2000 SP3a and ODBC Driver
Posted by desimaj at 3/12/2005 3:43:02 PM
Database: SQL Server 2000 Developer Edition SP3a Frontend: MS Access 2000 and Access 2003 A Custm-built Medical Records Database I am having a problem connecting to my SQL server with certain ODBC drivers (sqlsrv32.dll). But it only acts up on certain "forms" in the Database, in particular ...more >>

trying to create view on linked server
Posted by Joss at 3/11/2005 3:00:13 PM
Plesae excuse if I make any howlers here, I am on the steep part of the curve. I have created a link in SQL to an AS400 but cannot create a view to it in Access ADP. The SQL that I am using is 'SELECT fieldname FROM as400sver..dbo.linkedTableNAme; the error that I get when I try to save/...more >>

Kill Blocked Process PID 52 without Reboot
Posted by matthias at 3/11/2005 11:45:45 AM
Hello, I need help :-)) We use an SQL 2000 Server. in the Systemmanager one Prozess with PID is sleeping, no databese context, and I can not cancel the Prozess. When i try to update some Data, this Prozess ist Blocking all other. How can i cancel this job without reboot the server. T...more >>

connection failed
Posted by .:alex:. at 3/11/2005 9:15:54 AM
Hello, I have sql server 2000 on a XP/SP2 machine.. with XP firewall active. But I cannot connect to sql server. I receive this message "Unable to connect to server xxxxxx: SQL Server does not exist or access denied"; or Login failed for user xxxxx. With QA same problem... I created the ...more >>

Low performance while inserting records
Posted by Sanjay Jajoo at 3/11/2005 3:45:02 AM
Hi, Can anyone help us in letting us know that while inserting records through VB to SQL server it takes very long time even to insert very few KB of data which previously was happening in seconds is now taking hours.!!!!!!!...more >>

Restore database fails only when source is read from another machine ( server)
Posted by PKuhne at 3/10/2005 5:41:43 PM
When executing this from Query Analyzer on server1, where the target is located, restore database restoretest from disk = 'd:\backups\dottietest.bak' with move 'vam_system_data' to 'd:\vamdata\sample\vamsystemdata.mdf', move 'vam_user_data' to 'd:\vamdata\sample\vamuserdata.ndf', ...more >>



Not associated with a trusted SQL Server connection error
Posted by James Turner at 3/10/2005 12:00:48 PM
I have an ASP app I am trying to implement which is giving me some weird results. The environment is a Windows 2003 Domain. The IIS Server is Windows 2000 SP4, SQL 2000 is running on a Windows 2003 server. I have an ODBC connection setup to a database using SQL Authentication. If I log...more >>

[Microsoft][ODBC SQL Server Driver]Timeout expired
Posted by Mitul Z. at 3/10/2005 4:13:03 AM
Hi: I am getting this error when the .asp page tries to connect to the DB server. Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver]Timeout expired The web server is Windows 2000 Advanced Server, Dual CPU with Hyperthreading, P4 with 2 GB R...more >>

Creating a login after the backup was restored with existent users
Posted by Cathy Boehm at 3/9/2005 10:17:03 AM
Is there a way to create the login id after the database backup with users was restored into this new SQL Server. The problem is that I am trying to create the login id for the user that owns practically all the database objects. So I can't drop that user to execute sp_grantdbaccess after cre...more >>


DevelopmentNow Blog