Perhaps I'm dating myself. In a table, I want to create a primary key that consists of two columns (patrolId and incidentId). From the documentation I have, it looks like you can only have one field that is a primary key. Can you help?...more >>

When attempting to install MSDE 2000a to a machine running XP Pro SP2, I get this error message: 2005-01-21 08:56:55.75 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.1 (Build 2600...more >>

Hi, I have VB 6.0 application using MSDE 2000. I created setup file using Package & Deployment Wizard. I have included "SQL Server Desktop Engine Merge Modules" and "sqlredis.exe". However, when I try to test it on another computer, I get following error. DBNETLIB[ConnectionOpen(Connect()).] ...more >>

We have a custom client/server application that runs against MSDE. This application is distributed to the field through a Setup CD. We used the Installshield to create the setup program. Most of the times when the user tries to install the application it fails after MSDE install saying that ...more >>

We’re trying to upgrade MSDE 7.0 to SQL 2000 Std.. Does anyone have any info on this. What are the do's and don'ts. (This was suggested if the number of Blackberry's exceeds 150) Thanks!!...more >>

HI all, I have in my create script, which was created by a ERD program called Dezign for databases, a line which creates a domain of type interger with an identity. The script is as follows: EXEC sp_addtype PrimaryKey, 'INTEGER IDENTITY(1,1)', 'NULL' GO But I get the following error message:...more >>

Hello I'm trying to migrate the data from Access to MSDE database. What is the easiest and most efficent method of doing it. Also the AutoNumber field from Access, how does that move over to MSDE ? Any help would be appreciated. Thanks Hemang ...more >>

This is my first time installing MSDE. Trying to install it onto Windows XP Pro SP2. Already attempted on 2 different machines. I downloaded msde200a and ran the EXE. It extracted the files to c:\msderela. From the command prompt i run 'setup SAPWD="mypassword"' as per the instructio...more >>

How start my msde 2000 instance again? Thanks a lot...! rv ...more >>

When I try to run osql, I get the following error: c:\program files\Microsoft SQL Server\80\Tools\Binn\ > osql -E -d CCOP or osql -U sa -P AStrongPassword -d CCOP [Shared Memory]SQL Server does not exist or access denied. [Shared Memory]ConnectionOpen (Connect()). I can start the instan...more >>

my visual c++ application must update an field text. my problems is that i can't update this field with more than 128 caracters. i obtain this error: [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with '{\\rtf1\\ansi\\ansicpg1252\\deff0\\deflang1033{\\fonttbl{\\f0\\fs...more >>

I successfully installed MSDE on my Notebook and can access the sample databases from the SQL Servers node using Server Explorer (there are red crosses next to each connection but when I click on them the crosses disappear and the associated data is shown - is this normal?). My problem is...more >>

hey, well just like the subject says, is there a way to automate MSDE, maybe a script,... because MSDE is going to be distributed along with my software, and if the client does not have MSDE installed, i would like to have a script that automatically sets up MSDE... either before or after does...more >>

I want to install MSDE 2000 rel A on a Windows Server 2000 where SQLServer 7 is installed. CAn I do it? Can MSDE and SQLServer live together? Must I do any action before to install MSDE? Thank you in advance enzo giurleo...more >>

Can the MSDE be included within a base XP image without issue. I know that putting SQL on an image is a no-no. Just wanted to hear if the MSDE can be included on an image....more >>

Dear Andrea, I notice you a lot in the newsgroups and was wondering if you could point me in the right direction to do the following.. 1. Embed MSDE in my Setup Installation (VB.NET) 2. After that Add a Database and some Stored Procedures (Used for the Offline Patterns & Practices) 3. ...more >>

Hi All, I multi-boot different versions of Windows. I would like to install MSDE programs on the C: drive of each Windows version, no problem there. But, I would like to share a common location for the MSDE data files. Currently the MSDE installation aborts if it finds data already in...more >>

Hi, How can I update data in MSDE 2000 when I have new data in Access every month? Thank you. Shailesh ...more >>

Guys I want to install MSDE, that is running Sql Server Enterprise version. But the problem is i do not know how it will impact SQL Server Enterprise installation, this is a production box, Management has decided to use the same box to run 2 different 3rd party application, will MSDE sense that...more >>

When I attach an SQL7 database mdf file to an Access 2000 adp project running MSDE 2000 the database is attached but every stored procedure has a ";1" appended to the procedure name. Furhtermore you can't rename the procedure to remove the ";1" and you can't edit it. The problem doesn't oc...more >>

I am looking for a resource online or a document that lists all of the possible options that can be placed in the setup.ini file. Does anyone possibly have this information or know where I can find it? Thank you very much!...more >>

Hi Could any one tell me how to diffentiate between a sql instance and an msde instance thanks mmc...more >>

ok, to my understanding, and correct me if I’m wrong, but by registering the MSDE 2000 Release A I can then develop and distribute my software with MSDE embedded in the application?> secondly, Can i also included the install file MSDE2000A.exe on my distribution CD to allow whoever wants ...more >>

Hi A customer has problems installing MSDE. I cannot understand what the error is. Any help is very appriciated. Regards //Patrik Here is the contents of the log file from where I find the first occurence of the word "fail" and a bit forward: MSI (s) (2C:C8): Creating MSIHANDLE (181) of ...more >>

I am running a small MSDE database local on my PC. I have forgotten/lost the sa password that I set at installation time. Is there a way to recover this and/or what steps are required to fix this issue?...more >>

Hi Everyone, I come from a Foxpro/dBase background (almost 20 yrs of DBF files) and I'm new to SQL. I've been experimenting with VB.Net and MSDE for a few months now and I'm very impressed. I got the go ahead to convert a major xBase application to SQL/VB.Net. I am not sure how to do c...more >>

I'm trying to install SQL2000 Desktop for Visual Studio.Net. Fromcmd prompt I'm running: Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=password Nothing happens then I get a popup saying: "Please go to the control panel to install and configure system components". H...more >>

I am currently running Veritas Backup Exec 9.0 on one of my Servers, it uses MSDE. I am trying to install another application (Journyx Timesheet) on that Server that also uses MSDE and I am getting error messages about a previous installation of Timesheet, which I don't have. After talking...more >>

Hello, i have following Problem: i have created a new instance of Microsoft SQL - Server with MSDE and now i want to connect to a database on this instance through a network. But i do not "see" the instance .... I have tested it with - Enterprise Manager - an Microsoft...more >>

I s there a good explanation in the web for beginners like me? ...more >>

Hi All, I have a trigger for my tables (tblWOs as master and tblWOItems as detail) like this if exist (Select WOID from tblWOItems Where WOID=(Select WOID from Deleted)) Begin Delete from tblWOItems Where WOID=(Select WOID from Deleted) ...more >>

I would like to use both command swithes and setup.ini in our MSDE install; command switches for values determined during install and setup.ini for the variables that are "hardwired". At this Microsoft page: http://support.microsoft.com/default.aspx?scid=kb;en-us;324998 The following is d...more >>

Hi All,, Is it possible to undelete store procedures that accidentally deleted? if yes, how to do that? TIA Yanto ...more >>