I'm doing some development with MSDE and unfortunately it no longer appears under the Add/Remove Programs menus. MSDE obviously has some lingering issues. Microsoft is driving me nuts. Here's a way to uninstall via command line: C:\>setup.exe /x sqlrun01.msi INSTANCENAME="MYMSDE" I don'...more >>

Howdy All, I have a couple of applications which run on MSDE (ACT!, Document Imaging Software). I recently cleanup up my PC and uninstalled MSDE from 'Add/Remove Programs'. This apparently doesn't completely 'uninstall' MSDE. Now when I try to run my apps, I can't create databases, and w...more >>

Hola !! tengo MSDE 2000 con SP3 y lo uso con VB 6.0, al usar una ventana que graba datos en la BD recibo el siguiente mensaje de error: Error :3251 - El Recordset actual no admite actualizaciones. Puede ser una limitación del proveedor o del tipo de bloqueo seleccionado. Los recordsets...more >>

Hi, on my PC I installed for developement and test MSDE 2000 Rel. A and, from Developer Edition, Client Tools (Enterprise Manager, Query Analyzer, etc.) only. Which version of SP4 I must install ? SQL2000.MSDE-KB884525-SP4-x86.EXE - or - SQL2000-KB884525-SP4-x86.EXE - or both ? Thanks you ...more >>

The install is rolling back on a NT machine. Does anyone have any ideas why? thanks...more >>

After executing setup setup SAPWD="mypass" SECURITYMODE=SQL /L*v C:\MSDELog.log We have this lines at log. (Siempre que ejecuto la línea anterior empieza la instalación y cuando dice que faltan 3 segundos aparece un error. Aparentemente el error aparece en este trozo del log que he incorp...more >>

Hello, We have a VB 6 program using MS Access that is distributed to many remote locations. We would like to convert the application to use SQL Server Express. We would like the Exress database to have a number of it's columns encrypted using the new encryption capability in SQL Server 2005...more >>

Hi all I'm trying to use a maintenance plan to backup my thing (Data + Log) on MSDE The Data Backup work well, But I always have a error when trying to backup the log... (Backup can not be performed on database 'GesTex'. This sub task is ignored.) Here are the job that I execute : EX...more >>

Hi, We've been developing windows applications in VB.net, which we've recently transferred over to using an MSDE back end. I have a couple of questions, any advice would be greatly appreciated: Is MSDE suitable for a Networked application max ten users? I realise this is possible but i...more >>

I have observed that upgrading a Win98 machine to 2000 or XP will break MSDE, this was pretty-much expected but my question is what the most graceful way to repair/reinstall MSDE is? It seems like a real mess. Thanks in advance for your help!! -Phil ...more >>

I was just wondering if SQLExpress will have the same maximum row size funcationality as SQL Server 2005. (being able to have a single row go accross multiple pages and allow the entire row to exceed 8060 bytes)? Thanks, John Scott....more >>

can someone please help me find any documents on this question or answer the question please. Thanks in advance Ray...more >>

Hi NG We have experienced that the LDF file grow out of proportions. In Microsoft Knowledge Base we have found some descriptions on how to shrink the file. Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE http://support.microsoft.com/kb/272318/EN-US/ How to S...more >>

Hi all i install microsoft MSDE on one machine it work fine on that machine but when i am trying to connect from other machine by giving osql -U "Username" -S "ServerName" and password but it give me error message Sql server does not exist" and when i try to connect from Sql server Query A...more >>

Hi, Are there any optimizing utilities for MSDE that can cleanup and reclaim space? Thanks in advance, JeffH ...more >>

What are the options to be given while coding in VBScript when connecting it to MSDE?...more >>

Does it make sense to use a 64 bit CPU with MSDE 2000? Or better: does MSDE user it? I can´t find any hints....more >>

Does a default installation of MSDE listen for connections on TCP/IP port 1433 by default or do I need to explicitly turn the TCP/IP listener on using svrnetcn.exe? (I'm using W2kR4 (v5.00.2195) and MSDE v8.000.761)...more >>

hi, i want to install MSDE (comes with windows embedded designer) install stops with following event: ERROR: event 19011 source MSSQLServer FillAddress(MSAFD Tcpip [TCP/IPv6]) : Error 0. WARNING: event 19011 source MSSQLServer (SpnRegister) : Error 1355. any suggestions? ...more >>

Hello, I downloaded MSDE from microsoft yesterday but I have been having alot of problems setting it up. I started the install process with the following code from te MSDN site: Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=<my password> The instalation was to...more >>

Hi I have Windows 2003 Enterprise server with SP1, and try install WSUS server. Problem is it can't install WMSDE (SQL Server 2000 Desktop Engine) http://www.team-novel.com/~zoner/errorlog1.txt http://www.team-novel.com/~zoner/errorlog2.txt http://www.team-novel.com/~zoner/errorlog3.txt ...more >>

Dear Sir I am using the Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), i would like to know if the search feature MS Search is supported. Thanks in Advance Murlidhar ...more >>

After purposefully removing the builtin\administrator from sql server on my msde (msm based) installation I get the following error: SQLServerAgent could not be started (reason: Unable to connect to server 'SERVER\INSTANCENAME'; SQLServerAgent cannot start). Everything goes through well wi...more >>

Am trying to backup to a network drive as the other machine has loads of space. Am using:- BACKUP database TO DISK='\\myserver\backup\database.bak' Keep getting backup device not available, when can see it via Network Places etc. Am using Windows 2000 Pro on both machines. ...more >>

When running the following query against MS SQL Server 7.0: SELECT documentitems.manufacturerpartnumber,documentitems.customnumber01,documenthe aders.customnumber01,documentit ems.description,documentheaders.projectno FROM DocumentHeaders INNER JOIN DocumentItems ON DocumentHeaders.ID ...more >>

Is it true that I need to enable network protocols to communicate with a named instance of MSDE SP4 locally? Installing a named instance with DISABLENETWORKPROTOCOLS=0 seems to prevent osql connecting to it. I don't want remote access - only local access (so it would be nice not to load th...more >>

Hello everyone, I hope this is the right group for this, if not let me know which one is. I have the Microsoft SQL Server Desktop Engine installed and I am getting the following error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Error code: 17). ...more >>

I have a database running under MSDE 2000 to which I can connect either through MS Access or Coldfusion. However, I wanted to run a script at the command prompt to try and have an automatic backup. I typed OSQL -Usa -P at the command prompt and supplied a valid password but after a few moment...more >>

I have trouble reinstalling MSDE 2000 on a XP machine after uninstalled it. I did apply SP3a to the previous install of MSDE 2000 on the same XP machine. Some of the component in an application did not work well so I had to uninstall the MSDE 2000 SP3a completely. I removed all folders and eve...more >>

On PC that has a default installation of MSDE and XP SP2, what ports need to be open to allow remote connection to the MSDE? ...more >>

Now it's possible to access data on MSDE with only one user (IIS). I want to make a web application that gets the data from a MSDE database. In this mode more then one users can access to the data but in reality only one user even the IIS have access to the database. Ist this way in the future o...more >>

Is there a way to prevent users from logging into an MSDE database instance? I created an MSDE instance using a strong SA password but I was still able to logging to the database using Windows Authentication. The reason I don't want the user to see the database is because the database struc...more >>

We just finished the development of an application that uses the MSDE as its database engine but we are now having second thought regarding using MSDE. There is really nothing wrong with MSDE, its just that we feel a little uncomfortable using it because we never used it before and we have th...more >>

Hi, I've just installed MSDE, and I'm wondering how to create user so I don't have to login as 'sa' user. Thanks in advance £ukasz...more >>

using WINXP PRO SP2, MSDE and VS.NET 2003 When I attempt to "Step Into Stored Procedure" from VS ServerExplorer pane, I get the following error message: Cannot debug stored procedures because the SQL Server database is not setup correctly or user does not have permission to execute master....more >>

I needed to distribute the MSDE components to the computers that use my software so I decided to build a setup program using InstallShield that included the MSDE files. After I ran the installation, I noticed that the setup created a folder on my computer using the MSDE instance name I told...more >>

I have installed MSDE 1A from the distribution. I have attempted to install the SP4 MSDE distribution several times, using the SAME setup.ini as the one I used to install the intance of MSDE in the first place. I keep getting 'The instance name specified is invalid.'. I have tested connecti...more >>

Hello, When I try to run the setup with the parameters I need (I have a default instance installed already) to upgrade MSDE 2000 the setup program runs with a blue screen on background and a modal window appears showing me the parameters (like /i /p /v etc.). It seems to me that the setup i...more >>

Hi All I am fresh college graduate who has done C and C++ during college times.After that i had done a C# course from one of our local computer institute.The course is BCM which ran for 1 year.But now when i am looking for job the questions asked in interview are really very very weird and does...more >>

Have a log file that seems to be growing out of all proportion to the database. Have tried SHRINKDATABASE and SHRINKFILE Get error message 'Cannot shrink log file because all logical files are in use' As all transactions completed ages ago, am puzzled as to why MSDE seems to want to hang on...more >>

I'm using Msde on a PC with XP SP2 acting as "server" and accessing a database on a PC with XP SP2 acting as "client". I can backup my database from the "client" using UNC format "\\client.computer.name\share.name\file.name.bkp" but when trying to restore it from the "client" PC i get errors...more >>

I installed SQL Server 2000 desktop (much different installation than 7.0!); then I went to fire it up, and discovered that I have no MMC or Enterprise Manager! I thought this would be standard stuff in the XP Pro package; I was able to find it right away when I used to run W2000. Any suggest...more >>

HI How export sql table to ascii file delimited ? VB 6.0, msde 2000 Thanks Jose Perez ...more >>

I am fairly new to SQL development and have a question about task I am trying to do. I have a database where by users submit entries into a table on my SQL server. Is there a way I can setup a Trigger on the table so that when a record is added that I can have a process that then email me that...more >>

Hi! I'm using MSDE 2000 SP4 on local computer. I backed up database into local hard drive using osql command like... OSQL -E -Q "BACKUP DATABASE MYDB TO DISK = 'C:\MYDB.bak'" > LogBackupDatabase.log ....and it's working fine. But when I try to save backup file directly into network d...more >>

I'm trying to install MSDE at c:\Program Files\Microsoft\SQL Server\ (as opposed to ...\Microsoft SQL Server\). I tried using the DATADIR= and TARGETDIR= options, but they don't seem to affect the COM and Tools folders (which always get installed at ....\Microsoft SQL Server\80\). I don't s...more >>

I have a business directory software done in vb.net and sqlserver .We are using msde for distribution purpose .The problem we are facing is about the security of the data . The cd goes to common man and we are concerned about the security of the data.Is there any option where we can ensure th...more >>

Hello, We are using MSDE for our application. The service MSSQL$App will start automatically or when the application is started. While using the application, the memory usage by sqlservr.exe will be increasing and when the application is closed, the sqlservr.exe is not releasing the memory ...more >>

What happens when an SQL2K MSDE database reaches 2GB? I've actually seen MSDE databases reach that size and nothing happened. Thanks, Ademar. ...more >>

Hello, what is the procedure to attach a .MDB databse to MSDE? I don't care using forms or report from the Access database, I just want to have tables and queries on MSDE then I will analyze data and arrange comments to them. Thanks Rocco...more >>