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 >>

Hi, I want to back up my database. I found in the books online where it said backups could be done by simply copying the .mdf and .ldf files. Its that enough? I don't have to run sqlmaint to produce the .bak files? and then copy those? Is there going t be a new newsgroup for SQL Server 20...more >>