Hello, is ther a way to connect to the command line for MSDE. I want to export data from the MSDE database with a command line script! How can I accomplish that??? Thanx, M.J. ...more >>

I have found conflicting info on Microsoft's website in reference to the processor requirements. In one instance it says that the processor must be a Pentium. Another instance it says Pentium or compatible. Has anyone had an issue installing MSDE on a computer with an AMD processor?...more >>

Hi, I am trying to connect remotely to a client's MSDE database with my SQL Enterprise Manager so I can administer the database. I have established a VPN to the client which I can ping and terminal serve into the server but I cannot register the server with the SQL Enterprise Manager. I h...more >>

Which version of MSDE 2000 should I install when installing on a new computer? The one 'Microsoft SQL Server 2000 Desktop Engine Release A' which is about 42MB? Or the SQL Server 2000 SP3 version? ...more >>

How can I change the collation order for a msde db? With SQL Server I use Rebuildm.exe utility, but with msde that file is not present. thanks, AF...more >>

Plz Help me. Auto shutting down of my sql service manager. what i will start it, but the server is shutdown after 30 seconds. that is why i can't used any services. Please to help me, what about to start of my sql service manager and matained of sql server 2000 (enterprice)? Please a...more >>

I've installed the MSDE and my taskbar icon says it's running. I'm then trying to create an Access project (.adp) and and I'm faced with the connection screen. I type "local" as the SQL server name and check "trusted connection". I then get an error saying: Connection failed: SQLstate: '0100...more >>

I'm trying to install an instance of MSDE on a dell poweredge 1650 server running windows 2000 server and with 2 instances of msde 2000 sp3 already running, using the following command line: D:\MSDERelA\setup.exe INSTANCENAME="INSTANCE" SAPWD="xxxxxxxx" SECURITYMODE=SQL TARGETDIR="D:\Program ...more >>

Hi, we are installing our app at different sites. Normally it is a easy job, but today we got problems. The user had MSDE from before with Win NT authenticaton only. We changed this to mixed mode. Then we used OSQL and sp_addlogin. Yesterday at another customer this was enough to get access ...more >>

We are a small company writing primarily in-house software, but also potentially developing software to market. We are converting from writing all of our software completely in Access to writing in Visual Studio (C#). We are confident this the best decision for both our in-house and pot...more >>

I have run into a problem using the default directory switch ( -UseDefDir ) with a backup. I have some installations of SQL 2000 Desktop that don't have a default directory. The error reads, "Could not get the default backup directory for database..." My question is, How do I find if a d...more >>

Hello to all, I am using MSDE and i recently realised that the query performance is decreasing while db size increases. In a db table of 20000 rows a simple select query with 6 inner joins took 1.27 sec. to execute (XP Pro, 775 MHz, 248 MB). I upgraded to SQL Server personal edition and the sa...more >>

Hi, How to convert a view to a table in SQL server? I have created the view with related tables and filtered. But my system studying on can not work with a view. or any other solution? Thanks without expect reply, ...more >>

Hello, I am installing MSDE 2000 on a Windows 98 machine. After installation, the SQL server is running, but when I try to run my program against the SQL server, I get the following message "Login failed for user "null" note associated with a trusted SQL Server connection" I'm running setu...more >>

I have a database that has reached the MSDE 2GB limit. I have tried running the sp_spaceused command and I can't see how the results equalls 2GB Can someone explain what values are used by MSDE to determine that the database has reached the 2GB limit? Sp_SpaceUsed Resuls: Database Size...more >>

Is is just me or does this query produce the wrong results??? SELECT CATALOG_NAME FROM master.INFORMATION_SCHEMA.SCHEMATA I have a MSDE sp3a installation, and this query does not include my user database in the resut set. ...more >>

Hello, We are using MSDE and I would like to know the following: - Our MDSE database is set to recovery model Simple but after restoring the backup set the log file increases to 800/900 MB; I'm puzzled about this, because I always thought that 'Simple model' leaves the log file(s) alone; - ...more >>

Hi all, Is it true that MSDE can only handle 5 concurrent connections? I cant seem to find the proof in the documentation that this is true....more >>

I am getting 'Timeout Expired - The timeout period elapsed prior to completion of the operation or the server is not responding', if a database is backed up with a T-SQL statement. The same DB backs up fine when done in Enterprise Manager. Using C# .net 2003. Also - is there any way of get...more >>

pls help I installed an instance of MSDE to a Win2000 Prof PC. It worked (disablednetworkprotocal). Then I uninstalled and reinstall. At the point the set up configures the SQL Server (very final stage), it failed. In the cnfgsv.out log file, If network protocal is disabled, the e...more >>

I currently have a WinXP system which has MSDE installed. I am replacing that system with a new one and I want to install MSDE and then move a copy of all my current DBs. I have MS Office 2003 and I plan to install MSDE from those CDs. To move copies of the DBs I plan to Detach them at the old s...more >>

Hi All, I've read A LOT of posts concerning connection problems with the various versions of MSDE and Windows XP I'm using the one packaged as MSDE2000a.exe which has a new EULA text but other than that it is MSDE 2000 with sp3a already applied. I've finally figured out the connection p...more >>

I installed MSDE 2000 with parameters SAPWD='ahoj' SECURITYMODE=SQL Installation was OK, I enabled all networks protocols in SVRNETCN.exe and restared server. osql.exe -L found 1 server: (local); But if I try to start osql.exe -U sa and write a password, osql says 'Login failed for user sa'. ...more >>

hi, I've a question: Can I use the Reporting Services with MSDE? Where Can I find the prices of "Reporting Services"? Thanks ...more >>

Hi I am a newbie to MSDE and am having a problem deleting records from an MSDE backend using an Access query front end. Our main data is stored on a UNIX server (informix type database) and we link to it using ODBC. We load records to be updated into an Access database and then use the A...more >>

I have an application running on my desktop that access the SQL database and as long as I am not running XP SP2 things run fine. As soon as I install XP SP2 then I keeping getting this message "Database Error: Login failed for the user. Reason:Not associated with a trusted SQL Server connectio...more >>

I am sorry if this question has been posted before, but a search in this newsgroup has not solved the problem at hand: I have installed MSDE on a windows xp pro machine with IIS already running. Later I set up the MS Web data administrator (WDA) However, it is impossble to log in via WDA...more >>

I have a database with a table of basket names and a table of items in those baskets. I would like to find the size of the basket with the most items in. I cannot figure out how to do this is T-SQL:- nMax=0 for each basketName in basket n=count(records in basketItem where basket.baske...more >>