Hi Everyone, Today i faced the following issue : An MSDE Database I had been working on in the morning in order to be able to upgrade our software, with the statement: Through Osql : 1)IF ( (SELECT currentSize= (size /128) FROM PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200) 2...more >>

I have downloaded SQL Server 2005 Express edition, freeware. I'm not able to see DTS/OSQL Components getting installed. Pl. help in installing these components Thanks KRV ...more >>

Hi there Have a question - is SQL server 2005 express and MSDE coexist on the same computer, seems like i have some trouble accessing 2005 in the right way from VS 2003, and if not - any recommandations around management software for MSDE? Regards Arne Rasmussen ...more >>

I am developing an app that uses a sql server backend but also need to run queries on temporary data tables. In order to reduce network traffice, I want to do this on the workstations rather than passing all the work over the net. Since msde does not come with development tools and also sin...more >>

Hello I am running a stand-alone test environment for an application in XP Pro which I can only use MSDE to manage my databases. I've successfully installed msde and am finally able to connect using 'osql -Usa -Ppassword -S (local)\testmachine' , because I can get the '1>' command promp...more >>

Recently when I try to upgrade my current MSDE2000 (SP3a) to SP4 in Windows XP – SP2, the system just keep on failing me. He is the scenario: 1. Download the MSDE 2000 SP4 from Microsoft site 2. Extract the MSDE SP4 3. Run the following command via command prompt or ba...more >>

I have been tring to install the MSDE 200Aon my marchine that is using the command prompt. this is the command that i was using: (setup INSTANCENAME="SA" SECURITYMODE=SQL SAPWD="SqlAdmin1" TARGETDIR="C:\" ) but it gave me the following error message; (Go to the control panel to install ...more >>

Hi all, I'm just curious, can MSDE and SQL Server exist together on the same box? I'm using MSDE now and want to add a SQL Server onto that same box. MSDE db is in use. Many thanks, Cheers. ...more >>

What is the recommended method to import an Excel spreadsheet into a SQLServer table. I'd like to write a VB function activated by a button press by the user to perform the import operation. Thanks! Jerry...more >>

Hi all, On my computer I have installed two instances of SQL Server 2000. The first one is the default instance of SQL Server Personal Edition and the second one is an MSDE instance. From other PCs on the company LAN I can connect, by name, only to the first one and not to the MSDE insta...more >>

Hello everyone, i have problem installing MSDE 2000a on server 2003 R2. The problem is that installation is starting but then at the end just roll back and get this two event log: Event Type: Error Event Source: LoadPerf Event Category: None Event ID: 3001 Date: 20.9.2006 Time: 8:30...more >>

May I install Enterprise Manager on an MSDE Machine with no licensing issues? Thanks, Mac ...more >>

If the only application using MSDE on a give machine is closed, can I simply FTP the *.mdb and *.ldb files to a remote location for backup? Thanks , Mac ...more >>

I currently exclude the directories that contain the sql database files (mdf, ldf) from my antivirus 'real time protection' and scheduled sweep scans. Actually I do this for any database files (act, quickbooks, ms access) but I was recently thinking about this and I realized that I'm not rea...more >>

I'm trying to install Great Plains 9.0 on a SBS 2003 Standard Edition server with SP1. I can create an MSDE instance and connect to it with SQL or Windows authentication on the server. From client workstations I can connect with Windows authentication but not SQL authentication. I can install ...more >>

I have installed MSDE 2000 (with SP3a) on server with Windows Server 2003: I have executed simply a double-click on setup.exe ("sa" without password). Then I have created my db with a comand via osql and then I have attached it. When I try to create an ODBC link (from Control Panel) on a client a...more >>

I'm taking a web application that was connected to SQL 2000 Std Ed and making a desktop version out of it. It will be Windows forms connected to local databases created on the fly. Does anyone have advice for the best way to replace the stored procs? SC ...more >>

Hi peeps, I created a couple of backup scripts using the jobscheduler stuff. It works, but it keeps appending all the data to the backup everytime into the same file, not OVER it. So the backup files are growing in size, now at about 300mb (the actual db is about 15mb). I'm not quite su...more >>

I understand that the max size for a db in MSDE is 2GB. My question is does this 2GB limit just include the actual data or is it the total size of the mdf file which includes data and "empty" space? I need to set up some monitoring which monitors when the MSDE databases are approaching th...more >>

Hi, I have SQL Express 2005 installed on my machine. Now I want to restore a database to this SQL express. How to do this? Thanks -- pmud...more >>

I have installed SQLExpress2005 and I need to make my jobs like backups schedules but SQLExpress don't have SQLAgent how I can do this?...more >>

Hi, Doesn SQL Desktop engine or SQL Express support the WIndows XP Tablet PC edition 2005 ?? Thanks -- pmud...more >>

Hi I installed MSDE 2000. I dont see the enterprise manager though? How to I restore 2 databases which I need to. I know we can do this with enterprise manager in sql server 2000. How do I restore and see the database with MSDE 2000?? Also, how can I see Enterprise Manager in SQL Express 2...more >>

Hello, I am using an MSDE database for an archiving software. Is there any possibility to create an dump of the MSDE-database, since I am having problems and the support-team needs the dump of the database. Best regards. C.B. ...more >>

I have used sql server 2000 (not MSDE) for some development projects for myself (not professionally). I am looking to start a new project and would like to use sql server 2005 technology. This time I don't have the full blown server (and don't need it) so I will use the free version. I know fo...more >>

Hi, is it possible to upgrade MSDE 2000 to SQL 2000 Standered. If so what is the simplest and easist way Thanks b...more >>

If we only have MSDE can we run SQL profiler or SQL Manager to keep track of the connections of data base? Thank you for any help QN...more >>

Good Day All, I need some MSDE assistance. MOM 2005 does not detect MSDE by default, and I am attempting to create some custom discovery rules to change that. What I need to know to make this happen in the most effective way possible is what registry key(s) can I look at to 1) positively i...more >>

Hi, Can anyone tell me if MSDE 2000 suppports the making of queries using http? If so is there anything spoecial I need to install or do to set this functionality up? How would I go about setting up a virtual directory? Any information would be welcome! Regards, Vaughn ...more >>

Hi, Can anybody please tell me How to know if a table exist in a Stored Procedure? Thanks in advance, -- Jorge L. Cotarelo ...more >>

Hi, Can anyone tell me if MSDE supports DTS or can run a DTS package. I have a small client who wants to use MSDE to record some data and then upload the data to a web server that supports SQL Server 2000 via a DTS package if possible. I have also been told that it is possible to save a...more >>

I am working on a server which has MSDE installed, but currently we cannot connect to this instance using Enterprise Manager, and I'm trying to establish whether it's because DISABLENETWORKPROTOCOLS=1 or if it might be a firewall issue. I am trying to find out how to do two things: 1. How can...more >>

Hi, We developped an application with several services which have to start automatically after startup of the computer. These services are dependent of each other. The first service, 'FCHost', is dependent of the MSDE. So the dependency of 'FCHost' is set to MSQLServer. 'FCHost' has to conn...more >>

I need to know how use Linked Server, I try in the Management Studio Express and do it but when my aplication try to use give error. Please Help Me...more >>

I'm trying to backup up my MSDE database called db1. I run the following command from a command promt. osql -E -n -Q "Backup Database db1 to disk='c:\backup\db1.bak'" The command completed successfuly. I notice that the BAK file is smaller than the mdf file. Is this normal?...more >>

Hi, i have a complex database. If a user (database is set to single user) make changes, and the user want do redo these changes, i need a kind of manual setted checkpoints. Such a checkpoint is set before changes made. The idea is, to set a checkpoint, (store all checkpoints), and when its ...more >>

Hello, Does anyone know how many databases i can create on SQL 2005 Express, and how many connection SQL 2005 Express at the same time supports? Thanks. Dennis...more >>

Hi, Where can I find event logs for SQL Server 2005 (ie. not the transaction log, or is that the only log I need?). My test PC suddenly became incredibly slow at 6:01am, kicking off the 12 connected clients (they timed out), so I'm looking to investigate why it suddenly slowed down, when i...more >>

Hi, Simple question - Is it possible to install MSDE2000 (Release A) alongside SQLServer2005 Express? Thanks. -- BadHead :) --- OS: Windows XP Professional SP2 (32-bit) Office Suite: Microsoft Office 2003 Professional SP2 Motherboard: Abit AN8 Fatal1ty CPU: AMD64x2 4600+ RAM: ...more >>

I have a windows xp pro version 5.1 sp2 I run the setup.exe and get this message: "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to the readme ...." I don't see in the readme how to attach the switch to the setup.exe? -- if that...more >>

I want to install sqlexpress 2005 with collate SQL_Latin1_General_CP1_CI_AS because my database have it an when I use tempdb ...more >>