Hallo NG! Ich habe das Problem, dass ich einen Eindeutigen Key in einer Tabelle definieren will. Dieser Key soll auf das Feld ScheinNr angewendet werden. Mein Problem ist allerdings, dass der Key nur für Felder <> 0 eindeutig sein soll! Habt Ihr eine Idee wie ich so etwas realisieren kö...more >>

I've got the latest MSDE installed using SAPWD=<strongpw> SECURITYMODE=SQL But I can't log on to it with the Web Administrator. Either I get a "password is wrong or server doesn't exist" or a constant hour glass cursor. Is there another administration program I can use for this? Or is there...more >>

How do I programmatically find the names of all data tables in a MSDE database? Is there an ADO.NET method that can help, or a SQL command? Thanks in advance. -- David Reinke...more >>

How do I change the audit level in MSDE to all? ...more >>

I installed MSDE, attached a database and tried to run a query using osql. The login fails. Here is the output. D:\MSSQL>osql -d handbook -U handbook -P handbook -i select_dummy.sql Login failed for user 'handbook'. Reason: Not associated with a trusted SQL Server connection. D:\MSSQL>osql ...more >>

Hi all, I have a sql Server 2000 Setup I have a client who uses as there main database an MSDE Database. They sent me a backup of it. I created a new SQL Server Database, and restored to it the backup they sent me. I am now going to write an asp.net application that uses it. when I go ...more >>

What is the diffrence between MSDE 2000 and WMSDE? I have two applications that require these databases and I am concerned there might be issues in using them on the same server: SmarterTicket / MSDE 2000 Windows SharePoint Services / WMSDE Thanks - Jody...more >>

I've been asked to create an online database for my organization with Access as the front end. I'm pretty good with Access and moderate with SQL. In the database, I was told that different users need to have access to certain tables and columsn in those tables. Some users need to be able to creat...more >>

I tried including [Options] section with the following details [Options] INSTANCENAME="MSDETRIAL1" SAPASSWORD="sa" But when I run my installation it give me an error "The instance name specifed is invalid". I am using InstallShield 10.5 Professional Any ideas! TIA...more >>

Hi all, I have a copy of MSDE running, and it has 2 instances on it, server and server\server, is there any way to remove server\server and transfer it to server? I want to move it as it appears to be interfearing with any setup of sql based apps (sharepoint refuses to go past the install s...more >>

I've been able to create a CD where it installs MSDE 2000 sp3 on a user machine. I need to create a database on the users machine, how do I incorporate the SQL script to create the database? Do I call the script within the setup.ini file? Any sample anywhere I can take a look at? Thank you, ...more >>

I've installed an Instance of MSDE on a Win2k Machine and and WinXP Machine. I'm able to register the Instances locally through EM (v.8.0), but when I try to register them from a different PC with EM on it, I get the following error. SQL Server does not exist or access is denied. ConnectionOpe...more >>

We are installing msde in an unattended mode on win2k+sp4. This is on a completelly clean windows install that has had no applications installed on it. We spent a day reading documentation and experimenting trying to determine under what conditions msde needs to reboot. It currently give...more >>

Hi all I hope someone can help, I have managed to install MSDE on Windows 2003 Server, however after a reboot I open up the SQL Serve Service Manager and Under Server I have the server name, but under services, it is all blank, as such its not working at all, any ideas on how to add a service to...more >>

I am writing an application in VB.Net that includes a database. I could use either an Access database (MS Jet) or MSDE. I would rather use MSDE because it has useful features like triggers and complex stored procedures, but I am worried about deployment. My users have all kinds of machines,...more >>

In some places I read the Governor has 5 max concurrent connections; In some other places I read it has 8 max concurrent connections; What is the real limitation?...more >>

Hi there, How can I monitor the MSDE performance. I read about it on the MSDN site but was not clear what tool to use. Can u help? Thanks, FP...more >>

Hi there, If I have an application that loads 5 grids at the same time, does this means that it uses 5 connections? After the grid is loaded, can I assume that the 5 connections are released and that the governor count goes back to 0? Thanks, FP...more >>

Hi there, Can anyone tell me how much HD I should have available to install safely an MSDE engine? Is there a URL with all the spec/requirements ? Thanks, FP...more >>

I am designing a new database system for a small team of users (5-10). I have created similar systems in the past using an Access FileServer architecture. I am thinking of using MSDE in the new system to improve performance. Does anyone have an opinion on whether this would be worthwhile?...more >>

Hi, We have an old version (well one year) of MSDE in which all databases are limited to a capacity of 2 gig (per database). If have heard that there might be a new version of MSDE in which the Databases capacity would be at 8 gig (per database). My question is : Is this a fact or a rum...more >>