Hello all! I have an instance of MSDE that is marked as SUSPECT. In the error log I get: I/O error on backup or restore restart-checkpoint file 'C:\Program Files\Microsoft SQL Server\MSSQL$SBSMONITORING\backup\model4IDR.ckp'. Operating system error 3(The system cannot find the path specif...more >>

Hello all! I have an instance of MSDE that is marked as SUSPECT. In the error log I get: I/O error on backup or restore restart-checkpoint file 'C:\Program Files\Microsoft SQL Server\MSSQL$SBSMONITORING\backup\model4IDR.ckp'. Operating system error 3(The system cannot find the path specif...more >>

Hello, I've an aplication make with Apache TomCat that uses the SQL as a DB motor, i've installed the MSDE version. Now the Apache couldn't conect with SQL, i think that the problem is in the conection port, because i created an ODBC conection (in the server machine) and it only runs proper...more >>

We have a MSDN subscription so I beleive we can redistribute MSDE with our App., but can it be installed on 2003 Server (or any MS Server?). Apart from the limit of 25 connections and 2GB DB size are there any other important restrictions? Thanks James...more >>

I installed Visual Studio .NET v.1.0 and the included MSDE version of SQL Server. I have an additional copy of MS SQL Server 2000 Enterprise Ed. on CD. I installed Microsoft Analysis Services from this CD on my machine with MSDE SQL Server; it appeared to install cleanly. I ran Analysis Manag...more >>

(Also posted to http://register.microsoft.com/mswish/suggestion.asp) The SQL Web Data Administrator (available here: http://www.microsoft.com/downloads/details.aspx? FamilyId=C039A798-C57A-419E-ACBC- 2A332CB7F959&displaylang=en) is a very useful tool, but there is a problem when it is ins...more >>

I am trying to upsize an Access database to SQL Server 2000. I select "Create new database" option. I select "LOCAL" as the database. and check [x] use trusted connection. SQL server is on this local machine. I supply a name for the new database and click [Next>] and I get the following error. ...more >>

I have installed MSDE 2000A using the ini file method of supplying settings. I supplied values for the following settings: [Options] ALLOWXDBCHAINING=3D0 BLANKSAPWD=3D1 COLLATION=3DLatin1_General_CI_AS DATADIR=3DC:\Program Files\Microsoft SQL Server\MSSQL$HipMSDE\Data\ DISABLENETWORKPROTOCO...more >>

Access upsizing wizard does not seem to offer upsizing to MSDE. I have both SQL Server 2000 and an MSDE instance installed on this laptop. I also have SQL Server 2000 installed on my Server to which this laptop is networked. The Upsizing wizard does not give an option for which database to ...more >>

I am using MSDE and am trying to configure a dataAdapter. I generates a couple of statements automatically, but I get an error message about a couple of other statements. It says that I cannot generate those last statements because it needs to associate a row with a table. If I am correct ther...more >>

Is it true that I have to put more ram in the computer-server if I want more users in the server?...more >>

I'm trying to make MSDE 2000A sort order case-insensitive accent-insensitive. I have this in my setup.ini file: [Options] DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL DATADIR="D:\" AutoStart=255 [DlgCpSortUnicode-0] SortId=54 LCID=1033 CompStyle=196611 It installs but sp_helpsort st...more >>

I have installed msde2000a on a machine in my network running xp pro. I can connect to it locally fine using an access 2003 database project. I cannot connect to it remotely usine sql server enterprice manager, query analyzer or access 2004. My settings from the setup.ini file are shown below....more >>

I am using MSDE in a web application. The ADO.NET works, updating the database correctly. The only thing is when I use the dataset, and when I check the data in the database using server explorer the data is truncated. I tried using the various ntext, nvarchar and setting the length to somthin...more >>

Hi I want to package my C# winforms app, to be deployed with MSDE, as easily as possible for the end user. I want to create an MSI or Installshield (prefer MSI), to setup my C# app, together with MSDE (if not already installed), and the MSDE application DB. How can I detect if MSDE is alr...more >>

Hello All, I apology for posting to many groups but I wasn't sure which group would be best targeted with my question. I have inherited an ASP.Net application that requires some maintenance & bug fixes. I have been asked to also download a copy of the remote SQL Server database that it ...more >>

Ho installato MSDE su un PC senza modificare il file .ini ho notato che da altri PC in rete non riesco a collegarmi in nessun modo ad esso (tramite ADO con applicativo VB). Potrebbe essere necessario specificare qualche altro parametro in fase di installazione o succesivamente per poter abili...more >>

Can someone tell me if it is necessary to specify non-exclusive file access or something when performing a Query using SQL Server 6.5 Enterprise Manager? I'm attempting to look at data while users are on the system and they tell me whenever I run the query, it locks them from accessing their ...more >>

Hello, I will be developing an application for a small company. I plan to use Windows Forms and .NET to develop the UI. Data access and business logic will be implemented using web services and sql server. There is currently 15-20 users. I also need to replicate a set of data from the ce...more >>

Hi, I did MSDE2000 installation with null password. How can I implement password with MSDE2000? I ran osql utility and executed EXEC sp_password NULL, 'mypassword' However when I connect to MSDE2000 sql server it didnot prompt me for password. Any idea, let me know. Thank you. Shaile...more >>

Need an affordable solution to compare two databases or check the database change released. Thanks....more >>

I am doing a test install on a XPsp2 with the firewall turned off prior to prod on WinStd2003. I just want a single install as the default instance? This is my line: c:\setup /settings "install.ini" /L*v C:/MSDELog.log I tired c:\ instead of / thinking a typo...still no go. The ini cont...more >>

Hi I have a problem creating a backup maintenance plan on MDSE 2000 using the wizard. I want the backup to be written to disk and not into the default backup directory. First I set the schedule to Sundays at 02:00 and in the next prompt I set it to write the backup to D:\SQLBUP. So far ever...more >>

what's the syntax error here ? ALTER TABLE INT_LOGIN ADD COLUMN [MGR] BIT NOT NULL DEFAULT 0 " The following error occured while executing the query: Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'COLUMN'. " ...more >>

I'm able to successfully upgrade my MSDE 1 installation from Office 2k to MSDE 2, using any of the versions 1 thru 3a. However, I can't figure out the command-line parameters to upgrade MSDE 2 to a newer version of MSDE 2, at least not retaining my Office Server Extensions database. Considering...more >>

We had a problem with windows 2000 server. This server consist of C drive and D drive. C drive is system file. D drive is Data. I installed Win 2003 into C drive. After then SQL can not recognize D drive. So I can not create the new DB in D drive. Please give me advice. ...more >>

Hello, is there a way to supply a hostname\instance_name to the sql-server service manager (sqlmangr) ? The only parameter i found is /n for no display. mfg Baumgart -- Message posted via http://www.sqlmonster.com...more >>

Hi I have developed a C# app which uses SQL Stored procs... which I plan to deploy as a single / low user version on MSDE. My SP's all have 'meaningful' names. However, as I want to protect my app as much as possible, is it possible to 'obfuscate' the SQL SP names?? I know I could do this m...more >>

MSDE 2000 SP3 fails to install on a windows 2000 terminal server. The error message I get is "MSDE 200 SP3 installation failed with exit code 1603" and “A strong password is required for security reasons. Please use SAPWD switch to supply the same. Refer to read me for more details. Setup wi...more >>

Hi everybody this is my problem: I've just installed MSDE2000 on my machine an it all works fine. I'm able to create tables, storedprocedures whithin an access project, but i cant' connect any client, i tried to use the ip address and also the computer name but it doesnt' connect. I receive a...more >>

My server is running, but I can't connect to it. access find te server but can't connect. I can locally make an access project What did I wrong? (I'm a beginner) ...more >>

Hi - I'm looking at an archive strategy for an MSDE database. In ref to the 2GB "database size" limit: anyone know if this applies to the log file size + data file size, or just to the data file size? I need to figure out the point at which archiving needs to kick in and trim down an ...more >>

how can I give users, permission to log in to the msde server? Do I need a msde-manager program? Where can I find this?...more >>

Is it possible to get hold of the "server name" of an SQLSERVER / MSDE implementation programmatically? I need to write an installer (msi) and create a database. I have to cater for the possibility that SQLSERVER or MSDE is already installed and that the "server name" already is available. I tri...more >>

February 15th, 2pm Pacific Time http://www.microsoft.com/technet/community/chats/chatroom.aspx Join members of the SQL Server development team as we discuss what's coming up in SQL Server 2000 Service Pack 4. See http://www.microsoft.com/technet/community/chats/default.mspx for more infor...more >>

Am I in the wrong newsgroup? I thought I read that there should be some response from Microsoft within one working day? The question below was posted over a week ago..... Hi I have SQL2000 dev edition installed and am trying to install a new named instance of MSDE2000A (to replicate what u...more >>

what do we need to load on a client workstation to connect to an msde db on another system and where do we get that software? is a CAL required for the use of that software. ...more >>

I'm using a product (SAP Business one) using MSDE 2000A. Another product I receintly bought also uses SQL. According to this products manual I need to connect the *.mdf database to my SQL server using SQL Enterprise Manager. How does it work?...more >>

I've written a server application that uses multiplexing(pooling) and it reduces the number of direct client connections to the database to less than 25. I'm happy that the MSDE performs well with the through puts I intend to pass but is anyone aware of any MSDE licensing restriction that sto...more >>