I am trying merge replication between two instances of MSDE on two different machines on LAN. I have setup the snapshot agent . when I try running the agent using sp_start_job @job_name='MergeSnapshot' I get an error message saying job name ('MergeSnapshot') does not exist I am new to rep...more >>

Is SQL 2005 Express compatible with WSUS?...more >>

Hi! I'm using MSDE 2000 SP4. I need to get only date from smalldatetime using SQL statement like "SELECT MyDate FROM MyTable.". Like this way I'll get MyDate as "27.11.2005 0:00:00" when using finnish regional settings, but how to get just "27.11.2005" without that empty time? I think t...more >>

I took the SP4 MSDE and tried to publish sql2000.msi to active directory but it failed. When I ran the MSI file interactively it complained about not finding the default instance. Obviously setup.exe must set this property? Anyway I used ORCA to edit the SQL2000.MSI and added an INSTANCENA...more >>

Hi all, I try to start and stop specific instances of MSDE using SCM.EXE This works for the default Server, but not for a specific one. This works: SCM -Action 6 -Service MSSQLServer works ok SCM -Action 6 -Service MSSQLServer -Server Desktop\Myinstance gives an error: The RPC Server is n...more >>

I select New Stored Procedure from the context menu of the stored procedure tab in my database, and it procedes to makes a file called SQLQuery1.sql and saves it as a file, but doesn't add it to the list of my stored procedures... How do I add it? What am I doing wrong? I see no method of imp...more >>

I am trying to install MSDE Rel A on a Windows XP SP2 machine with no luck no matter what I try. I am typing the following at the command line. setup.exe /L*v C:\MSDElog.txt SAPWD="password" SECURITYMODE=SQL Below are the portions of the error log that contain RETURN VALUE 3, including se...more >>

We are installing MS Win Server 2003 and my old version (7?) of MSDE is not supported. So I will download MSDE 2000 and install it. I do not have a lot of experience installing MSDE. I installed it a few times years ago and, with a few exceptions, it has run just fine since then. I vaguely re...more >>

I have installed MSDE 2000 RelA. on pc with Windows XP. The problem is that when I run the SQL Server Service Manager, there are no choices in the field Server. When I'm writting the ComputerName\InstanceName everything is ok, but why is this happening? There are many times where I need to guide...more >>

Is the new version of SQL 2005 (Express) compatible with Windows Update services? TIA Regards, Milos ...more >>

I just can't get MSDE installed on my machine. It hangs midway through the process. If I kill setupre.exe the setup continues but just before it's done there's an error "Setup failed to configure the server", and it rolls back. I've stopped the services and processes and read the readme very car...more >>

I am in the process of downgrading an MSDE database to a Jet (Access) database for the following reason: 1. Size: Deployment of an MSDE database engine is inflating my distribution file (Setup.exe) over 20 Megs! With an Access database this number is ZERO because all the infrastructure to a...more >>

When trying to upgrade msde 2000 sp3a named instance to sp4 with the following parameters, "setup /upgradesp sqlrun /i c:\msdesp4\wti.msi /settings c:\msdesp4\setup.ini UPGRADEPWD=???? (actual admin password) /L*v c:\msdesp4\msdelog.log" where the setup.ini file contains, SECURITYMOD...more >>

Hi, is there a way to schedule a backup ? Using the Management Studio Express I've seen only the way to Backup a database but not to "schedule" a backup. Any help or suggestion is appreciated Adriano ...more >>

Hello, would SQL Express 2005 be a viable solution then for a website that uses DNS connections for a traffic of 100,000 pages downloaded per day? Thanks Stephan ...more >>

My AV app uses MSDE to keep track of what PC has was sig file, I would like to install WSUS on the same server but since it will install WMSDE I'm wondering if the two will cause problems. Does anyone know anything about this? Has anyone else done this before, or can you even have two apps tha...more >>

Hi, I develop an App with SQL 2000 and some customers run it under MSDE - no problems. I plan to add funtionality to the App and use NS (notification service) will this also run on MSDE, or do there exist any limitations (e.g. costs), so I shouldn't think of using NS? Regards, Flem...more >>

Am I looking in the wrong newsgroups, there is msde newsgroup, but I cannot find a sqlexpress . Should I post questions about sqlexpress in the msde group or where? -- Jan D''Hondt <Toto, I''ve got a feeling we''re not in Kansas anymore.> SQL database and .NET solutions ...more >>

Hello In a backup program, I need to know if MSDE is installed locally. If I knew the computer's name where MSDE is installed, it will be perfect! Does somebody have an idea? Thanks...more >>

Is there a limit on how many databases you can have per. MSDE instance? Best regards Erling Johansen Norway ...more >>

Hello, I am attempting to install MSDE on a client's Windows 2003 server machine from their Small Business Server 2000 CD containing MS SQL. The Windows 2003 server unfortunately was partitioned in such a way that I would like the installation program files, etc. to reside on the D: drive...more >>

Here is my query: --------------------------------------------------------------------------------------------------------------------------------- SELECT M.Master_ID, M.Case_No, M.Case_Year, M.Case_Date, M.Office_Year, M.Office_Sufix, M.Page_No, M.Master_Text FROM Master AS M Where M.Master_ID...more >>

How can I tell which of the SQLServers listed on the network are specifically MSDE. I want to make sure that I have licenses for all the full versions of SQLServer that are running. Thanks. Alan ...more >>

Hi all I have done lot of R&D on different databases Including MSDE. @ Last I found one which is really cool -- FIREBIRD (Dont consider me as a Database Guru) just checkout the following Links 1 http://www.dotnetfirebird.org/blog/2005/03/firebird-advantages-over-p... 2 http://www.do...more >>

I already have WSUS running on a win2003 SP1 machine. I am trying to install a second instance which will be used for WebSenseReporting, however, about have way into the initial setup the progress bar will backtrack and install will fail. Any ideas, thanks....more >>

I have MSDE 7.0 running on a Blackberry Enterprise Server 3.6 with Exchange 5.5. I need to upgrade the database to MSDE 2000 before I upgrade the server to BES 4.0. How can I accomplish this? Thanks....more >>

I am running SQL 2000 . My database is about 8 gig but my log file is 30 gig. What can I run to reduce the size of the log file and keep it low? Please advise...more >>

Hi all I have done lot of R&D on different databases Including MSDE. @ Last I found one which is really cool -- FIREBIRD (Dont consider me as a Database Guru) just checkout the following Links 1 http://www.dotnetfirebird.org/blog/2005/03/firebird-advantages-over-postgresql.html 2 http...more >>

Hi All Wanted to know which of these artilce can i use if i want to maually remove SQL from my computer .I have enclosed the articles for your reference http://support.microsoft.com/?id=320873 and http://support.microsoft.com/default.aspx?scid=kb;en-us;290991 With Regards Raul Thomas ...more >>

To all, thanks in advance, I have blackberry server running sql msde 2000 (sp4), which is authenticated via windows integrated with an active directory user account. When I changed the password on said user account, restart the mssqlserver service, it fails to start with a 560 error. I had t...more >>

I have a problem with the sp4 installation. The first time I tried it it stalled about midway through the installation and I canceled it. Now I can't get the installation started, it gets as far as "Gathering required information" and closes. I'm upgrading from service pack 1 with the command ...more >>

Is Enterprise Manager available as a separate download and installable on a system with MSDE installed? Are there any similar third-party tools? Many thanks. ...more >>

Hi Does SQL Server Expr.2005 have SQL Server Agent? M. ...more >>

how can i mannage changes in msde objects from a connected msaccess application? ...more >>

Hi, I'm running MSDE right now and I want to move to SQL Server Express 2005 eventually. But in the meantime, can I run both side by side on the same machine? Thanks, Sung Hon...more >>

Hi In MSDE2000 i can create backup from database and schedule it how can i do this with SQLExpr.2005? Mex ...more >>

Hello, I have installed a MSDE instance in a server (server1) with the following options: Setup DISABLENETWORKPROTOCOLS=0 SAPWD="password "INSTANCENAME="myinstance" In the client PC I need a user DNS, in "server" field I use: server1\myinstance But it shows a message: "The...more >>

we are not able to reinsatall msde in the same server..we are getting the errors. we uninstaaled the msde and using add/remove programs and also deleted instance of microsoft sql server folder.. still we can't access the server from the client machines.. got the error "server does not exist". ...more >>

Can anyone tell me if there are known problems/issues with running SQL MSDE on Windows XP? We have a wise install program that installs an Excel application with msde and it runs fine on Windows 2000 but not on XP. The install program completes fine but when we go to view the database we fin...more >>

Hi Is it possible and when yes, then how to create database backup to mapped drive or CD-R? Meelis ...more >>

Hi, I currently have 2 instances of MSDE running on a server to support two different applications. We have decided to obtain the full SQL 2000 std for another project. Can SQL Server 2000 run on the same machine as Server MSDE? Will I need to migrate the existing databases that are curren...more >>

How do I set the path to the working database for other users? Currently it's on a mapped folder as Z:\ I know I can change the WORKINGDIRECTORY value but was wondering if there was a way to do this when adding a user Thanks to a post by MVP Hari Prasad for the following info: osql -S Na...more >>

I've got a situation where WSUS is already installed on a server and I'm looking at moving my anti-virus system on to the same server, however my AV uses MSDE. The server is running 2003 and therefore WSUS is running in WMSDE. I take it I can't use WMSDE for my AV solution so I'd like to kno...more >>

Hi, Is there an MSDE 2005 version? Or will it be soon? ------------------------------------------------- AF ...more >>

Im using MSDE2000 on win2003 server, 2 CPU, 1GB ram. Is there any point to upgrade to sql express 2005? sql expr. supports only one CPU, is this a big tifference? Meelis ...more >>

Can I use the regular Enterprise Manager to manage MSSQL 2005 express or do I have to use the Express Manager? ...more >>

how many users can be connected to msde? is their any limit? ...more >>

Does anyone know how to convert a VARCHAR to a SMALLDATETIME? I have a field in a table which is a VARCHAR and holds dates as dd-mm-yyyy. If I want to sort on the dates everything is sorted on the first char of the date. so 14-10-2005 (okt 14) comes before 20-09-2005 (sept 20) I have tried...more >>

Please help. My SQL 7.0 will not start. On opening the database I get the following..."Failed to start SQL server [GetcennectedSQLServerObject]Error 2147221504 [Microsoft]ODBC SQL Server Driver] [Shared Memory] [Microsoft] [ODBC SQL Server Driver] [Shared Memory] Connection Open (LoadNetLibs...more >>

I am slightly confused with the ambiguities on MS's licensing for the use of MSDE. I have a client that is using MSDE with a total of 18 connections, doesnt MS require my client to upgrade to SQL Server? -- Cadstillo ...more >>