Hi, I have MSDE (SQL server) running various workstations within my home network. I have no problem connecting to the SQL server instance on each local machine but when I try to connect to a SQL server on one of the other workstations I get errors indicating that the Server cannot be found. ...more >>

Hi, I cannot seem to create a server instance when installing the MSDE. step 1. I launch my cmd. It pops up with (C:\Documents and Settings\Billy I type setup instancename="netsdk" sapwd="sa" I immediately get a status message saying go to the control planel and install and configure sy...more >>

I have a W2K Server with SQL Server 7 and an instance of MSDE 2000 installed. SQL Server 7 and MSDE 2000 both run OK together (I can make ODBC connections to their databases from other clients, Enterprise Manager and dbamgr2k work) and the MSDE 2000 backup jobs run successfully. However, th...more >>

Can I simply backup a database currently on desktop edition an restore it to a different server running Standard Edition (sam service pack)? Or do I need to use DTS to move the database? Ar there any gotchas that I need to watch out for Thanks ...more >>

Lets say Select * from Table returns 100 rows. How can I get only get the First 10 records , 2nd 10 records, etc ... I now select Top n selects the top n rows from a query, but is there a supported way of asking for next 20 rows after the row 50? Thanks Arjang ...more >>

I have recently installed MS Office 2003 on a new machine running as a storage machine on a peer to peer XP Professional network. I followed all the instructioons and allowed only the login password to be changed. I am now hoping to connect to the SQL Server instance from a desktop PC (i.e...more >>

Hi I installed MSDE 2000 using the sql2k32desksp4 downloaded from microsoft. But, I have problem when I created a table from Query Analyzer, it will be read-only and I can not add data into my table in the database. I try to use stored procedure to create, same thing happen. In my stored proce...more >>

I have a server with MSDE7 installed, for use with Veritas BackupExec 9. On the same server I want to install WSUS which needs MDSE2000. Can I install both MSDE7 and MSDE2000 on the same server?...more >>

Hi Everyone, One of my clients is running SQL 2000 SP4 and the Data Maintenance Plan logs shows a log with... ---- Database master: Check Data and Index Linkage... [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not...more >>

Here's something that will make you scratch your head! I have a table that has a UniqueIdentifier as its primary key, but also have an autoincrement column (InvoiceNumber) that is not part of the primary key. This table contains about 3000 records. But for an unknown reason (UFOs???), the...more >>

On a Windows 2000 server I'm going to install MSDE. What other software do I need have installed? MDAC? ..NET? Other? Thanks Kelvin ...more >>

Why would the localhost not install but rather our named instance will install? We have an inconsistent problem with installations. Our app depends on a named instance and a secondary app depends on local host so we need both. However, systems that have previous installed, uninstalled and try...more >>

I try to connect to a SQLserver by SQLDMO, "Timeout error" occured in the following line of code: MySqlServer.Connect ServerName:=sSRVNameDMO, Login:=sSRVUserDMO, PASSWORD:=sSRVPassDMO But I can connect using Andrea Montanari's DbaMgr2K. Please advice me, how to do. Many thanks....more >>

Strong SA Password to install MSDE? How can I tell if MSDE is on my machine already? If not how to do I assigne a Strong Sys Admin Password to install MSDE? John "J.J." Jackson...more >>

Hi All I have following questions regarding C# Assembly and Threading. Let me know the precise answer or lead me to the proper materials. 1. Is memory leakeage possible in .Net Manager Code ? 2. Is memory leakage possible in .Net Unmanaged Code ? 3. How can I find the what % of memory i...more >>

Hello, I admit I am completely ignorant of MSDE and SQL in general. Ive developed many things with php / mysql and a few with access but MS SQL is a completly new beast for me. Ive been told i need to develop it locally with MSDE then upload the finished project to the SQL server and just ch...more >>

I Can attach db from MDSE 2000 Sp4 to MSDE 2000 Sp3a? ...more >>

Like a lot of other people I am having problems installing MSDE2000 on W2k3 server. I have edited the registry by dleting instnace of SQL, deleted program File listing of SQL, etc. I ran install with following command: c:\sql2ksp3\msde\Setup.exe SAPWD=Whois2005 /L*v C:\MSDELog.log INSTANCENAM...more >>

I have downloaded and installed MSDE. I try to configure by entering osql -S(local)\VSdotNET -E at a command prompt. I expect a 1> prompt. Instead I get [DMBSLPCN]SQL Server does not exist or access denied [DMBSLPCN]CONNECTION OPEN (CONNECT()) Please help or point me to a source to correctl...more >>

Hi, I’m working on a project that has MSDE installed on a Server (Windows Small Business Server 2003 Standard with Veritas Backup V.9.1) for the back-end database and for the front-end an Access Project (.adp) which I plan to have on each user's computer. The Server Administrator is pushin...more >>

In my sql log I see the 'starting up database DBtest' repeating every few seconds. The database seems fine and I can retreive data from tables of the database. I've included a short clip of my log. I think something is wrong here. Anybody have any clues. My first take is to terminate the...more >>

Hi all, msdbdata.mdf is missing after I install an instance of MSDE. What could be causing this? Thanks ...more >>

Hi All Having 'Google-ised' I've found that there does appear to be a problem connecting to an MSDE 2000 DB from a remote machine (either LAN or WAN), but I haven't found what the concrete solution is. It definitely appears to be a Windows inflicted problem, as I can connect to the DB no...more >>

I've successfully applied SP4 to an MSDE 2000 installation on a Windows 2000 Professional system. Now I've notived several \Backup subdirectories in the "Microsoft SLQ Server" directory. Since I don't want to go back to any previous version, these subdirectories appear to be no longer required. ...more >>

Hi All I am upgrading a VB6 program to VB net 2003 which uses MSDE 2000 RelA In vb6 I called a function... retval = ExecCmd("osql -E -i """ & path & "\sql\CreateTramcars.sql""") which ran the TSQL script against OSQL. The script basically created the Database in MSDE then imports a heap...more >>

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 >>