Hello, I would like to store some images in an msde table. When I go into the enterprise manager design table mode and pick image as a field type, it defaults to 16 bytes in size, and doesn't allow me to change the size. I can't create a varbinary field greater than 8000 bytes either. The m...more >>

I have a VB.NET application which reads thousands of records from a MSDE Database, processes them, and writes them against a MYSQL Database. I'm using the MySQL .NET DataProvider for accessing the MYSQL Database. When I test the application on my lap top (512MB RAM; MSDE Memory limited to 260MB) ...more >>

I just installed MSDE (Visual Studio .NET version) into my Visual Studio ..NET 2003 and imported the Northwind database. I'm able to load data into the Northwind tables using the Server Explorer. When I tried dragging the Customers table from the Server Explorer to a Windows form, the CommandTe...more >>

Help! I just upgraded a Windows 2000 Server to the latest release of MSDE - V3. (I have also applied the new MDAC.) I am able to access the MSDE-SQL server with enterprise manager on the machine itself and also from my machine. I have a VB.NET program that is also able to access the new se...more >>

I using MSDE and it works fine in winXP and Win2000. Now im trying to work with Win98 and it gives me this message "Login Fail for user Null - Not associated with trusted SQL" Can somebody help me? :) Thanks in Advance ...more >>

Hi Guys, During install of msde2000a, at the last few second of install on a 2000 server box, installation failed and rollback. Could anyone can help to solve the problem, below copied from msde log file. Thanks, Ted Action 14:58:50: DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C...more >>

I am trying to test a new ASP.NET application on my local instance of MSDE. I created a virtual directory named "db" with a sub-directory of "processed". My web page opens an XML file in the "db" directory, does some processing and then I want to move the file to the "processed" sub-directory. W...more >>

Hi, 1/ I would like to ask if SQL Server 2005 Express could be used as a web database as far as performance (higher number of simultaneous users) is concerned. 2/ I would like to see the comparison between InterBase from Borland and SQL Server 2005 Express. Does exist such comparison s...more >>

I'm new to SQL and I need help. We have a SQL 2000 server and I need to copy the database and all its objects (tables..) to another machine with MSDE version. Thanks for any info....more >>

Here are 2 questions: 1. Can I install MSDE2000 with Hebrew collation (Hebrew_CI_AI) and how exactly it is done 2. Can I assume that a new application which creates it's database on the MSDE2000 take the Hebrew collation by inheritance Thanks Moshe ***************************************** ...more >>

I tried to connect to a msde on an other server via the enterprise manager. This wasn't possible! Unable to establish connection. Server unknown or access denied! What can i do? thx...more >>

Hello EB Can MSDE accept Hebrew characters and sort on them ***************************************** * This message was posted via http://www.sqlmonster.com * * Report spam or abuse by clicking the following URL: * http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=44ee3ed3207b48d38056ff3a7c5eab...more >>

If you have a machine running MSDE and you use Enterprise Manager to connect to it, should you be able to set up database maintenance plans that will delete expired backups? I'm seeing a situation where you can set up the maintenance plan but the drop down box for the type of period (d...more >>

Hi, I wonder if MSDE trigger can call a remote .NET object ,i want to get notify when a new row was added or changed also if I have an access application(forms etc...) can I still use it with MSDE? thanks in advance. ...more >>

After install msde and create another user with system admin authority, is it possible to disable the account sa to access the system for security reason? I have tried using sp_denylogin / sp_revokelogin but both failure. Thanks in advance for any suggestion ...more >>

I am installing MSDE200A on a Windows 2000 Server machine. I install it from the command line with a secure password that is valid. The installation almost finishes and then it rolls back and uninstalls. I am able to install on a XP proffessional machine but not on Windows 2000 server. I ...more >>

Hello! I need to check if a View is empty or not. Which is the fasted way of doing this using a SQL statement? // Anders...more >>

I have installed MSDE 2000 A, but I can't edit the database objects (tables, stored procedures, etc.) in Access 2000. If I try, the window appears only for a moment. Any suggestions to solve the problem? Frank...more >>

Hello Experts, i have problems to run MSDE at a *restricted User-Account* on Windows XP Home. If I use the "Administrator" Account, the DB-Manager connect successfull to its databases and I can use the data from my application. If I use the "restricted User-Account" I only see the sym...more >>

I'm new to MSDE and having a problem connection remotely to my MSDE instance. Locally this connection string works well: value="server=ne14;uid=Support;pwd=Support;database=Support" But when I move my web site to a remote server this will not work. But it do work if I use SQL Server. I u...more >>

I want to develop an app on my computer running SQLServer 7, then backup the data and resrote it at the client's running MSDE. When restoring the backup to MSDE I get this message from SQL-DMO: Location: upgraddb.cpp:214 Instruction: tableIndex < ARRAY_LEN(upgradeMap) I've tried it with two...more >>

I am using MSDE on XP pro Service Pack 2 and have stored my data on the default instance of MSSQLSERVER on my computer ID OFFICEPC. This is networked to LAPTOP and SHOPPC. My Access front end works fine with the SQL back end on the OFFICEPC. But when I try to link the same front end from ...more >>

I am trying to verify the "name" of the MSDE installation on a system. I look at: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server And the value for the InstalledInstances Key is: MSSQLSERVER NetSDK I know that the name of the server used in connection strings is "JIM" Am I ...more >>

I see my little icon in the stystem tray, and I have the green arrow lit as well. I go into Access and start a project and try to connect to my server which is listed in the drop down box of my choice of servers. It asks me a user name and password to connect, but how do I create/add/remov...more >>

I have searched and searched for this so now I asking for HELP! I know SP2 shuts down MSDE ports and you have to manually open them. I have read all articals that apply to this in Microsofts KB. What I am wanting to know is I install MSDE on client machines and it always ends up with a diff...more >>