Hi I need to pass a long filename to a stored proc., which will then export a file via BCP How can I pass a file, which has: c:\program files\blah blah etc The proc seems to fail at the moment, due to the long filenames. How can I force the BCP command to accept this? Thanks ...more >>

--msde instance with DISABLENETWORKPROTOCOLS=0 is installed and working. --local connection works to confirm username and password --firewall ports are configured correctly --remote telnet connection works to confirm ip and port # , but tcp/ip does not connect any suggestions on how to fix/...more >>

Hello, I use VisualBasic 6, MSDE and ADO2.8. I seek to know how many recordsets are open at the same time. How much CPU (or memory) use they? My goal is to know if all my recordset is well closed. Thank you....more >>

Hello all, I have two computers in LAN. Both computers are visible one to another. First computer has MSDE installed on it. Second cumputer runs application that needs to connect to MSDE installed on the first computer. The problem is that application installed on second computer cannot ...more >>

MSDE instance is installed on windows server which operates as a webhost. Now it needs to be enabled on the network/internet for access from websites and remote connections. 1] what server name is used to access it over the local network ? 2] how does it get a server name accessible over th...more >>

Hallo everyone, I have come across a pc where an administration package is installed. The operating system is Windows ME. I belive the package uses MSDE 7. Is there anyway i can check the MSDE Version. Further when i clik the service manager console icon from task bar, i notice that the sql se...more >>

Dear Experts, I have the well known "Primary Filegroup is full" error and I'm wondering why. sp_showUsage: TABLE myTable ROWS 19344740 RESERVED KB 2060520 DATA KB 821304 INDEX KB2640 UNUSED KB 123576 sp_spaceUsed: database_name myDB database_size M...more >>

Hello, Does anyone know if a C# (or other managed language) DLL can be used as a callback library for the Callback parameter during setup? I have experience writing C# applications/libraries but not C++. If it can't be done in C# then does anyone know of any good C++ templates that I coul...more >>

We have a few rather advanced calculation routines developed in C++. Currently we are using a Sybase ASA database for our app. and these routines are accessible by so called external functions exported by a DLL (dynamic link library) that we wrote in C++. Sybase supports this quite nicely. T...more >>

What memory settings should i configure to tune msde? Sometimes it will be installed on a PC but at other times it will be an app server. On the app server i want to take advantage of the increase in memory....more >>

I was directed to create filegroups so that clients that install msde or sql server would look the same Can anyone point me in the right direction on how to create the filegroups on msde. I was thinking about just splitting up the indexes and tables at this point. Is this what a sql se...more >>

Hello, Is there any way to run MSDE in memory (like SharpHSQL). I am writing some unit tests that have database operations in them, and having to access the disk everytime is very expensive. Thanks, Hari...more >>

Hi, I have an MSDE 2000 SP3a running on Win2k3, problem I have is that I am writing a little basic web app. One of the fields I have set to bit which I assumed I would use for True or False (1 or 0) - Using Dreamweaver it seems that when I check a field in order to set it to "true" it seems t...more >>

Hi, I have been trying to install HP SIM 4.2. In order for HP SIM to work I also need to install MSDE. MSDE starts to install and gets so far in, it stops with the message "Setup failed to configure the server. Refer to the server error logs and setup error logs for more information...more >>

in DateTime column called ExpireDate, I have default value of (1/1/2020) yet when data entry is made (without ExpireDate value) the value is always set at 1/1/1900 why is default not entered as 1/1/2020 ? ...more >>

I installed MSDE using Windows authentication and gave the SA logon ID a "strong" password. However, when I attempt to logon to the MSDE database (via OSQL) I get a message stating something to the effect of "the logon ID is not associated with a trusted account". I realize what this means (...more >>

Hi! I installed the MSDE SP3 upgrade with theses parameters (/upgradesp sqlrun BLANKSAPWD=1) on differents computer with the previous version of MSDE 2K. One of them had a bad result: The files in the binn folder kept the old version 8.00.194 instead of 8.00.760. The interface told me that ...more >>

Hi all, I need to update a table using ORDER BY clause in order to write a sequence number to a column. I found a way myself, in MSSQL 2k 8.00.818 (SP3) works fine, but in MSDE 8.00.818 (SP3) does'nt work at all!!! Here is the statement: DECLARE @NewNumber As SmallInt SET @NewNumbe...more >>

Is there a way to turn off System Administrators in Server Roles for the Builtin\Administrators using the deployment toolkit?...more >>

Hi, I'm just wondering when I better should use an Sql Server or when a MSDE. Whet are the advantages of one to another en the limits etc. And this espacially when using them as databases for VB.NET-applications. Any information would be great! Thanks a lot in advance, Pieter ...more >>

Hi all, How do I customize table names returned from the stored procedure? For example, I have a stored procedure that is something like this: -------------------------------------- SELECT * FROM Employee SELECT * FROM Employer SELECT * FROM HealthInsurance -----------------------------------...more >>

Hello, I'm new with SQL Server. Could Data Transformation package that made by DTC in SQL Server running with MSDE...? Thanks, Abdul -- Message posted via http://www.sqlmonster.com...more >>

We have a windows 2003 box running a vendors version of MSDE 2000. I recently upgraded the MSDE engine to Service pack 3a. However our national counterparts (who run MBSA to scan the servers) believe the patch has not been applied. MBSA reports as follows; - SQL SERVER 2000 GOLD - The latest...more >>

I am new to SQL Server. What would cause the User Defined Functions to not appear in the EM on an MSDE installation of SQL Server? I can see the User Defined Functions on my Standard installations......more >>

How stop/start SQLSERVER (MSDE) on network with command prompt. ...more >>

Hello, I use Visual Basic 6 and MSDE. I have a problem with @@SPID and my ADO connection : Just after the connection: Connection.Execute("Select @@SPID").Fields(0).Value = 52 SPID #52 is visible in the processes of MSDE. It's good Just after ADODB.Recordset.open "Select ...." , Con...more >>

In my company i have one requirement.i have a database in sql server and i have one report generation application to connect that database an it will generate reports.for this client machine must have sql server.now my client need data and application in one cd .he want to see the reports usin...more >>

How many concurrent users will MSDE support in a client/server application? I found 25 users for a website but I have an Access application that I wish to connect to MSDE and wish to know how many users before having to upgrade to the full blown version of SQL Server....more >>

To allow for a proper migration path to SQL Server should i create my MSDE db with FileGroups or can this be done later when migrating to SQL Server without causing issues? Can anyone recommend a best practice on what should be in each group? tables (this can be broken further for large/smal...more >>