In my daily Server Performance Report, I received two Critical Errors in Application Log at 3:30 AM every day for about a week. The firsts Source is MsiInstaller. The Event ID is 100005. The message is: Product: Microsoft SQL Server Desktop Engine -- Internal Error 2727. DatabaseRepl.185C1D8F_...more >>

Pardon me for being a bit of a newbie with LCS, but I've run into a few issues on a recent install. We have LCS 2005 running on a 2003 Server. Right now it is the only app on the server (besides the usual Windows stuff) and the first off when the machine starts up the SQL Server Service Ma...more >>

I'm trying to upgrade the Default Instance of MSDE 2000 Release A which is installed with Mixed Mode and strong password to SQL Server 2005 Express in a Windows 2000 Server with SP4. On the Upgrade Logon Information screen, if I select SQL Server Authentication Mode, it will give me this mess...more >>

I'm having a trouble understanding the redistribution rights for SQL Express. Does anybody know if I can redistribute SQL Express on my installation CD? Integrated into my install? As a separate install? I have registered with MS that I will be redistributing it, does my client need to...more >>

We are running a Windows 2003 domain. I have a Windows 2003 member server running an app. and MSDE. I now have another app. that I would like to install on this same server. The new app. also needs MSDE. My question is can I install and run more then one copy of MSDE? Is there anything I...more >>

i accidentally uninstalled the sql server desktop engine (sbs monitoring) and the sql server desktop engine (sharepoint monitoring) in the add/remove programs of windows small business server 2003 premium edition..(sp1) i am using a sql server 2005 developer edition how can i install it agai...more >>

Hi! I try to install BE 10.1.5629 AGAIN on the system. But it does not work. I have the problem with the MSDE what is needed. I tried this: http://support.microsoft.com/kb/320873/EN-US/ I tried this too: lodctr /r:perfstringbackup.ini Both does not work. Any Idea? Olaf ...more >>

Does SQL SERVER 2005 Express provide support for use as a backend database for MS Access 2000 over a network ?...more >>

This shouldn't be too hard but I can't find the right answer: How can I enumerate all databases in my SQL Server (V7)? ...more >>

Hi, I have backed up my MSDE database daily for some weeks with this command in a .bat file: osql -E -Q "BACKUP DATABASE MyDB TO DISK = 'E:\MyDB_Backup.MSDE'" ... however it turns out this this produces some kind of incremental backups, the original 150Mb database backup file has now gr...more >>

like in the subject ... can I expect any performance issues having an virus scanner installed on the machine together with msde? TIA Stefan ...more >>

Thats!, I need 1 instance of SQL Server, then how many databases can hold 1 instance?, I have unlimited hard disk space and 1 GB Ram Thanks! -- Alexánder Osorio Business Intelligence Specialist Caracas - Venezuela ...more >>

Hello, I'm attempting to install MSDE SP3 (and SP4) on a 2000 SP4 Server that is configured as a file server and a secondary DC/DNS server on an ADS domain (whose GCS is a 2003 Server). This is a new installation that never had SQL installed (I rebuilt this file server recently). MSDE SP3...more >>

I have a query, generated by Visual Studio.net in an ASP.net web-app which normally works fine, but occasionally only returns one column of the selected row. the first column (Recd_ID) is the identity/key column, and when the query fails, only this column is returned, another attempt a moment...more >>

Hello I don't have very much idea about data bases, but I need one to install wsus. I've installed MSDE and I have created an instance called WSUS. The problem is that it doesn't work. It doesn't connect. I have the service running (called MSSQL$WSUS). I have seen in the errorlog that the serv...more >>

I installed with DISABLENETWORKPROTOCOLS=0 but I still cannot connect to the MSDE named instance using Enterprise Manager The environment is: Win XP SP2 Firewall is OFF ...more >>

Hi Is there some kind of free data pump tool which will allow me to transfer data between MSDE and SQL 2005 express databases? (with the db schema) Thanks ...more >>

Hi I'm trying to figure out how to protect a database located on the client's computer from tempering. I created a strong password for the "sa" user, and removed the "Builtin\Administrators" login from the "system administrators" role, so now people with no knownledge of the password can't conn...more >>

I have always been told never install antivirus with a sql server. I believe this is because antivirus software might interfere or slow down a sql server. IS the same true for MSDE? Can someone explian to me why antivirus software on a sql or msde server is a bad idea. Thanks....more >>

How can I backup a MSDE database? SQL 2000 was easy to do all I did was use the Enterprise Manager. I'm not sure how to do this with MSDE 2000. ...more >>

hi i am working on Windows 2000 Advanced Server + SP4 and SQL2000 Enterprise + SP4. i have database contains Tables, and i want make script to build Tables on other Database, but i need this script include Data in Tables too, i can make that ? and how? thanks -- Tarek M. Siala ...more >>

Hi all, I have a MSDE database that i can fully use as long as the user has administrator privileges. But due to security i cannot allow that. Does any of you know how to give a regular full privileges to a database using Windows authentication? I have looked through a lot of mailing lis...more >>

Hi all, I'd like to know how can I know (from a VB application) how many user are conected to a MSDE Database ? Best regards, -- Jorge L. Cotarelo (Please forgive my English) ...more >>

Hello, all... I have a user (HR DEPT) who has Visio and ADP Payroll software installed. ADP Payroll installed MSDE and every time she starts Visio and tries to open an existing document, it starts reinstalling MSDE. How can I fix this? We aren't actively using ADP any more for payroll, but nee...more >>

Hi, I am trying to setup MSDE sp4 on a windows XP machine but the installer always hangs near the end of the procedure and rolls back. I have tried the solutions posted here and on the knowledgebase but cannot solve the problem. Here is part of my verbose log, where Return value 3 is found. Can a...more >>

MSDE has a connection limit (as far as i remember, you can't open more than 20 connections at the same time) but other editions of SQL 2000 has no limit for opening connections. Is there a limit for how many connections can be opened to SQL 2005 Express edition at the same time. ...more >>

For an unknown reason, every time I try to start the SQLSERVERAGENT, it immediately stops. It will not stay running. I've set it to automatic. I've tried to start it manually. I suspect the unstartable agent is also the cause of a multitude of connection issues - mainly, I can't connect to...more >>

Hi all - thanks in advance, I have figured out how to back up a database in SQL Express - manually. Is there a way to schedule automatic backups that require no user intervention? ...more >>

Hi, when i read a registry in remote on Windows XP professional as server and client the xp_regread function doesn't return a value when if i read the same date on a server with Windows 2003 server and client with Windows XP professional works well... I use: USE MASTER DECLARE @test varc...more >>

Hello all, I have got a rather strange problem (as usual). I have a client that is attempting to install ICVerify software (Credit Card processing), onto her machine. Part of the setup for the program attempts to install MSDE onto her workstation. The strange part, is that MSDE will not in...more >>

I currently have Microsfot SQL MSDE installed on a D drive of my server. I have segemented my server as I usual do with SQL server with about 25 GB for the promary boot partition drive C and about 40 GB for drive D for applications. This server houses our fax server which runs on MSDE. Is ...more >>