Hello all, My app uses MSDE to sotre data, but raw data in database are not supposed to exposed to end users per my view. I found that users can attach the data file installed to another database and then see everything in the database. That's what I don't wanna see. Per my thoughts, users ar...more >>

Hello, I have MSDE Installed on a different computer (WIndows 2003) within my network. I also have MSDE Installed on my production computer for development. I have successfully created databases on both computers using OSQL. What I would really like to accomplish is a connection from t...more >>

I have a client that is using MSDE as a back-end for a site built in ASP. The database features a product database with over 300,000 records. One of the search options on the site is to search a description field, so we are using the LIKE clause - the problem is that the search takes ages to ...more >>

I'm using VS .NET 2005 which I understand has SQLExpress built in. I've modified the Personal Web Starter Kit and would like to know what the process is to upload the db to my Hosting Service. The Hosting Service claims they support VS .NET 2.0 and SQL 2005. I notice the mdf files are stored ...more >>

Is MS planning to add support for installation of Windows Installer V3 on Win98? SQL Native Client requires this to be able to install it on Win98. Or does SQL Server driver (older driver for sql server) works with SQL Server 2005 Express? Thank you -- Dejan Rodiger - PGP ID 0xAC8722DC D...more >>

I have a client who is being told by their Database Vendor that they need to purchase three licences of SQL-Server 2000. One for the server and one each for a laptop that will be used out of the office. Firstly our client already has the server copy as part of SBS 2003 Premium. My question is;...more >>

Hello, I have an access database that I am trying to upsize to MSDE. Everything works great except when the upsize takes place it does not transfer the data that is in the tables (only the structure). I do NOT have the wizard set to do only the structure, so it seems odd. I have update...more >>

I have a client that is using MSDE as a back-end for a site built in ASP. The database features a product database with over 300,000 records. One of the search options on the site is to search a description field, so we are using the LIKE clause - the problem is that the search takes ages to...more >>

Has anyone found equivalent for the SQLAgent service for MS SQL Server 2005 Express Edition? ...more >>

I previously had a web server that was running a application that used a MSDE database. This server had a motherboard failure and I was not able to repair it. I did get all the data off the drives so the MSDE SQL databases did get copied. The problem is the admin password for those database i...more >>

Hello, According to documentation I'm supposed to be able to deploy SQL project = directly from VS2005. I don't have Either Build<project name> under = Build menu, neither I have Deploy <project name> for my SQL project. What am I doing wrong? To deploy items in a SQL Server project to ...more >>

I have an MSDE installation that I need to connect to within a C# .NET project as a Limited User (from the same machine, not via the network) The MSDE instance is not in sql authentication mode, only windows authentication. Is this possible? I've used the 'Trusted_Connection=True;' in the ...more >>

hi Andrea Here am using "Use Database" keyword, as the connection string will contain a different Initial Catalog Pls let me know is there any Technical issues to execute this query (Its working fine-) Public Function GenerateCreateIndexQuery(ByVal TableName As String, _ ...more >>

This is a general question " xpsqlbot.dll" what is it doing running a SP? My environment is SQL 2000 sp 3a One problem I am having is a database is transaction log is being truncated during the nightly SQL backup. All other SQL functions appeared to be running normally TIA Jim ...more >>

Hi I cant install MSDE 2000 on one XP machine Cant figure out whats wrong Because log file too large Download it here www.deltmar.ee/logfile.zip Regards; Mex ...more >>

Will my 'smart device application' designed with VS.Net 2005 allow my ce device to pull data from a SQL Server EXPRESS 2005 database residing on the server computer? Or must I be using the full version of SQL Server 2005 to accomplish this movement of data between my ce device and my server ...more >>

I just installed MSDE 2000 Release A. I expected to see an icon in the system try which lets you start and stop msde. I've seen this before, but it didn't appear on my machine. Can I get this icon to appear somehow ? Thanks... ...more >>

it seems that the SQLExpress2005 Management Studio Express has no DTS functionality ... is there a way to automatically export an SQLExpress2005 database (or parts of it) to Access and/or Excel ?? thanks -Michael ...more >>

I've seen a number of reputable NG posts (including one from an MVP) reffering to the 5 concurrent connection limit of MSDE. However I found this MS site reffering to an 8 operations limit for MSDE? "The Microsoft=AE SQL Server=99 2000 workload governor is designed to limit the performance ...more >>

Hi All I have a bunch of test/demo servers running on VMware Workstation Some of those is running Axapta 3.0 sp3 demo version with MSDE 2 as the data engine (named instance) I have moved the VMware files around from one host to another OS starts nicely, I get an IP and get access to the ...more >>