I have the MSDE (SQL Server 8.0.760) installed by a 3-rd party application on a W2K Professional with the latest updates and I can see in my firewall logs that there is a broadcast on UDP/1434 every 8 seconds. I know that UDP/1434 is used by the SQL management utilities. I captured the traffic...more >>

What are the concerns when updating a local msde database to sql server express 2005? What is the best way to dump my data from msde to sql server express 2005? What are the benefits from migrating from a msde database to sql server express 2005? Thanks ...more >>

Hello I have an default instance of MSDE 2000 Release A working and I want to install another instance, but I can't. I'm trying to install using the following command : c:\msderela\setup.exe SAPWD="..." INSTANCENAME="eq" DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL /L*v c:\msde_eq.log an...more >>

Hello NewsGroup, I've installed MS SQLServer Express 2005, and set up an instance (installation did actually) MSSQL.1. I installed this from the latest download from the MS Website SQLEXPR_9.00.2047. Visiting the website again I downloaded and installed SQLEXPR_9.00.2047_TOOLKIT.EXE and ...more >>

This is a "was working yesterday" issue. On our PCs trying to connect to MSDE 2000 SP4 (via .NET SqlServer Connection object) resulted in a "timeout expired" message (using default 15 seconds timeout) This is only happening when connecting to MSDE. Full blow/developer editions are fine. T...more >>

I have a recurring problem. It comes up every time my backup starts on both of my servers -Mainserver and Terminal server. Both have MSDE installed. We use Windows server 2003 and EMC Retrospect with open file backup. However, we do not have any SQL agent. We backup MSDE databases to the Backu...more >>

Hello people, can somebody tell me if is posible to install the SQL 2005 Express Edition in a server with Windows 2003 server?? Thanks, Edward Gasca ...more >>

Hi I've installed MSDE SP3 on a computer with DISABLENETWORKPROTOCOL = 0. It connects locally but when I try to connect to this instance from any other system, I cannot connect to it. I've checked the TCPIP/NamedPipes both are enabled. Also Allow remote connections is enabled when I checked...more >>

Hi all How can I start SqlServerServiceManager for a special instane name programaticaly?? thanks ...more >>

I ran a test overnight last night (the first of many I will do), to see how my caching system holds up to 3 or 4 multiple users all accessing at the same time. Basically I create random operations and apply them at random times to the database via. stored procedures. Anyway, 3 of the 4 proce...more >>

Howdy All, I use a document management application that uses SQL (previously MSDE and now is 'compatible' with Express). I have installed Express and when I try to create a DB, I get odd errors with various error numbers and garbled text, such as: Encountered an error executing SQL. ...more >>

Hi all I want to install MSDE 2000. when I finish installing that SqlServerServiceManager shows my comouter name as a Server name.but I want to change server name like this way: ComputerName\MyName how can I configure that to install this way?? thanks in advance ...more >>

Is there a way to get MSDE to work across multiple profiles? I've discovered that if one user installs an instance of MSDE, then no other users who log into that machine can create databases. Is there a flag or installation setting I need to configure to get it to work for whomever logs in...more >>

>From SQL Server Enterprise Manager, how can I determine if the database is SQL or MSDE? I suspect one of our databases is MSDE but I need to know for sure. Thanks Nick ...more >>

Hi, Do you know how to move SQL and its database from one drive to another drive (C to D for example). My C drive is almost full but D drive still has a lot of space. I would like to move my SQL and its database to D. Thanks for any help ...more >>

Hello, I used SQL Server Enterprise Managers' Export Wizard with source Dbase III files and destination ODBC driver for SQL to create a dts package in the structured file format. I entered the following dtsrun line (msde 2000 sp3) and received the errors shown. dtsrun /S servSQL /U s...more >>

Just wondering if anyone here has had experience with sql database setup operations in an Inno setup file using SQLDMO. ...more >>

Can a dts package be imported into Sql Server 2005 Express? Thanks. ...more >>

This MSDE 2000 SQL server comes with ISA server and we renamed host server (windows 2003). From CMD prompt (osql) I dropped old sql server name and added new name. Now I can't connect anymore using SQL server service manager. Any help will be greatly appreciate Thanks ...more >>

My international (non-American) users are receiving the following error when my application tries to access its MSDE-based database: Error: Column <blah> is not of same collation as referencing column <blah1> in foreign key <FK_blah> Could not create constraint. See previous errors. I...more >>

I'm having problems installing the above. The server already has an instanseof SQL 2000 installed and this is a named instanace. Errors are basically that the installation package doesn't think that there is avalin instance of MSDE installed. command line parameters being used: - setup /...more >>

Hello, I have a database which uses the odbc microsoft dbase driver, how do I import this into msde 2000? Thanks, CharlesC. ...more >>

One of the charts on the MS site that compares SQL editions indicates that SQL Express supports the creation of indexed views but not something with "query matching" that I don't understand. I've spent the last couple of years workign on a project that should be able to use MSDE 2k. We're ...more >>

Hello: I'm trying to install the MSDE in a server that only needs the engine of SQL that it works properly, furtunelly, I have a preproduction environment, in the preproduction evironment the MSDE is installed without problems but in the production environment doesn't finish the instal...more >>

Hi there, After upgrading the MSDE2000 to MSDE2005, I ran the sql "backup database mydb to disk = 'c:\temp\mydb.dmp'". However, I got some error message like "Msg 207, Level 16, State 1, server ..., Line 1" "Invalid colum name 'mirror_count'" I checked the msdb, there is no system...more >>

Hi All, I have searched the newsgroup for localizing the MSDE Setup.ini by country code, eg. 1033 for the US. My question is, if I want to deploy my application to many different countries, how would I go about supporting 20 plus countries. Surely there has to be a more elegant way than l...more >>

Hi there! I have a Sql Server 7 running on a webserver. Now I have a quite complicated query that I run on 4 ways. 1: Using ODBC-driver directly on the Sql Server. time to execute: 12 seconds (done this about 10 times) 2. Using OLEDB-driver directly on the Sql Server. time to execute: 12 ...more >>

I need to increase the number of Concurrent connections in Windows Xp because give a error if a run my application en with MSDE. I think that in the Registry exist the option Somebody help me Please...more >>

Please help I am unable to find a resolution to the following: Server: Msg 3270, Level 16, State 1, Line 1 An internal consistency error occurred. Contact Technical Support for assistance. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. I have a M...more >>

Hi, I have one question regarding Serializable Isolation level. Consder the following scenario Two concurrent transactions T1 and T2 read the same row Row1 - T1 reads Row1 at X sec and - T2 reads Row1 at X+0.1 sec Now T1 modifies Row1 and tries to save the row also T2 modifies Row1 and tri...more >>

I have a client which is using SQL 2005 Express (for WSUS) and is now looking at a package which uses MSDE 2000. Can I put it on the same server? Any help is greatly appreciated! Dave ...more >>

I have an application that uses MSDE 2000, I just obtained a free 3rd party tool trying to manage the database a little bit toward what I wish it to be. However I do not remember the "SQL Server instance name" and "username" when MSDE was installed with this application, is there any way to fi...more >>

Hi, I have installed SQL 2000 MSDE and the Web Data Administrator tool. I was able to create a new database and added new column etc. However when I come to create a new user I cannot see any of the security options under server tool. Can anayone assist please??? ...more >>

sp_provider_types_rowset and some other stored procedures keep being executed We recently experienced a very interesting problem. When connecting to SQL Server 2000 (SP4) using ADO, after the recordset is retrieved, we can see the following stored procedures kept being executed every we su...more >>

Also, how do I determine the version?...more >>

Do I use the SQL Server CD to install both?...more >>

Hello Newsgroup! I got a problem concering Microsofts MSDE. I installed it on my computer being locked in with administrative rights. I tested the connection, created some tables... So far, everything worked fine - but when I log in with my default account, it is impossible to connect the d...more >>

I get an MsiExec.exe error and the MSDE install rolls back after getting to the end of the install. The actuall error that comes up is "The instruction 0x7c838bcb referenced memory at 0x0000000. The memory could not be written."...more >>

I have a user (client) that can not connect to a MSDE server, but can connect to a SQL Server. If I create an alias (on the client), and uncheck "dynamically determine port" and specify the port number, it can connect. I have a different user that can not connect without the alias, but...more >>

I installed an MSDE in ComputerA (Server 2003) with the command: Setup.exe SECURITYMODE=SQL SAPWD="xxxx" DISABLENETWORKPROTOCOLS=0 I tried to get access to this MSDE from ComputerB in the LAN with the command without success: osql -s ComputerA -U sa -P xxxx I have tried connecting to this ...more >>

Hello, Are there significant performance differences running MSDE 2000 on a Win2k Server vs a WinXP Pro system (not server) for a small network? Thanks, CharlesC. ...more >>

Hi, I need to do a subselect where clause on an INSERT and cant find an example of syntax. Here it is: INSERT into tblUserLocation (intUserID,intLocationID,intAuthorityID,ysnPrimary) VALUES (2,5,3,0) WHERE 5 NOT IN (SELECT intLocationID FROM tblUserLocation where intUserID=2) It gives me...more >>

HI I use MSDE on Windows 2000 Server without problems but to install in a XP give de follow error: 25000:[Microsoft][ODBC SQL Server][SQL Server]Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statment is missing. Previus count = 0, current count =1. ...more >>