I am developing a vb.net app and want to distribute MSDE with the app so I thought I'd load it onto my development machine which is running SQL2000 dev. BUT the install fails saying invalid instance name. I read a post saying that you couldn't do this with sql7 because it only supports one ins...more >>

How can I remove index scan to occure in my SPROC's execution plan. I would like to replace them with index seek. ~Alok. ...more >>

I am using MSDE on a network with multiple PCs. One PC has the MSDE Database and client applications connected to the database. The other PCs also have Client applications connected to the database. When one of the Client PCs is logged off and shut down, the Applications on the Database's PC g...more >>

can i have more than 1 login ? ...more >>

When I run the MS Access Project wizard I get a project but am unable to make a new table or view, etc. What gives? Any books on this or a place to go read soemthing? Thanks. ...more >>

I cannot put the very long long text into the fields that have text data type how can I extends the length of this data type? Thanks...more >>

Hi, I have MSDE installed on a Win2K workstation and MSSQL$<bla> and SQLAgent$<bla> services are running fine. I established an ODBC data source on that computer and I could successfully connect to the MSDE through the sa account. Howeverw hen I try the same thing from another computer ...more >>

I know default port of MSSQL is 1433, but how about MSDE?? How to change the port no (if any)?? Million Thanks ...more >>

Hi According to various things I've read, XP SP2 will close off SQL Server ports unless SQL/MSDE SP3 is installed. However, I've installed MSDE 2000a (equivalent to MSDE 2000 SP3a) with XP Pro SP2 and no network machine can see the DB server. I uninstall XP SP2 and the network can see t...more >>

Hi All, I'm installing MSDE 2000 with a custom application (launched using setup.exe, not integrating merge modules) and am having a problem with the service permissions for SQL services. The custom app installer is being build with Installshield Pro 6.3. Everything works fine for admin use...more >>

I have MSDE running on my system and would like to make a new project or import an mdb file. When I attempt to make a new project, I enter the Administrator user name and password and then after hitting next, I get the following error: Connection failed: SQLState:'28000' SQL Server Error 1...more >>

Got some problems installing the MSDE I downloaded it from http://www.microsoft.com/sql/msde/downloads/download.asp and ran the setup with the following command: setup SAPWD="testpw" INSTANCENAME="test" It installs, however, the server is never visible by the SQL Server Service Manag...more >>

I have the following SQL query which works great in MS Access 2000 SELECT DISTINCTROW [tbMenus].[MenuIndex], [tbKeymap].[Key], [tbItems].[Item], [tbItems].[price], [tbKeymap].[ItemIndex], [tbItems].[tax1], [tbItems].[tax2] FROM [tbItems] INNER JOIN ([tbMenus] INNER JOIN [tbKeymap] ON [tbMenu...more >>

Greetings, My question is this: We are running MSDE on one of the machines in the office and using an Access MDB to work with it. We would like to install the same setup on a laptop so people can work on the road, and then synchronize the databases when they connect to our network. What is ...more >>

I'm installing Service Pack 3 with the command setup /upgradesp sqlrun INSTANCENAME=home DISABLENETWORKPROTOCOLS=1 /L*v install.log (taken from KB815013). I get two error messages, first "This product is not installed. Check if an appropriate instance of MSDE is installed", followed by "C...more >>

I wish to write a user defined function which will fill a field in my table with the next sequential number whenever the value in another field changes. The problem I have is how do I have the @lastquest and @x variables keep the value that they had the last time the function was called? In MS A...more >>

Is there a MSDE available for Pocket PCs like SQL Server CE? ...more >>

Greetings, I am using an Access mdb with all linked tables in MSDE. I know that you can't change linked tables from the MDB, so I created an ADP that imports all the tables, so that I can alter them in the ADP. The ADP let's me add a column to a table, but when I open the mdb up again that c...more >>

Hi, I would like to install MSDE by selecting options from the screen and not by typing commads at command prompt, just the same way of installing SQL Server 2000. I would also like to change the Sorting and collation options under MSDE. Please Help. Thanks Asim ...more >>

I have a table in Database where I have added and removed rows, during the period of developing applications. Now I have removed all row, but when new are added, their IDs don't start from 1. Is there a way to reset some counter or something? ...more >>

Hi I was wondering if there is any function by which I can read the value in a date field every minute or so to check to see if it has been updated. In MS Access I would have done this using the timer function but I wonder if there is an equivalent in MSDE. Thanks June ...more >>

With SQL Server we are able to link access tables to tables in SQL Server. Can this be done with MSDE? ...more >>

Is the transaction log size part of the 2GB limit? ...more >>

Question regarding the MSDE SP3a install process... What happens if I attempt to install MSDE on a server that already has MSDE installed and the SA password has been changed to an unknown password? Can I still install an instance for my database without knowing the SA password? If not, how c...more >>

Hello All, All you SQL dba guru's. I have na MSDE server. All seems to be working with app but I looked at the server log file and saw that it has grown to 65 gigs. The mdf file is only 50 megs. What is causing the log file to grow so large.? Can I just dump the log file? Thanks, ...more >>

Hello all, Is there away to query the server, a registry setting or some other method to tell if the the server is MSDE or SQL server 2000?? Thanks, Bill ...more >>

Hi all, I get the error message Login failed for user 'computername\ASPNET' when trying to log to MSDE 2000 SP 3 with .NET application. My computer is Windows 2000 + SP4 with latest security patches. I have tried to set the permissions to the database I am connecting (mydatabase) with scrip...more >>

While beginning the .NET Framework SDK QuickStarts install which by default require an MSDE instance named NetSDK the NetSDK instance is shown running when queried via the Services and Application applet but the instance is not present via the SQL Server Service Manager nor when using osql -L to...more >>