MSDE 2000 Release A does not support merge modules to embed MSDE with custom application setup. I went through MSDE Bootstrapper Toolkit and apparently it is still in beta. How would I distribute my application? Is there any other way of embedding MSDE 2000 Release A with setup package? ...more >>

salve, a chiunque possa interessare... presso http://www.quest.com/quest_central/sql_server/freeware/ , Quest Software mette a disposizione, con licenza gratuita, un potente strumento di amministrazione per SQL Server.. ".... Quest Central® for SQL Server is an integrated database management...more >>

Hello, I have a problem with one of my SPs with a FOR XML EXPLICIT line. I tried it on a SQL Server 2000 installation and it works fine. Anyway, I've tried it with some of the MSDE GUIs (both standalone's and WebServer Based) and it doesn't come up with the output. On the MSDE version when ...more >>

Hello everyone. After finally getting MSDE installed, I am having trouble with instances. At bootup the instance that is loading is the wrong one, and is not working. The instance that is loading is just "computername," and I need "computername\instance" to load. I have checked the reg...more >>

With Acces 2000. When i go to migrate a BD in Access 2000 to MSDE. Acces 2000 gives me an overflow error. I suppose it is an overfolw error ( in spanish DESBORDAMIENTO) Is it possible to migrate from acces 2000 to MSDE ? ...more >>

I am distributing my application which includes MSDE 2000. My setup program attaches .MDF and .LDF files once instance of MSDE 2000 is installed on the customer’s computer. Now my worry is how can I restrict customers running W2k or XP from accessing my database using EM or third party GUIâ€...more >>

MSDE SP3 install - is there a way to get the install process to set "start when OS starts"? Preferably something that is part of the MSDE install and not a separate step. Like some setup.exe or setup.ini option. Carl K -- http://www.personnelware.com/carl/resume.html ...more >>

Okay, I know this subject has probably been beat to death, but here is my situation: I have an instance of MSDE over a network. I created a VB program that uses the MSDE instance as the data store. On installing the program on a couple of PCs the program works just fine and I do not get a...more >>

I am getting ready to deploy a manufacturing application that uses a SQL2K MSDE database. It is not a very large database but it gets updates every few seconds, so it is very active. When I first start the application, the total memory allocated to SQL (as seen in task manager) is about 6M....more >>

Hiya folks, I'm a newbie at this, so forgive the ignorance that I may display! I have installed a software package on my system that installs MSDE through merge modules contained in its MSI. I have several workstations that connect. Unfortunately, with SP2 coming down the pipe for window...more >>

Hello. I've installed MSDE (Win2k machine, running asp.net on localhost), and it says 'Not Connected' when I mouseover the icon in the system tray. I opened the SQL Server service manager, and there are two empty fields- Server and Services. Please, what do I put in these fields? Also, what conn...more >>

I'm running Server 2003 Standard Edition... I'm having problems installing MSDE (light). Is it mandatory to run Server 2003 Enterprise Edition in order to install MSDE? Thanks! CJ...more >>

Hello, does any body know if it is possible to install MSDE on WIN98 and to get a "trusted connection" with it ? I can only connect with the sa user. Thanks ...more >>

I am migrating a little VB6 app from Access to MSDE that among other things has to rename some tables in a database. That can be easily done with Enterprise manager, but in my case has to be done programmatically through ADO. I am wondering if this is possible, and if so what is the syn...more >>

Hi All ~ I used the SQL Enterprise Manager to export the database, several times successfully, between two nodes. During the last two attemps, the largest table (called item) does not import the data only the table definition. There is a item$ table that looks like it's twice the size of t...more >>

Hello, I must make a setup that will Install MSDE, restore a blank database and install my application. I have already made it with no problem, but now I run into a very big problem on some computers with Win 98 and NT4. These computers don't have file sharing (on 98) or no server service w...more >>

Can’t a client easily register an instance of MSDE using any third party GUI or EM and get hold of our data structure? How can I over come this issue, if I am installing MSDE on client computer? thanx...more >>

Hi All. How does file locking work in MSDE? Coarse grained, fine grained? Thanks Chris ...more >>

Hi All, Is it possible to create a database (databse.mdf file) at a specified location using OSQL ? Thanks in advance for any help, Piyush ...more >>

Hello everyone Was anyone experienced problems with MSDE after XP SP2 was installed? I have a client's computer that is running MBS Great Plains using MSDE SP3, that now is displaying an error on boot that it cannont find the default instance of SQL. Looking at the event viewer, I noti...more >>

Does MSDE support triggers? ...more >>

I am using VS .NET 2003 Bootstrapper Plug-In to create an installer that redistribute the .NET Framework 1.1 and MDAC 2.8 with my application. How can I include MSDE and provide the switches in order to install MSDE on clients machine as well? Thanks...more >>

Hello, I am curious if there is any limitation on replication between MSDE and sql2k? Can you use merger, transaction, or snapshot? We have data being passed between a sql2k box and about 80 latops which replication option would be best for this as both the server/client have data that nee...more >>

I've successfully installed MDSE2000 on a Windows XP Pro machine. I am using Visual Studio .Net 2003 to create web applications that access one of my databases. It all works fine, except for one thing that is driving me nuts. I can't specify "integrated security=true" or "integrated securi...more >>

I'm very new to MSDE, so this may be a basic question but I've been unable to find a solution. Is it possible to migrate a database from Access to a Sqldatabase in MSDE? If so, how? The Access Upsize Wizard doesn't seem to do it? Thanks in advance. ...more >>

I make backup from SQL Server 2000 and distribute this backup to our customers. They install MSDE 2000, and I can't garantee what COLLATION they will use. How I can modify the COLLATION of the database after restoring it? Thanks in advance. ...more >>

I am trying to install MSDE2 on Win2k server with SP4, as with many other posts when I try and install it just rolls back. The error log generated lists Starting custom action NoRebootReplace TempFolder Property is C:\WINNT\TEMP\ Source Dir Property is C:\WINNT\TEMP\SqlSetup\Temp NoRebootC...more >>

I have SQL 2000 with an active database running on a W2K3 server. I have another application I want to install on it since the box is under utilized. The new app wants to install MSDE for its database engine. Is this OK? Can MSDE and SQL 2000 run on the same box? I don't - actually ca...more >>

I am very very new at SQL and MSDE, however I have the following question, hopefully an easy one. We have been using an instance of MSDE on a slower smaller PC and recently installed the SQL Server 2005 Express Edition Beta 2. We are not yet fully going to this Beta yet. How do I copy d...more >>

Hello, I'm opening an ADODB connection to an SQL database in VB6 using the adModeShareExclusive mode for the connection object. The connection opens successfully, but I'm still able to modify records in the database using Enterprise Manager. Why is this? I want to open the SQL database and ...more >>

Hi! I wrote couple of stored procedures but now I forgot what code they exactly executed. How can I view stored procedure code with OSQL ? Thanks. ...more >>

Hi all, I have a customer who is trying to change their sa password in MSDE 2000 using the sp_password procedure. When they attempt this, they are returned the following error: Msg 552, Level 16, State 1, Server abcdef\inst, Procedure sp_password, Line 63 CryptoAPI function 'CryptAcquire...more >>