I'm trying to use RDA to exchange data between a CF 2.0 app and SQL Server 2005 ( Developer Edition ), and I guess I really don't know what I'm doing. SQL Server 2005 is up and running. I've installed SQL CE ( 3.0 ) on my development machine. I've configured IIS ( 5.1 ) for RDA as follows...more >>

Hello, I am having issues connecting to an MSDE instance on a remote machine using MSSQL 9's Server Management Studio. I am also have issues connecting to a remote instance of MSSQL v7 using Server Management Studio. Later, I will have to connect to MSSQL v8. If there is a step-by-step ...more >>

Hi, Appreciate if any friends here can do me a favour by telling me whether MS SQL Server 2005 Express can be installed on Windows XP Embedded ? I have run the SQL setup file and while the setup process was trying to start the SQL database service, the Setup screen prompted "The SQL server ...more >>

I have a small (12 MB) database. I don't think it's full, but in any case it's set to grow without limit as necessary. It is accessed only by MSDE on the same machine, and then only by one application, via ODBC. Everything was working until about a month ago, when it became very slow. Ev...more >>

Hi From the local PC windows authentication seems to work, but from remote pc's te client seems to logon as guest. Do i need to install MSDE on a windows server edition to get the windows authentication working ? SQL Authentication works from remote machines, but becorse the password is...more >>

Hallo, Beim Umschreiben einer Abfrage von Access XP auf SQL (bzw. MSDE) bin ich auf ein interessantes Problem gestossen. Gem. Access Hilfe ist die T-SQL Funktion für Weekday DATEPART(dw,x) Nur gibt mir in Access für heute (Donnerstag) weekday(now) -> 5 und SQL DATEPART(dw,GETDATE()) ...more >>

i'm trying to upgrade to sp4 using the following command: <setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=username UPGRADEPWD=password /L*v C:\MSDELog.log> it starts, then stops, without giving me an error. Please help!!...more >>

In the icon tray is the SQL icon with a green arrow that briefly shows a red dot to the lower right of the arrow. All programs that use SQL work fine. I am just wondering what the red dot means? It is like a heart beat to show it is acitive? Or does it indicate an issue? Bob Day ...more >>

Our clients are using MSDE. Our VB application provides simple full backup feature usng DMO. We have noticed that their recent backup size goes to 2GB. to investigate, When backup taken from enterprise manager it is 60 MB. What could be the rerasons?. The clients are doing hundered of inserts...more >>

Hi All, First my apologize for cross posting. It's already posted in sqlserver.programming. But I see this group would also help me. I'm creating an appplication with some stored procedures. The stored procedure needs to return the @@Identity of the table's new record. The function has no...more >>

Hello Group Does anyone know of a utility or Batch script (osql or Windows cmd or mix) to Warn an Admin when a MSDE DB is closing in on 2 GB in size (or 2005 Express closes in on 4 GB). Any leads or tips will be appriciated highly Best regards Uffe ...more >>

Hello, When I run a backup sentence, query analizer shows me anything like this: The string could be crypted 0x80090016 (KeySet doesn't exist) any idea? Thanks,, ...more >>

We are in dire need of a redistributable Profiler for MSDE installed on our client's machines. Does anyone know: 1. If there are any 3rd-party profilers avail to work with MSDE? 2. Is there any way to install SQL Server's profiler? 3. How to begin writing a profiler (in Delphi)? 4. How to...more >>

Anyone know of a tool (hopefully free???) to capture sql queries sent to and MSDE 2.0 database? ...more >>

When i call ADOConnection.Connected := False The connection with the MSDE server is still opened, why that? I want to close that connection with the server The connection is only closed when my application is terminated Im using MSDE 2000 and my application is writen in Delphi ...more >>

Hi, I wonder if it is allowed to use SQL 2000 Enterprise Manager to manage all of the MSDE installatie we have? We have a SQL 2000 server. But the MSDE database used on some laptops have nothing to do with the SQL Server. -- Werner Cornelis...more >>

Hi, I'm trying to install some apps onto one of my server 2003 boxes, on one server it all goes fine, on the other however the msde installations all give up and rollback I just get errors in the event logs that state that the installation failed. Any ideas? It won't even let me install the va...more >>

We have WSUS installed with the WMSDE database engine. I have 2 questions which can't seem to be answered anywhere on the net: 1. We have various vulnerability scanning tools that show WMSDE not having SQL SP4 applied. I can't find any way of installing SP4. I've tried with the full-bl...more >>

Hi I created a small test app that opens an sql database on the same machine (TESTPC). When i move the compiled app to another pc in the network i receive this error: Login failed for user TESTPC\Guest. What should i do to make it work ? Connection string ? or doe i need to created ...more >>

Hi, I noticed messages in my sql server log that says: This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected. The question: Is this message is generated each time such situation occure? I get only l...more >>

Hello, I read that the SQL 2005 Management Tools from the Trial version can be used to manage the MSDE. So I installed MSDE and the SQL 2005 management tools on my test server and it seems to work fine. But my question is if the "Microsoft SQL Server Management Studio" will stop running af...more >>

Hello I'm new to MSDE but I had to install it half a year ago for the WSUS server. The WSUS server is running fine which let me thought that the MSDE is installed correctly. However, I noticed a difference between my test system and my productive server. On the test system, the "Service Man...more >>

Is there an Import/Export wizard like SQL Server 2000? I am thinking of developing databases in SQL Server 2005 Express. When done I will need to transfer the tables/data to a SQL Server 2000 database. I normally use the "Import and Export Data" tool to transfer items. Is there a matching to...more >>

How can i restart my MSDE server from another application? Is there any api to this? Thanks ...more >>

Hi, I am trying yo return a set or records by using a SELECT statement, the table contains a column called CreationDate. I want to add one more column to the resulting dataset (not to the table), that value of the column will be 1 if the CreationDate is 1 day before the current time, 0 ot...more >>

Hi, We have a software that is developed by using MS SQL Server Standard Edition. The vendor claims that the software cannot be used with MSDE. The question is: Are MSDE and SQL Server Standard Edition exactly the same from a software point of view? Can I replace the standard edition with MSD...more >>

Hi. I'm about to install an MSI-packaging software, which needs either MS SQL (we don't have it) or MSDE. I already have WSUS running and it uses WMSDE. Can I install install MSDE (distributed with the software) without screwing up WSUS/WMSDE? Antti ...more >>

I'm running XP Pro with a local installation of MSDE, when using NTbackup to backup to external tape drive the Shadow copy process fails with error 800423f4 Is there any way to use the NTBackup with the MSDE when the database is not Simple Mode? Thanks...more >>

Hi , I am using SQL Standard Edition , can i use the debugging tools in QA ? if so how can i bring out the debugging toolbars ( have tried but cannot) appreciate ur advise tks & rdgs Beng Tiong -- Message posted via http://www.sqlmonster.com...more >>

Please explain me how much of concurent connections can handle SQLServer Express 2005 according license agreement. Thank you. Dmitry ...more >>

Is there any way to restore a full database backup made on sql server 2000 to SQL Server Express 2005? When I tried, I received an error message saying the *.sho file could not be found. Thanks, Keith ...more >>

I saw this product called Toad and it looked like it was free but I was unable to install it because it complained about expiring and stuff. Thanks for your help....more >>

Hi, I want to enter data in xml into tables in the database. Howevere, I do not want to use OpenXML Please let me know if there is an alternative. Regards, Shilpa ...more >>

Hi all, I have an Access Project for the front end and a MSDE as back end. The database is in a Server and only administrators have access to it. I've installed a copy of the .adp on each user's computer. I plan to convert to ..ade once the project is finalized. I have a UserName and passwor...more >>

Hi, i have a msde installed on a Windows XP HE SP2 Computer. This Computer has a 3.06 GHz CPU with 1GB RAM!!! i am developing software with vb6 and go through a odbc (JET 2.8) connection directly to the local installed msde. On my notebook (WinXP PE SP2, 1.4 GHz, 512MB Ram) this software runs...more >>

Hello, I'm trying to empty some tables on my customer's DB. But all of them have relations with other tables ( PK/FK). Therefore I get the following error: DELETE statement conflicted with COLUMN REFERENCE constraint 'SER_CALLER_PER_FK'. The conflict occurred in database 'sd45DB', table 'IT...more >>

Hi, I have a simple asp.net application running ok on my WinXP development server with SQL Server Express 2005 installed locally. After moving to the live server (Win 2000 server with MSDE 2000 installed locally), it's giving me the 'SQL Network Interface Error (error 25): connection string i...more >>

Hi guys My client recently had to restore their intranet from backup cos of a server failure. They stopped IIS and SQLServerAgent and stuff, and then restored the whole MSDE2000SQL$INSTANCE folder, and everything *seems* to be working. However, there was a restore error on the msdbdata.mdf...more >>

Hello, I have a problem installing Autodesk Inventor 10 on my WK SP4 OS system on XP SP2 system it works fine. Event log during setup Inventor 10 Pro. Source Loadperf Category (none) Event ID 2000 No object list was found in the installation file. Adding an object list to the installation...more >>

I'm new to SQL Sever Express and wondering about using it for a desktop app. I have a web server and SQL2005 with some web apps, and I'm thinking about making desktop versions of some. But, I want to protect the db structure and the way everything hangs together. Assuming I can make a SQL ...more >>

Hi All, I use several SP's to create tables and I have run into a problem I do not understand. All the SP's create a FK constraint when the table is built and they all work, except for 1. CREATE TABLE dbo.ZipCodes ( CountryID int NOT NULL, StateID int NULL, CountyID int NULL, ...more >>

I have an application (VS2005, C#) that creates one or more SQL Server Express (2005) databases and populates them with a schema and some initial data. This all works. From time to time there is a legitimate runtime issue that means I should remove one of the newly created databases. The p...more >>

Hi guys I've got an MSDE instance on C drive and I want to move the entire instance directory to E, where all my other document data is. I don't want to create a new instance or anything like that, just move the one ive got. Is this possible and how do I achieve it?! (MSDE 2000) Chee...more >>

Hi, does the size of the transaction log count against the 2GB limit per database in MSDE? Thanks. -- Jose San Miguel Consultor Senior TI - MCAD Improven Consultores ...more >>

Another newbie here, hope yaw dont mind! Yes I am redneck newbie I have been using access for a few years and have decided to further educate myself(untrain) and start allover withh SQL. I have the developers edition of SQL 2000 and VisualStudio.net 2003, I did look at SQL 2005 Express. I...more >>

Hello when i have the following Stored Procedures: CREATE PROCEDURE [dbo].[vs_UpdateTest] @ID [int], @Wert [nvarchar] (10), @Wert2 [nvarchar] (10) AS UPDATE [1] SET [Wert] = @Wert, [Wert2] = @Wert2 WHERE ID = @ID GO The Parameter Wert2 is optional. When he i...more >>

Hi.. I have been trying to register a remote instance..but have no success. The MSDE instance is behind a firewall...So in the firewall im doing a port fowarding. The port that i have setup for forwarding is 1433 (TCP), is that correct? i have installed the MSDE just like this: setup SAPWD...more >>

All of my RDO (2.0) connections are getting this error: Login failed for user 'my_user' All of my apps that use ADO are working fine. I know the userid/password are correct because I use the same ones with my ADO apps. Does anyone have any ideas? Thanks in advance! apf ...more >>

All the documentation says that a Celeron processor will not run MSDE 2000. Just loaded a small enterprise app that is based on MSDE2000. Now the PC in question is just out of the box Celeron PC (1.5G M370). Now would this just be a freak occurance that does not portend fo the the futre?...more >>

Hi, After installing a MSDE instance, in the Servcie Manager I don't see the server I've just installed. But if I enter the name of the instance in Service Manager, I can acces it and then start/pause/stop it. If I reboot the PC, the server will not start even if the checkbox in Service Man...more >>