Hi Is there a way which I can revoke a users ability to view SQL stored procs, but still have the ability to execute?? I want to do this via T-SQL, and without just considering the 'WITH ENCRYPTION' option Thanks ...more >>

Hi I want to programatically attach a DB to an instance of MSDE, and then create the user, and give permissions to the DB I've just attached. I can successfully attach the DB, but cannot get the permissions correct Which sequence of T-SQL commands should I be calling to: a). create the log...more >>

The menu item "Backup SQL Database" does not appear as a choice under Database Utilities when running an Access 2003 Project connected to an MSDE 2000 database on the local machine. Why?...more >>

Hi, My Web Data Administrator application was working fine until I applied the latest .Net 1.1 patch to my winxp pro Pc and now the Web Data Administrator used to manage my SQL server databases does not work - i cannot login using either windows integrated or a SQL login account - when i c...more >>

I'm new to using the setup.ini file. Once I have the options entered into the .ini file. How do you call the .ini file from the command line? Thank you, Randy...more >>

How do you change the database owner in MSDE. When I try and drop the current database owner, it gives me an error?...more >>

Hi I have recently read an article which shows how to 'decrypt' SQL stored procedures even though they have been saved with the 'WITH ENCRYPTION' option. This would effectively mean that the encryption does not secure the code to someone who knows how to invoke the decryption. Is there ...more >>

Hi, I installed msde2000a under an administrator account and changed some folderpermissions as said in the baseline analyzer. If i switch to a limited user account, i cannot access the database. Also the services do not appear in sql services management panel. Does someone had this prob...more >>

Hello everyone, I posted this several days ago without response, so I thought I would try again. I've been trying to install MSDE2000RelA on a Win XP Pro machine without success. The install rolls back every time. This machine formerly had Win ME but has been upgraded to XP Home and then...more >>

We want to be able to install the MSDE 2000 with our application. Is there a place you recommend to get clear instuctions on how to accomplish this task. Thank you, Randy...more >>

Hello, I installed MSDE 2000 sp3 on my windows 2000 computer. I installed it within the command prompt as per the instructions "setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="Mypassword" The setup seemed to run ok. The instancename is running in the services and the SQLAgent is r...more >>

Hi NG, the install.log is a very large textfile. If the Install rolls back, where can I find the reason of the error? thanks in advance Roland ...more >>

Hi Does anyone know how to force a windows package to use a specific locale id?? ie. I just want to have 1 locale set of strings in SETUP.INI and to have my setup.exe use these regardless of which locale the user is from. ie. I just want to have [1033] and no others, but want to avoid the...more >>

When my users are in the field and try to switch databases the connection tool cannot see any servers even thought I know they are there. The data link properties dialog does not see them. Also my data entry program also cannot see them but is using sqldmo to list the servers. However my SQL Ser...more >>

i have an appilcation that needs MSDE2000 to be intalled as prerequisit. while building the setup project of my application Using InstallSheild X i've integrated a prerequisit rule which consists about oif MSDE2000 is not installed on the system to stop the intallation ad display an error messag...more >>

New to MSDE (as of today) I have used Access for many years, and understand the FE/BE connection; each is a separate database, linked together. I installed MSDE and opened the Northwind database which looks the same as in Access. I made a copy of it (copy, paste) then changed some of the ...more >>

I just installed MSDE on my desktop and for my first project took a copy of one of my Access 2000 databases I have used for years and upsized it. There were many errors, especially in the queries/views. I expected some errors. This personal database completely resides on my PC, tables and a...more >>

I have two windows XP serv pack 2 machines. Both have MSDE servers running. In one I have successfully created a sql user so that I can connect with a user name and a password. On the other I have followed the same procedure in creating a user, but when I try to connect: "Login failed for user...more >>

Hi Everybody, Please let me know what are the limitations of MSDE in comparison with SQL Server. ...more >>

Hi there, I want to know can i install on my server msde 2000 without installed sql server 2000? I mean what on my server MSSQL server 2000 not installed and i want to install only msde 2000. thank you...more >>

Hi I have an MSDE DB that I have 'inherited'. In one of the tables there is one field that when I view the fields using enterprise manager it says the field is "<Binary>", I am assuming the data is an image as the field is called images. What I want to know is how I can view the images and m...more >>

Hi! I have MSDE installed and everything works fine on a local desktop. But when I want to log in from i.e. a development environment from another machine on my intranet, I can only do that if I have the guest account on the machine where the MSDE runs set as a member of administrators. I'd p...more >>

Hi NG, I have a installation problem on MSDE and install to window 2000 ----------------------------------------------------------- MSI (s) (34:FC): MainEngineThread is returning 1603 MSI (c) (54:58): Back from server. Return value: 1603 MSI (c) (54:58): Decrementing counter to disable shut...more >>

My .NET application that connects to MSDE was running fine on a user's = Win2000 PC, but now that he reinstalled he is getting the following = error: Error opening database connection: Login failed for user 'sa' from the = ..Net SqlClient Data Provider. I have created a custom installat...more >>

I have an msde database (SQL Server 2000) with an web front end. I would like to create an MS Access Project to allow certain users to create ad hoc reports. I have created a new login named Reporter and connected to the msde database using this user. This user has dbreadonly permissions. ...more >>

MSDE would make a great local cache in my app that uses dialup networking. However, the App comminicates with sybase running on Linux. Am I allows to use MSDE this way? Or should I use an open source database for a local cache? Thanks ...more >>

Hi all, I'm having a SQL Server database called X. For testing and training, I would like to make a copy of the entire DB to Y. This copy should include all data, properties, indexes, views, etc. Unfortunately, all my attempts to automate this failed... Server = MSDE2a Original database...more >>

We have packaged MSDE 2000 release A with our applicaiton. A user ran the install, but when MSDE goes to start it says, MSDE is either currport or has been tampered with, please uninstall and reinstall MSDE, invalid package ID. We go to unstill MSDE and it says MSDE is not installed.... We ...more >>

I Need help on how to store a word document in sql server.what datatype and how to convert it to store it. Pleas Help Thank you ...more >>

I have MSDE 2000 installed but don't know how to connect to pubs or northwind. Could anyone help? Running Svr 03 ...more >>

Hi, Is there a way I can store password in SQL table as encrypted using SQL table defintion instead of writing code to do encrypt and decrypt? Thanks....more >>

I want to export or import from MSDE 200 Rel A to Access2003/2000. How can I do ? Thank alot ...more >>

How can I create an INSTANCE name for an existing install of MSDE? is this the ONLY way (No gui for this)? setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd" ...more >>

Is it possible to run MSDE in the same process as your application? I seem to remember someone in a previous company getting SQL Server 7 running in this way, but I could be mistaken. I'm looking to avoid the overhead of marshalling the data across the process boundaries. ...more >>

I have installed MSDE A on W2K Pro with the following command line: c:\msderela\setup.exe sapwd= mypassword securitymode=SQL instancename=myinstanceName This works. I can then setup ODBC using the named instance successfully. I can start/stop the server using the SQL Server manager utilit...more >>

Dear all i'm new in MSDE, yet, after i'd installed for MSDE ReleaseA which get from SQL web site, i realise that I can't run the MSDE withou fully SQL server install, may i know that whether i can run MSD without fully SQL SERVER install? if so, how to use it.. pls give me some guide on that...more >>

Hi, I am trying to create a windows installer package, that will install: - .NET framework - MSDE - My app.. Can anyone offer some advice, or point me in the right direction. How would the package know if .NET framework is already installed, or if MSDE is already installed. Any advi...more >>

Does anyone know the Release date for SQL 2005 Express?? Thanks ...more >>

Hi all, I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every time without any indication of why. I had an earlier installation of MSDE which I removed manually following the instructions in the Knowledge Base article. I installed MSDE on a Windows 2000 Pro machine usi...more >>

I was trying to set up SQL server session state but overwrote the file by mistake (>InstallSqlState.sql, instead of <InstallSqlState.sql at command prompt!) Can someone mail me the file to me at woodcocs@hotmail.com My MSDE version was Release A and the .sql file was in C:\WINDOWS\Microsoft....more >>

I'am trying to install MSDE Rel A but when installer starts to extract files to installation folder i get error message saying i don't have enough space on hard disk. Disk is 40GB anf there's 28GB free space left... -mikko ...more >>

Hello, I was trying to install an instance of MSDE on a machine that already had SQL Server 2000 and in the installation rolled-back with the error of: LoadLibrary failed for [path]\Binn\SEMNT.DLL. GetLastError() returned: 126 I found the MS article: http://support.microsoft.com/default.a...more >>

Hi, I have a win98 Pc connecting to a winxp pc - trying to connect to the MSDE2000 database - the database is operating in mixed mode (allows SQL logins) rather than windows integrated. The database is working ok on winxp pc - i can use the SQL Web Data adminsitrator to verify that SQL Logi...more >>

Is this possible? When troubleshooting MSDE install issues in the field, verbose logging would be nice. But as far as I can see, it's only available for the standalone install (/L*v), and not the merge module. ...more >>

I'm seeing latency issues with a single user on MSDE. It appears that data doesn't get persisted to the database for up to 30 minutes. What the devil could be causing this? These are all new machines running the latest service packs. TIA Tina ...more >>

I'm new to the MSDE part and use to SQL 2000 Enterprise, are there any programming examples of it works? Thanks -- Gary...more >>

Does anyone know if I can Install MSDE to runon top of my Linnux based utility server. All my worksttions are XP Pro and I currently have my access 2002 database residing on the server, and until recently have not had any problems with it. Thank you Tom Gorton...more >>

Does msde support stored procedure? thanks in advance...more >>

I've two server 2003 configurated as cluster. How to install MSDE2000A on nodes ?...more >>

Is there a way to automate backups through MSDE? I have been trying to find a way I can automate a backup of a SQL database through a network. Please help! Thanks in advance...more >>