hello, we use Protection Pilot (from McAffee), it installs a MSDE that it uses to store info about clients. so, I need to do a backup of the MSDE to send to their tech support people but their backup utility isn't working. They've tried for about 2 weeks now and it's not working. I asked t...more >>

Here's the screnario...using an MSDE install of SQL Server to run a stored procedure the first inserts a record to a table and then executes the master.dbo.xpcmdshell stored procedure (call from within the insert procedure). This is executed from an ASP.Net web site and it assume a SQL Serv...more >>

Hi All I need to check if MSDE2K service is running on a stand-alone computer using VB6 I have tried using SQLDMO.ListAvailableServers but find it very unreliable... Dim oApp As SQLDMO.Application Dim oNames As SQLDMO.NameList Set oApp = CreateObject("SQLDMO.Application") Set oName...more >>

Hi, I have Visual Studio 2003, MSDE, and Commerce Starter Kit on my Win XP Pro computer with IIS. The demo web site works well. But I can't modify the content of the database 'Commerce'. With MSDE Manager I changed some content, but the modification do not appear on the web site even ...more >>

We have a VB6 app that uses an MSDE SP3 database. We use a process with transactions to add data to the database. As several similar packets of data are added we've noticed a degradation in the speed of loading the information. We've also noticed that if at the end of the insert of several ...more >>

Does anyone know where we might find the source to the Deployment Toolkit. I would like to be able to customize the install of MSDE more than is allowed, and the current tool would make a good starting point. ------------------------------------------- Roy Chastain KMSYS Worldwide, Inc. ht...more >>

Hi All I am using VB6 and MSDE 2000 I previously used Access 2000 and used the following ado sql to create a temp table in access (Invoice table contains Invoice data such as Invoice number, date etc. Idetail table contains details of the invoice individual items e.g product code, Invoice ...more >>

I have a machine named DOG with MSDE (computername=DOG). I clone the machine to another and rename the machine CAT. When I do this, SQL Server reports "Your SQL Server installation is either corrupt or has been tampered with (unknown package id). Please rerun setup." I understand why this happens...more >>

Hi everyone, I just installed on my windows 2000 computer using the following command line with a strong sa password: c:> setup sapwd="my_password". I want to create a new access database project (.adp) but after I input the credentials for sa and user, I get a message saying that SQL Serve...more >>

Below is an update to a problem I posted to another group about installing MSSQL7 on a machine that previously had an install of MSDE2K. I am quite the newbie to SQL server, but am VERY interested in gaining this skillset, and becoming MCDBA. Currently, I have a SQL server 7 installation d...more >>

We have a customer that is receiving the following error installing MSDE (2000 Rel A) on a Windows 2000 machine. They are logged in as an administrator, supposedly have file and printer sharing installed, the machine name is all uppercase. Here are the relevant lines from the log file: Loa...more >>

I am having difficulty installing MSDE on an XP Sp2 system with the Microsoft Business Contact Manager installed (Hooks into Outlook). I checked all my standards... ie folder for my instance not there, registry key for my instance not there, my instance not installed in the add-remove progra...more >>

Hi Guys Currently, SQL Server 2005 Express ships with Visual Studio 2005 Beta 2. Does anyone know if this will be the case when the final VS2005 ships in November? OR... can we guarantee that SQL Server 2005 Express will remain a FREE download? I need to buy Windows Server SBE, but didn'...more >>

Users of my application connect to MSDE from a PDA. With a PDA it's not possible to specify ServerName\InstanceName so it has to be specified as ServerName,PortNumber. When I applied SP4 to MSDE the port number changed which means customers will need to change the port number of every PDA, doe...more >>

Hi, At the moment, using our VB6 / Access application, users can zip up their ..mdb files and send them to other users I have been reading that with SQL Server Express, you can treat databases like Windows files allowing users to do this. I am wondering if it is possible to do something...more >>

Hi, I would like to understand what counts as "use" under section 3.2 of the EULA? I am looking at redistributing certain components of MSDE that are listed in redist.txt. Does this count as "use" under section 3.2 of the EULA? or does it fall under section 3.1 "redistribution"?...more >>

Hi, I am new to MSDE and am having a problem connecting to it through my PDA application. Everytime i try to open the connection i get a exception of PlatformNotSupportedException. I have checked this problem for many times and fail to find an ideal solution. My question is whether it was ...more >>

Hello! Sorry for my English, but... I'm using Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2) This code runs in Job when Agent starts declare @p int, @b bit...more >>

I have an MSDE database filled with data. I use Web Data Admin to config the db. In my short-sightedness I defined a column of vchar as only 12 characters when now I need 15. However since there's data in the db, the edit option is not available for the columns. What's the best way to go ...more >>

Hello I have little experience of MSDE but have worked with SQL Server at various locations in the past. Can anyone tell me the easiest way to manage permissions, user and group accounts etc. in the absence of enterprise manager. Does everything have to be scripted? Many thanks Ma...more >>

Since msde sp4 changes sqlagent to manual start, I found scm to reset it back to automatic. C:\Program Files\Microsoft SQL Server\80\Tools\Binn>scm -Action 7 -Service sqlserveragent -SvcStartT ype 2 To get msde sp4 to update my default instance, I had to set sqlagent 'log on as' to Local S...more >>

I did search the aspfaq, but I'm not sure that's where I would find this information. I am adding users in slowly to an MSDE database on our network. It isn't hit all that often, so MSDE works fine for now. I am using Windows Authentication so that I can control security by person, and don...more >>

Hi, I run a same update query in our two servers, which have the same configuration and same database and indexes, one of them is returning the result in 4 seconds, and the other one in 7 minutes. the only difference between them is that the fast server has 512 MB and the other one has 256 ...more >>

I have a odd situation and am unsure of my best option. We use BMC Patrol to monitor an Enterprise Edition database. A server guy came along and installed Backup Exec to make some one-off tape backups for a vendor. He installed and decided to use MSDE. MSDE is now installed on my server...more >>

I am using the MSDE deployment toolkit to deploy MSDE release A. The total size of my install is ~80 MB, of which my application accounts for 1 MB. Is it possible to create a smaller MSDE install by excluding certain merge module depending on the features used by the application?...more >>