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 > july 2004 > threads for july 22 - 28, 2004

Filter by week: 1 2 3 4 5

how can I confirm msde sp3a upgrade information
Posted by peter at 7/28/2004 10:00:09 PM
I would need to know if the MSDE SP3a is aleady Upgraded. I didn't search registy and Enterprise Manager(other PC) Thank for your help...more >>

MTBF
Posted by Paul at 7/28/2004 8:15:34 PM
Hi, I am looking for some statistics for MSDE. In particular, I am looking for information that would catain items such as Mean Time Between Failure. Can anyone point me to a resource for this? Thank you, Paul ...more >>

SET CONSTRAINTS ALL DEFERRED not working
Posted by Jens Neuhalfen at 7/28/2004 6:44:37 PM
Hi group, this just drives me mad: I need my msde (the 7.0 version) to deferr foreign-key checking until commit time. The problem is this: I need to delete some rows in different tables from my middle tier. I do not know which rows in which table are delted beforhand so sorting the state...more >>

DisableNetAccess
Posted by Lance Johnson at 7/28/2004 1:36:38 PM
Windows98 machine and when installing MSDE we (our customer) gets an error on DisableNetAccess. I have no idea what they should do and I can't find anything in google with the word disablenetaccess so I'm hoping somebody out there has some info. Below is the relevant info from the log file when...more >>

SQL Express 2005 beta - OleDB/ADO works, ODBC / dbExpress - impossible
Posted by LigH at 7/28/2004 11:25:35 AM
Dear Microsoft develpers and users, creating an ADO connection using the connection builder is no big problem (once I found out how to use it): Select the provider "SQL Native Client", use as data source ".\SQLExpress", define the rest - and your connection string will look like "Provider=SQLN...more >>

Please Help with Access Sql connection
Posted by Al at 7/28/2004 7:31:16 AM
I have an access FE linked to SQL backend. I am just testing the connection of another workstation to the server. when I linked another workstation to the server everything went smooth, however only one table that when I tried to open I got the following message: "ODBC--Connection to 'CRF_B...more >>

MSDE Deplyment using BootStrap - Instance created
Posted by jazztol NO[at]SPAM hotmail.com at 7/28/2004 4:56:42 AM
Hello, I am using the boor strap to deploy MSDE with my application. after deployment i cannot choose the server from the service manager because it is not there ( localhost ) and also the instance is not created. Can someone help ? Thanks Haim Toledano...more >>

MSDE and SQL Express '05
Posted by Wayne P. at 7/28/2004 3:39:34 AM
I been trying to read the posts to answer this, but I don't see a straightforward answer. Can MSDE and SQL Express '05 co-exist on the same machine? Thanks, Wayne P. ...more >>



Password not Added after Installation
Posted by Shahzard at 7/27/2004 10:44:11 PM
Hi, I recently installed MSDE 2000, by giving the following to setup parameters in the Command Prompt: Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\> D:\MSDE2000\Setup.Exe SAPWD="apple" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 /L*v C:\MSDELog.txt...more >>

Answer: Access creates DB in MSDE in SQL Server Authentication mod
Posted by Lou Arnold at 7/27/2004 10:09:02 PM
I've confirmed that MS Access will create an ADP project in MSDE only if the server is set to Mixed (SQL Server and Windows) authentication mode. Trials in Windows Authentication mode failed. This is still hard to believe, I know, but its a reality. To all those who tried to help, my sincere than...more >>

Primary Keys
Posted by June Macleod at 7/27/2004 2:35:44 PM
I have managed to confuse myself as to when and how you can set up Primary Keys on an MSDE database. Are Primary Keys only used when you are connected to an MS Access project or can they be used in other places. I come from an MS Access background and am familure with the use of Primary Key...more >>

UPDATE Image Column to NULL
Posted by Michael Mieney at 7/27/2004 11:11:04 AM
Am using SQL 2000. Am storing data in image columns, created with NULLS allowed. Requirement has come across to revert (in some user-selected cases) the column back to no data. Have been using the presence of the NULL to check for the absence of the data and this has been successful. Have d...more >>

replication from MSDE 2000 to SQL Server 2000
Posted by Hifni at 7/27/2004 5:59:24 AM
hi, There is a computer which have been installed MSDE 2000 (Assueme this as "MiniDB"). This should be the Publisher as in my Architecture. The Main Server which is a MS SQL Server 2000 would be the Subscriber(assume that the name is "MainServer"). I want to replicate the data from my "Min...more >>

sqlmangr.exe Error
Posted by Oleg at 7/27/2004 12:21:37 AM
I have problem on my w2k server post SP4,MSDE SP3 . I start sqlmangr.exe, and do any mouse click on the form and it disappears. Actually, I don't even need to click! Just moving the mouse over the form causes it to disappear sometimes without an error message or anything, but usually I get...more >>

IDENTITY_INSERT Problems
Posted by drs at 7/26/2004 4:02:38 PM
Hi, I am having a problem with IDENTITY_INSERT command with MSDE 2000 (ADO 2.8). (lines below with >>> are code lines. I am using Python, but the syntax should be about the same as VBScript) First, I create an ADO Connection and create my table. >>> c = win32com.client.Dispatch('ADO...more >>

DB bloat from images: Access vs. MSDE
Posted by Yair Sageev at 7/26/2004 2:52:02 PM
Hi, I'm in the process of upsizing my access database to MSDE. When you embed images in an access DB, the database bloats out of control. I'm wondering if the same problem occurs in MSDE when you embed images. Thanks in advance. ...more >>

MAX() and DATEDIFF() question
Posted by BCM at 7/26/2004 8:02:11 AM
I've written some software that listens to meters on a specified port and writes XML files when any of those meters "speak." There are some 200 of them, and each is programmed to "speak" at 10 second intervals, so there's a fair amount of traffic. Now what I've been asked to do is write a reco...more >>

User rights when installing MSDE 2000A
Posted by Carolina at 7/26/2004 3:08:20 AM
Hello, Is it possible to install MSDE 2000A with local admin rights and then run it with poweruser rights? Or do I have to have local admin rights when I run it as well? Now I have tried to install it with an account that have local admin rights and after that I tried to run it with ano...more >>

MSDE 2000A EULA / SBS 2003 Web Edition
Posted by Martin Feuersteiner at 7/23/2004 7:19:29 PM
Hi. I'm a bit confused and wonder whether someone of you can give me some more information on this. The EULA for MSDE 2000A states that you cannot use MSDE for hosting services. Does anyone know what this mean? I'm running an ASP.Net application and would like to use MSDE as the backend datab...more >>

MSDE 2000 Install Problem
Posted by Jason Stamp at 7/23/2004 10:52:14 AM
Hi I am trying to install MSDE 2000 sp3 on a Windows XP that has had a previous installation in the past. The previous installation has been removed, but when I try installing MSDE again from the command prompt, it starts to set up the gives me an error saying installation failed. I have de...more >>

Building SQL Query to fill a treeview control with Year->Month->Day nodes
Posted by MJB at 7/23/2004 9:54:34 AM
Hello, I have load dates for each row in my database table. I'm trying to build a query that will give me all of the unique years, then all of the unique months for that year, then finally all of the unique days for that month. I'm trying to load a treeview control with the results ...more >>

Cannot see MSDE Sever on network
Posted by adriatik at 7/23/2004 1:44:03 AM
Hi everyone. I have installed MSDE on Win 200 Pro. everything works fine when i try to connect on the local maschine, but when i try to get a connection from another computer, then he cannot find the server, when i look with enterprise menager the same thing. have any idea? ...more >>

exporting desktop MSDE to remote server Sql
Posted by Bob K. at 7/22/2004 11:26:24 PM
What is the best tool for doing this? I have been using MSDE to create a portal app on my desktop and now want to move the data from the MSDE db locally to the remote server db. I can export the MSDE data but need a way to get it to the remote sever and import it. Enterprise Manager seems to...more >>

Cannot connect to Sql Server 2005 Express. Any idea why ?
Posted by Ing. Rajesh Kumar at 7/22/2004 10:56:27 PM
Hi everybody I have a system with : WinXP Pro, MSDE 2000, Framework 2.0 beta. On top of it i installed SqlServer 2005 Beta with Mixed Mode. I am using Query Analyzer and Enterperise Manager from SQLServer 2000 to connect to it (manual says I can) but with no success. I tried to log on with wind...more >>

MSDE or SQL-SERVER ??? help
Posted by Artmic at 7/22/2004 5:08:01 PM
Hello can someone help me out, i need to know if i buy the 5 User Cal license of MS-SQL server, does that mean that only 5 people on the network or through the web can access the database? Is that true? How can i use the SQL Server in the following way: 2-4 users running on a local area networ...more >>

DDL statement is not allowed
Posted by eslalinde at 7/22/2004 1:57:01 PM
hey, i have a small bussines with share point and msde2000, when i try to create a table in the servername\sharepoint, i get this DDL statement is not allowed, can anyone help wiht that thanks...more >>

Pubic Chat: SQL Server 2005 Beta 2, What's New
Posted by Stephen Dybing [MSFT] at 7/22/2004 11:19:59 AM
Join members of the Microsoft development team as they chat about what's new in SQL Server 2005 Beta 2. One major new feature that's been announced in Beta 2 is data encryption. Come chat about other new features and changes that exist in this highly anticipated beta of the next version of SQL...more >>

problem running MS SQL Web Data Admin
Posted by vl at 7/22/2004 12:04:41 AM
Hi: My client machine is XP Pro with SP1 with IIS 5.1 My server machine is Windows 2000 server SP4 with IIS 5.0. Server has the latest MSDE 2000(SP3a, in mixed mode) as well as MS SQL Web Data Admin (webadmin) installed on it. I can use webadmin on the server to access data in MSDE using windo...more >>


DevelopmentNow Blog