Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
all groups > sql server msde > march 2006 > threads for march 15 - 21, 2006

Filter by week: 1 2 3 4 5

no server in SQL Server Service Manager
Posted by Raymond Geering at 3/21/2006 5:20:16 PM
Hello I'm new to MSDE but I had to install it half a year ago for the WSUS server. The WSUS server is running fine which let me thought that the MSDE is installed correctly. However, I noticed a difference between my test system and my productive server. On the test system, the "Service Man...more >>


SQL Server 2005 Express Import/Export
Posted by Randy at 3/21/2006 2:19:26 PM
Is there an Import/Export wizard like SQL Server 2000? I am thinking of developing databases in SQL Server 2005 Express. When done I will need to transfer the tables/data to a SQL Server 2000 database. I normally use the "Import and Export Data" tool to transfer items. Is there a matching to...more >>

Restarting the Server
Posted by Marcos Lommez at 3/21/2006 11:48:47 AM
How can i restart my MSDE server from another application? Is there any api to this? Thanks ...more >>

Computed column
Posted by Gnic at 3/21/2006 9:36:33 AM
Hi, I am trying yo return a set or records by using a SELECT statement, the table contains a column called CreationDate. I want to add one more column to the resulting dataset (not to the table), that value of the column will be 1 if the CreationDate is 1 day before the current time, 0 ot...more >>

Can I replace SQL Server Standard Edition with MSDE?
Posted by GG at 3/21/2006 1:07:26 AM
Hi, We have a software that is developed by using MS SQL Server Standard Edition. The vendor claims that the software cannot be used with MSDE. The question is: Are MSDE and SQL Server Standard Edition exactly the same from a software point of view? Can I replace the standard edition with MSD...more >>

have WMSDE, need MSDE
Posted by Antti at 3/21/2006 12:00:00 AM
Hi. I'm about to install an MSI-packaging software, which needs either MS SQL (we don't have it) or MSDE. I already have WSUS running and it uses WMSDE. Can I install install MSDE (distributed with the software) without screwing up WSUS/WMSDE? Antti ...more >>

Backup Failed with 800423f4 error
Posted by Murray at 3/20/2006 10:34:30 AM
I'm running XP Pro with a local installation of MSDE, when using NTbackup to backup to external tape drive the Shadow copy process fails with error 800423f4 Is there any way to use the NTBackup with the MSDE when the database is not Simple Mode? Thanks...more >>

using Debug in Query Analyzer
Posted by maxzsim via SQLMonster.com at 3/20/2006 4:20:35 AM
Hi , I am using SQL Standard Edition , can i use the debugging tools in QA ? if so how can i bring out the debugging toolbars ( have tried but cannot) appreciate ur advise tks & rdgs Beng Tiong -- Message posted via http://www.sqlmonster.com...more >>



SQLServer Express 2005 licensing
Posted by Dmitry Konnov at 3/19/2006 5:54:25 PM
Please explain me how much of concurent connections can handle SQLServer Express 2005 according license agreement. Thank you. Dmitry ...more >>

Restoring SQL Server2K backup onto SQL Server Express 2005
Posted by keithb at 3/19/2006 2:23:11 PM
Is there any way to restore a full database backup made on sql server 2000 to SQL Server Express 2005? When I tried, I received an error message saying the *.sho file could not be found. Thanks, Keith ...more >>

Is there a good free database manager for SQL Server Express?
Posted by Dale at 3/17/2006 10:43:31 PM
I saw this product called Toad and it looked like it was free but I was unable to install it because it complained about expiring and stuff. Thanks for your help....more >>

Alternative to OpenXML
Posted by Shilpa at 3/16/2006 11:51:16 PM
Hi, I want to enter data in xml into tables in the database. Howevere, I do not want to use OpenXML Please let me know if there is an alternative. Regards, Shilpa ...more >>

.adp, .ade, MSDE and security
Posted by gaba at 3/16/2006 1:40:31 PM
Hi all, I have an Access Project for the front end and a MSDE as back end. The database is in a Server and only administrators have access to it. I've installed a copy of the .adp on each user's computer. I plan to convert to ..ade once the project is finalized. I have a UserName and passwor...more >>

Performance with MSDE on XP
Posted by Alois Mair at 3/16/2006 12:00:00 AM
Hi, i have a msde installed on a Windows XP HE SP2 Computer. This Computer has a 3.06 GHz CPU with 1GB RAM!!! i am developing software with vb6 and go through a odbc (JET 2.8) connection directly to the local installed msde. On my notebook (WinXP PE SP2, 1.4 GHz, 512MB Ram) this software runs...more >>

How can I delete the content of a table referenced by FK?
Posted by dondiego at 3/15/2006 1:56:27 PM
Hello, I'm trying to empty some tables on my customer's DB. But all of them have relations with other tables ( PK/FK). Therefore I get the following error: DELETE statement conflicted with COLUMN REFERENCE constraint 'SER_CALLER_PER_FK'. The conflict occurred in database 'sd45DB', table 'IT...more >>

Connection string for MSDE 2000
Posted by hfk0 at 3/15/2006 10:45:05 AM
Hi, I have a simple asp.net application running ok on my WinXP development server with SQL Server Express 2005 installed locally. After moving to the live server (Win 2000 server with MSDE 2000 installed locally), it's giving me the 'SQL Network Interface Error (error 25): connection string i...more >>

what is msdbdata.mdf?
Posted by dhnriverside at 3/15/2006 4:16:27 AM
Hi guys My client recently had to restore their intranet from backup cos of a server failure. They stopped IIS and SQLServerAgent and stuff, and then restored the whole MSDE2000SQL$INSTANCE folder, and everything *seems* to be working. However, there was a restore error on the msdbdata.mdf...more >>

Installing Inventor10
Posted by Smeusje at 3/15/2006 12:00:00 AM
Hello, I have a problem installing Autodesk Inventor 10 on my WK SP4 OS system on XP SP2 system it works fine. Event log during setup Inventor 10 Pro. Source Loadperf Category (none) Event ID 2000 No object list was found in the installation file. Adding an object list to the installation...more >>


DevelopmentNow Blog