Archived Months
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
all groups > sql server msde > may 2005 > threads for may 22 - 28, 2005

Filter by week: 1 2 3 4 5

Viewing table rows in Microsoft's Web Data Administrator for MSDE
Posted by plum at 5/28/2005 7:39:51 AM
Hi I'm using the Microsoft Web Data Administrator (WDA) to access MSDE. I've created a table and inserted values into it. When I click on my table with inserted values in WDA, I can see details on the attributes of each column, but not the values. If I osql into my MSDE, I can see the value...more >>


MSDE - Novice & silly question
Posted by Luiz Horacio at 5/27/2005 2:33:29 AM
Hi, I'm trying to install MSDE with the following command line: c:\temp\setup.exe sapwd="password" Password has 12 mixed special characters, upper and lower case letters and numbers, so I guess it is a strong SA password. Installation starts, but just before the progress bar reaches the...more >>

How to upgrade from SQL Server 6.5 to MSDE 2000?
Posted by Peter at 5/25/2005 9:52:18 AM
Are there any difference between upgrading from SQL Server 6.5 to MSDE 2000 and SQL Server 6.5 to SQL Server 2000? Is there any special instruction to upgrade from SQL Server 6.5 to MSDE 2000 comparing to from SQL Server 7? Thanks....more >>

Access error when linked to incrementing integer
Posted by Monte at 5/25/2005 7:46:01 AM
I have found a problem when linking a SQL Server 2000 table that contains an auto incrementing integer into Access 2002 via ODBC. Access identifies this field correctly as an "autonumber" field. However, when I add a record to the table, I get an ODBC error that mentions a "Cast" error. In oth...more >>

MSDE Install
Posted by DBX1 at 5/25/2005 4:19:01 AM
Running MSDE 2000 Rel A install with the following information: [Setup.ini File] [Options] DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL Step 2: Reboot -- Ensure service starts. Step 3: Extract Service Pack 4 Step 4: Run Service Pack 4 for MSDE Step 5: Error on install of Service Pack 4...more >>

Full Text Search service
Posted by fc3 at 5/25/2005 3:30:02 AM
Hi, anyone can tell me if whith Msde 2000a (Sp3a) or with Sp4 the full text search service is supported? Thanks in advance. ...more >>

moving EXE from MSDE PC to SQL Server PC
Posted by Richard Fagen at 5/24/2005 5:46:26 PM
Hi, I am developing a VB application on my PC using MSDE and have been using Windows Trusted Connection and localhost sqlConn = New SqlConnection("server=localhost;trusted_connection=true;database=Pubs") Then I copied the EXE to the PC running SQL server 2000 and I get an error mess...more >>

Problem using linked tables instead of ADP
Posted by Mark at 5/24/2005 12:00:00 AM
Hi I know I probably shouldn't be doing this but... I have a table on an MSDE database that has a bigInt for the primary key. If I try to link to this table from Access (XP) using an ODBC connection the table links ok. The first time I opened the table it was ok. Since then the primary k...more >>



SQL Server Web Data Administrator
Posted by dhnriverside at 5/23/2005 3:28:04 AM
Hi peeps I'm running MSDE on a Win2k server, and have just installed SQL Server Web Data Administrator. Everything works, but I can't find a way to edit the actual data. I can edit columns, tables etc, but not the actual data, although I can query it. Is this right? Mucho useless if yo...more >>

Question on Formula
Posted by Deck at 5/23/2005 12:00:00 AM
I have a computed field that I want to change the formula. How do I do this in SQL ? thanks in advance ...more >>

Can I install msde without the sql server manager?
Posted by D at 5/23/2005 12:00:00 AM
Is there a way to install it without that little icon in the tray? Thanks ...more >>

Sample code to create a SQL Server Database in C#
Posted by SCM at 5/22/2005 3:45:01 AM
Hi, I'm a new programmer in using ADO.Net. I have to write a simple program to create a SQL server Database on a Windows 2003 Server with MSDE 2000 installed only. Is it possible to do so by just creating a Database without installed any SQL Server 2000? After I have created the SQL...more >>


DevelopmentNow Blog