I understand for Win 2k and XP installs that a simple re-boot after MSDE installation will start the MSDE service, but for 98/SE/ME, what is required? Does the user have to go to Start Menu and start the service? I do not want to complicate the installation routine by having to determine the ...more >>

I am using VB .NET to convert data from Access to MSDE. While I am transferring table by table, the memory usage of 'sqlsvr' keeps increasing, and also CPU usage is @ 100 % Some Tables have more than 10,000 records. Is there a way to reduce the memory usage or an explaination why would memory ...more >>

I have a db on msde on one server. I"d like to replicate it by restoring a back up on another PC with a newly installed MSDE. I create a shell of the DB I create a user name which my application uses to login with SQL authentication. I give the user db access to the empty-shell to be filled in...more >>

I'm also interested in any white papers, books, etc for using the SQL server engine for commerical purposes I'd like to know about installation, configuration, etc, basically everything one should think about when working a commercial application. Thanks ...more >>

I am trying to create a maintanence plan for a MSDE database using Enterprise Manager. Under my MSDE SQL Server/Management, Database Maintenance Plans icon does not show up. In my three other SQL Servers (1 MSDE, 2 SQL 2000) this icon does show up. And I cannot right click the database and ch...more >>

Hello, I'm usng MSDE2000A (not MSDE2000) The MSDE2000 documentation speak about 5 concurents operations limitation. The "Approriate uses of MSDE Faq" speak about 25 concurents users (means concurents operations?) http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp (see the "Can I u...more >>

Hello, On my Window 2000 machine I was able to install MSDE one time. However, was having trouble actually connecting to the new database server so I though I would reinstall. Well, I have not had a succesful reinstall yet (I was closer the first time around). Now, I am a long ways off from...more >>

A recent MSDN magazine article decribed SQL Server's Reporting Services. Will Reporting Services work on MSDE? TIA! Wayne P. ...more >>

I have installed SQl Server Developers Edition. The Icon appears in the lower right panel of Windows XP. It has a red square indicating that it's stopped. When I try to Start it I get an error message "The service did not start due to logon failure" error 1069 Did I install it incorrectly or w...more >>

I need to put a date into and SQL insert statement. What charater is it that the date needs to be wrapped in? Thanks Lee ...more >>

It's possible work fine with msde 2000 with 50 users concurrent. Thanks for all ...more >>

I installed MSDE (sp3a) in a Windows 2000 server SP4. This is configured to be a domain controller and (AD turned on). I can use MSDE webadmin to access the database instance fine. I have a couple of problems. 1. MSSQLServerADHelper service does not startup. System log message is: The MSSQ...more >>

Hi! I have been looking for a complete command reference to osql. A document that describes all possible SQL commands that you acn use. Unfortunately, I seem too stupid :/ I haven't found: * the complete desciption of BACKUP and RESTORE * a way to show the table definitions. TIA, ...more >>

Please help, I have a question on MSDE2000A's setup.exe. In running the setup.exe /?, it brings up a screen saying that it has an option called: "Display", which can be set to to things like [no | basic | reduce][completion notice] UI: /q[n|b|r][+]. But I can not find documentation for what the...more >>

How do I restrict an update trigger to just the rows updated? Would like to have two audit fields with user and time of modification for updates. The following trigger would attempt to update all rows in the table: ALTER trigger tm_stmp_admit_proc on dbo.tblAdmissions_procedures for upda...more >>

Hello to all first...As the subject says I am interested ist my DB quick enough, or better is there a good buisness logic.the next query is executed on C600,192 MB Ram, Seagate HDD, with 7IE's opened, OExpress and EMS MS Manager in 14.90 sec.The query is for reporting a warehouse components of s...more >>

Have used Access 2002 but now want to understand the Microsoft suite of products and when each should be used. Can anyone direct me to documentation that explains what SQL Server, MSDE etc are, and how they relate to each other (if they do relate) and also explains when and why you would use these o...more >>

--------------------------------------------- Hi all, 1) I was wondering if it could be possible to establish SSL connection between an Access front-end and its MSDE server in an Access Data Project. 2) Also, compared with MSDE, do you recommend MySQL as the server for MS Access front-end?...more >>

Finally got to the point where I can connect to MSDE from Access. If you are setting up MSDE for the first time, you may find a couple useful points in the following. MSDE 2000 with Access 2003: The First steps. 1) install MSDE from Office CD (need to locate in MSDE directory by browsing and s...more >>

Installed MSDE, can run osql from the command line. However can not connect Access project to an MSDE database. The reply is: "Test connection failed because of an error in initializing provider. Cannot open database requested in login '<database name>'. Login fails." Using Win XP Pro, Access...more >>

I installed Sales Logix (a database program) which uses SQL Server MSDE. When you install Sales Logix, it installs SQL Server; however, I was having trouble getting SQL to install so worked with a Microsoft tech and we got a default instance of SQL Server MSDE installed. Now, when I try ...more >>

Hi there, I am working with MSDE2000 at Windows 2000, MDAC 2.8, accessing via ODBC from C++ (Dev Studio 6). I have a table that has a TEXT column and each time I try to insert a value into that column that has more than 256 bytes, I get: SQLState 22001: String data right truncation ...more >>

hello every body out there i've just installed MSDE on my system, but not able to login into it by using sa account that i've supplied in the SAPWD attribute. I am able to log into it by using windows authentication. So any body can help then thanks in advance...... Ajay ...more >>

Hello there I have small application on sql server that on the start will run on stand alone computer The system is Win98 or XP (not nt, or any server systems) What i need to do to install there the program? ...more >>

I am investigating the use of MSDE to have a local replicata of a SQL Server based database. Has anyone tried this?...more >>

I'm using Enterprise manager on an XP MSDE installation to delete a column from a table for which I am dbo. I selected a table, right click and select 'Design Table', right click the column I want to delete and select delete. Column goes away in this view. Close the form and reply yes t...more >>

Hi all I installed MSDE on my Win2K machine. I then ran the SQL scripts to create PUBS and NWIND. These created ok and I can connect to them and navigate the tables using the .NET IDE. However when I try to debug a stored procedure in NWIND I get the errror: "Cannot debug stored procedures b...more >>

Hi I am about to write my first strored procedure and would appreciate some advice. Can anyone tell be if the following is feasible. I have a record in a database that a user updates over a web interface. The updated record is sent back to the MSDE database. I would like to use a trig...more >>