I've read that MSDE will cease to be supported and developed from 2007 some time. What is the alternative DB to use once this happens? Is there a MSQLFree for example? cheers gerryR ...more >>

I'm using MSDE 2000. How can I make a multi-field unique index? Doesn't seem to be a way. Thanks. ...more >>

I can't create a db because my doc.mdf already exists. I've stopped the server, deleted this file as well as it's related file and made a new db but now I don't know where the two new files are located. They are not in the same directory as the other dbs. What should I do? ...more >>

I downloaded SQL Server 2000 Service Pack 4 and installed. I setup it up by typing in the command line: setup SAPWD=”sapass” SECURITYMODE=SQL It started but up to "Gathering required information", an error box poped up with message: "unable to determine system defaul...more >>

Hi All I'm using McAfee ePO here which uses an MSDE database. I am trying to run the recommended maintenance command on the DB but keep getting an error. It seems to be related to the -U and -P account I'm using but I've tried every variation of user and password it could be including domai...more >>

I have a fairly large database that takes up around 7GB of space on my hard drive and on top of that, one of the tables in the datatbase with about 25 plus columns has 4 million rows. The problem I am getting is whenever I restart the SQL Server service or at bootup, my database shows an (In ...more >>

Hi, I have a small problem and I suppose the solution to be very simple but I don't find it and I'm blocked. I have to build a query that will merge some information from a database of a provider and our sql server. When I test the query, it returns me an error saying that the remote ser...more >>

Hello. I have had MSDE installed and running for some time and a few days ago I installed Microsoft Visual Studio.Net 2005. During the installation, MSSQLExpress was installed so I think that I have two engines running. While MSDE icon is visible in the Notification Area, MSSQLExpress...more >>

Hi all, I've just started dabbling with SQL Express (I've an up-coming project and would like to use it). I had no hassles connecting to the db I created in VS2005 std but now I want to test connectin to it outside of the inetpub. I copied the MDF and LDF to another folder on my drive and chan...more >>

I have a SQL 2005 database with 4 million+ rows. One table in particular has about 35 columns. I have implemented a paged data grid results view for them. They want to be able to sort on the majority of the columns. When they sort they want all the results sorted not just the visible r...more >>

Hi All, I am using xp_cmdshell bundled with SQL2K to copy a file from one location to another on the same machine. This sometime works and sometimes fails and return an error code as 128. The documented return codes of this extended procedure is only 0(success) and 1(fail). Has anyone faced t...more >>

Does anyone know if it is possible to apply Failover clustering service over 2 servers with MSDE? ...more >>

I am building an application with a SQL Server 2005 Express backend. I would like to create a secondary instance the database on another server that will serve as a fail-over in case the primary server goes down (there is only the Express version of SQL Server in this picture). I see that repli...more >>

Hi! I got this message when installing MSDN2000 and WSUS. sql server could not find the default instance - please specify the name of an existing instance on the invocation of sqlservr.exe Any idea how to solve this? Thks!...more >>

Hi All, I am learning SQL using MSDE 2000 and I have taken the below stored procedure out of Books Online, making a few changes. ALTER PROCEDURE StoredProcedure1 AS CREATE TABLE Employees ( ID int CONSTRAINT PK_id PRIMARY KEY IDENTITY (1, 1) NOT NULL, Name char (5) NULL, Inactive b...more >>

I'm an ISV, and currently the main "shrink wrap" application that I develop uses MS JET 4.0 as the backend database. My application's "document" is just an mdb file (with a file extension that is associated with my app). Deployment is quite simple, and from my users' perspective it's complete...more >>

What is the maximum DB size for MSDE... 2 GB per DB?...more >>

Hello Everyone Has anyone out there began research on what to do after MSDE is no longer supported after 2007? I am concerned about products that I have it integrated into after this date. I can not find any clear explanations about the legal implications of this. Has anyone seen any defini...more >>

Hi, I'm using the most current version of MSDE, I've ran all my updates on a 2000 Pro machine. Someone else did the install and I'm receiving an error message that SQL is not installed properly or has been tampered with, pleas uninstall and reinstall, so I went to the add/remove and uninsta...more >>

Hi all... alright I'm at a loss here... I'm using BCP to import data into a table in my database.... I keep getting an error of " unexpected Eof' or somthing like that, so I figure my problem is with the text file i'm importing from. To see if I was barking up the right tree, I created a ...more >>

Hi, I'm getting the following error when I use BCP to import a tab seperated file exported from Excel. I hope someone can help me figure it out. I'm using the following command: c:\>bcp myComm.dbo.cmrc_products in test2.txt -n -T -Sbiff\sqlexpress SQLState = 22001, NativeError ...more >>

Customer is trying to restore a backup of their database. SQL Server gives the error: Cannot use backup file %s. Originally formatted sector size 512 and now device sector size 2048. Only one guy (in Germany in March 2000) has ever seen this error. And he never got a resolution. ...more >>

Hi, i am using Express Edition in a medium scale web project. As the perfomance throttle has been removed compared to the Desktop Edition I thought this was a possible solution as the other limitations (CPU and DB-size) are good enough for me. The problem is that I am getting connection t...more >>

Is there any way to automatically create a "CREATE TABLE" statment using an existing table? I would simply want to execute this statement and it would create, in another database, a table with the same structure (no data). Is there a way to do this? cheers nathan ...more >>

I am trying to login to the WSUS instance running on MSDE. I keep getting the access denied message when trying to connect using osql. I have tried osql -E -d WSUS and osql -d WSUS -U username but I dont know if I am just putting in the wrong syntax here or if WSUS has something special about...more >>

I have my database on the E drive. It's a partition on the same physical hard drive as C and D. It's on a Windows 2000 SBS box. I noticed this morning that the database was marked as suspect. I checked the file system and both database files are still there. I detached the database and tri...more >>

I have MSDE installed on a number of windows 2000 servers. Some of these servers have developed a problem running a scheduled task which seems to be caused by the SQL agent. When i try to stop the agent is will not stop, asks if i want to stop the agent but then doesnt do it. This is resolv...more >>

Hello, I am having problems with an installation of MSDE. The computer alraedy has an instance of MSDE installed with Outlook for the Contact Manager and I have no problems with that instance. A new application I have installed also uses an instance of MSDE for a database. During the instal...more >>

Hello, All Sorry for the cross post, but thought these three groups would be best suited to answer my question. I would like to write a VB.Net app that will take an Access 2000 database that has tables, relationships, and data (no queries, forms macros, etc), and create a corresponding SQL Ex...more >>

Hi all, I am trying to configure a pull merge subscription in MSDE (2000, not sql express) at installation-time and am hoping someone can help. Here is my situation: I have a publisher/distributer on machine X. I have a client application that uses MSDE as its db. I want to have an in...more >>

I have just installed VS2005 along with sql server express. I couldn't connect from vs2005 to express so i specifically enabled tcp/ip and started the sql browser service. I then tried to connect. Still had problems. So i went and enabled named piples. I tried again and it still failed. I have...more >>

Not sure if this is a MADE or Visual Studio issue, but here goes: I have MADE and SQL Server GUI tools installed (GUI from Developer Edition) to support database app development with Visual Studio .NET 2003 (VS 2003). I have the sample databases installed (pubs, North, etc.) via an executable ...more >>

I installed SQL 2000 MSDE 2000RelA on Win2K Adv. Server w/ Win2K SP4 (fully patched), and operating as the only domain controller. I have also run the IISLockdown Tool on this server. I originally ran setup using the following parameters: setup sapwd="xxxxxxx" and SQL Service Manager was co...more >>

It's possible to create a maintenance plan with Enterprise manager in my MSDE db? When I try to create a "maintenance plan" I have blank menu (for example "Use this directory" or "remove files older than" or "backup file extension" ). Any help will be appreciated. Thanks...more >>

Hi all, I've been progamming for some years now and only now do I have a situation where I may choose the back-end db for a small new application - I was thinking about SQL Express. Firstly, I have SQL Server 2005 and Analysis Server 2005 running on my machine as well as Sharepoint Porta...more >>

Hello there, Is it possoble to to do MSDE backup from windowsXP- Control Panel(Admin tools) by stopping the service, copying mdf anf ldf files.? Does any body know how to restore from there then? ...more >>

Ok - now that I have a way to manage my Sql Server express files through management studio, is there any way to import data from a csv or like file without having to go through the trouble of using BCP. I see that I can 'script' a table to 'insert to', but I don't think this is what want. B...more >>

Hi all, I'm a newbie so I won't mind if you roll your eyes as you read this.... I have sqlExpress installed on my machine and its working beautifully. I have used SqlExpress and msde in the past for web development with great success, but I have always had an issue managing the databases i...more >>

Hi, I have seen hundreds of suggestions on how to backup a MSDE database on the net, most of them have different approaches. Does it exist an 'approved' way of doing this? I need to run a .bat file which backs up my MSDE database (i.e. stops the server, performs copying and the starts the...more >>

i have 2 computers 1 desktop dell the other a hp laptop both run windows xp home , but only the laptop will show the sever running. I would like to get the same on my desktop but i do not know how if someone could show me how to set it up on desktop i would appreciate. ty john myrick...more >>

Hello! Can anyone tell me what happens if the database size in MSDE exceeds the limit of 2 GB? Does the database ignore new entries, or maybe delete the oldest entries? Greetings, Chris ...more >>

OK, I am confused with this specific security issue. I do not have access to full SQL Server 2005, only the Express edition, which came with no documentation. I have been reading through the MSDN online files, but I get more confused than informed. This is a 'standard' installation of SQL E...more >>

Is it possible to run both MSDE and enterprise edition (sql server 2000) on the same box? I am working on an application that will include MSDE, and I'd like to test it on my developing machine that is already running Enterprise. I could just shut off Enterprise, but the MSDE needs to be a...more >>

When I attempt to make aview I get the error: Microsoft Access can't start the client server visual design tools. This feature is not availabel. To make this feature available please run setup again, select "Add or Remove Features"..... When I run the msde setup again I don't see any optio...more >>

I don't think I've ever worked so long and tried so many suggestions, recommendations and followed KB article processes in my life with so little success -- in fact, none -- and so intransigent a set of symptoms. I hope that there is someone here that will be able to help me. To set the ha...more >>

I'm familiar with ms access, but not with msde and ms adp type projects. Is the adp file similar to a frontend in access and the sql server tables the backend so I would distribute the adps to the workstations. If so, how do I link to the sql server from another workstation. Is there a url...more >>

A customer of ours is unable to install MSDE SP3 on any of his 3 Dell Dimension E310 PCs. When enabling the verbose logging during setup all 3 computers come back with EXACTLY the same log (shown below). The computers are running Win XP Media Center Edition. They all have File & Print Shar...more >>

Hi I'm looking for solutions to notify a client application when a database change occurs. I have a Windows application written in VB.NET Thanks...more >>

Hi How much does BruteForcing affect SQL Server(MSDE) speed? If 5-6 connection attempts are made per. second? Best regards; Meelis ...more >>

Hi, We have multinational customers who run our software against MSDE which we ship. The MSDE we ship is MSDE 200 Rel A, as downloaded from the English link. Whats the difference between the English and Japanese version in terms of configuration? Our Japanese customers are running the...more >>