How do you start MSDE in single user mode? I have found the scm.exe program and noted that it allows you to stop and start the server. It even has a startup options switch, but it does not list any of the start up options....more >>

Hi all ~ I've got SQL Server Enterprise Manager running on gb-01 and the database is located on gb-02. I'd like to get Enterprise Manager to backup the database located on gb02 to the other server gb01 across the network. Unfortunately, the file system listed inside of "Backup Device Loca...more >>

Given two tables Products and Inventory, I'm trying to set the Inventory QtyInStock = 0 where Products VendorID = 11 and Inventory.ProductID = Products.uid My query generates the follwoing error: "ADO error: Only one expression can be specified in the select list when a subquery is not intr...more >>

Hi, I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer Edition. I then found I could not use Developer Edition with Visual Basic ..net Standard Edition and tried to reinstall MSDE. The installation seems to go fine but when the Service Manager loads is tells me "Not Con...more >>

Hi I trying to make a query which selects the digits, hour and numbers of calls made from one extension (phone), but I get an error "invalid column name calltime" What am I doing wrong here? Can't this be done? select digits, DATEPART ( hh , DATECALLINITIATED ) as calltime, count(*) as K...more >>

I am attempting to install the MS SQL Server Desktop Engine. I have the MSDE2000A.exe file and it unpacks successfully. I then run the setup and get an install fail with the following: Install message: Setup failed to configure the server. See the server error logs and setup error logs. ...more >>

I thought I have successfully restored a backup from another instance of MSDE, however in my .NET program I am getting an error message about the login failed. So what I did is create a login id using sp_grantlogin. I assume that this allows my Windows login to be authenticated. Just in case, ...more >>

Hi, I need to do a couple of things. 1. I need to validate the version of MSDE I'm running. The only version I receive when I do a "help about" is: 8.00.194 I need to make sure I'm running MSDE 2000 as part of a software upgrade. 2. I also want to make sure I'm running the most cur...more >>

How do I copy the data from one instance of an MSDE to another? What I need to do is write the structure, data, etc on a CD so I can copy this back on my server instance at home and work on it. Thanks for the information. Brad ...more >>

Hello. I have a SQL Server 2000 Database set up on our network. We want to run a process on another machine. This machine has MSDE Installed on it. I have created a new entry in the Linked Server options of the MSDE Machine to our SQL Server. However, on trying to query the SQL Server 2000...more >>

I am using MSDE 2000 , I would like to get information from master..sysprocesses table to see what programs are connected to the database. I would to verfy how many times a particular program is connected to the database Lets say i would like to check the number of times program X is connecte...more >>

I installed an MSDE instance for a user running XP with an admin Windows account. The MSDE Server icon appears in the notification area, but without the green arrow. Task manager shows that it is running. Trying to start it up manually doesn't do anything. When I go to add the Data Sou...more >>

Hello, I have installed MSDE on a Windows 2003 server. The MSSQLSERVICE is currently started Local System Account. I would like to start the service in a non-admin account (say msdeuser). So, I created the user and gave log on as service privilege. I have made necessary changes in the Log o...more >>

Hi all, I'm trying to automate the installation of MSDE in my app. So far, so good but now I need to create a user that I will use to start the SQL server service. For a few reasons, including using replication, I need the SQL server account on all machines to be exactly the same. So, I w...more >>

Hi, I would like to store metadata about a table somewhere in the database. Where do I do so and how do I read it back? More specifically, say I want the user to store his userid if he reads/writes a table. The next user before reading/writing that table can check who used it last. Where doe...more >>

Hello, We will soon be moving some distributed apps written in VB 6 from MS Access to MSDE. I was wondering if someone could point me to sources of information that would give us some guidelines, helpful hints, things to consider, etc. Any help you could provide would be greatly appreciat...more >>

Hi, I'd like to install MSDE 2000 Release A on a XP Home machine via the command-prompt switches and parameters. I have two areas of ignorance: 1) At first blush, it seems to me that I'll have disparate server names. By this I mean that when I install MSDE on my computer to conduct the d...more >>

how can I change the server name?...more >>

Hi, If I install MSDE on a Windows XP Home machine, will it start as a service? If it does not, is the best way to "autostart" MSDE to use "Scheduled Tasks"? Thanks very much, -- -- Mark Holahan ...more >>

I am currently running Windows XP SP2 Tablet Edition running MSDE v 8.00.761. The problem I am having is that at random intervals MSDE fails to start. I can only duplicate this problem while running under a restricted user account. In the error logs the only difference I can see is that ...more >>

Hi! I've tried to install and reinstall (after thourogh removal) MSDE 2000 A. It always hangs! I've followed this document, but nothing helps. http://download.microsoft.com/download/d/5/4/d5402c33-65de-4464-9d82-d1de2971d9db/ReadmeMSDE2000A.htm It seems in the install log, that the exe...more >>

It seems that the MSDE running SP3a is eating up about 100MB every few days on my system. Once I reboot it settles down but starts it up again. Is there a memory leak? Is there a way to calm down the SQLSERVER.EXE memory usuage? Thanks...more >>

First, let me apologize for crossposting and the lengthy post, but this question involved both MSDE and (I believe) security settings. We use Visual Studio .NET 2003 with MSDE in classrooms and labs and have had no security issues once things were configured properly for student access. The ...more >>

Hi, If I have a change in a row in a table in a database, is it possible for MSDE to notify other users (connected to the same database) that the row/table has changed? I'm thinking of something like events (like in C# forms- control.OnChanged etc.). Or do I need a custom DataAccessLayer to ...more >>