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 > january 2005 > threads for january 8 - 14, 2005

Filter by week: 1 2 3 4 5

monitor backup jobs
Posted by inquisite at 1/14/2005 2:37:02 PM
We have several backup jobs on MSDE. How do I monitor these jobs and get notified when a job fails. What are the different notification possibilites with MSDE....more >>


SQL CE sync with MSDE (ie. running on XP Home, with no IIS)
Posted by Paul Aspinall at 1/14/2005 12:08:44 PM
Hi, I am trying to write an app that will run on XP Home (ie. no IIS), using MSDE, but which will sync to SQL CE. Can anyone offer some pointers or code samples (prefer C#), on how to do this. All the articles I can find seem to suggest using replication, or RDA, but both appear to use I...more >>

Maintenance Plans on MSDE
Posted by Re Fo at 1/14/2005 10:19:43 AM
Hi NG, I've defined a job and a maintenance plan on my SQL-Server. The target system is using MSDE. I could see that the job was created, but with the Enterprise Manager I cannot see that there is a folder 'Database Maintenance Plans' under folder 'Management'. Does anybody know if Maintena...more >>

Problem connecting to remote MSDE
Posted by Stewart Saathoff at 1/14/2005 10:13:14 AM
Hello, I saw that there was a topic posted on this before but I am unable to view it now. I am having problems connecting to a remote MSDE database. My MSDE database is installed on a Windows 2003 Small Business Server standard edition and I can make an ODBC connection to it on the local ...more >>

Converting MSDE 7 to SQL2000?
Posted by Andreas at 1/14/2005 3:16:24 AM
Hi All, I am trying to upgrade a program that used MSDE 7 but now migrating to SQL2000. I performed a tables & Views import from one server to another however the program returns errors when trying to intall its upgrade: SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect:...more >>

About MDSE
Posted by BonGee at 1/13/2005 2:52:04 PM
What are the differences between MSDE and SQL Server 2000 ? is MSDE Free Licence ? Thank You All.. ...more >>

Administering msde
Posted by admir at 1/13/2005 1:23:11 PM
Hi all, I am totaly new to all this sql server think. I have installed MSDE on Win2K Server. How do you administer this think? Is there een interface? I have tried SQL webadmin. When I try to open the site with IE I see source code of the file default.aspx. Why is this? Any help would ...more >>

start MSDE without reboot after installing
Posted by Aryn at 1/13/2005 9:34:52 AM
Is there a way to start the server right after installing MSDE, without rebooting? Thanks in advance, Aryn. ...more >>



MSDE files
Posted by hph at 1/13/2005 8:47:16 AM
Hello together, i'm looking for a documentation about the MSDE 2000 which can tell me what files will be installed, where they can be found and what task they have (i need to know what process stores, reads and changes the data in the .mdf, .ndf and ..ldf files) Thanks in advance for every...more >>

MSDE and strong password for sa
Posted by vela_rossa at 1/13/2005 8:47:09 AM
Hi, I try to install MSDE but it tells me that I have to provide first a strong Password for sa. OK, so I try to do this and the system tells me that first I have to install a SQL Server... Sorry, but are they joking with me or did I neglect something??? Thanks for a hint....more >>

Backup MSDE database
Posted by Viktor Zadro at 1/13/2005 8:41:44 AM
How add backup job schedule MSDE database with sqldmo(vb.net). Freq_type = daily and file name (.bak and .log) is different for all days. ...more >>

Coding an app to use ActiveSync to sync between SQL CE and SQL 2000 / MSDE
Posted by Paul Aspinall at 1/12/2005 7:49:40 PM
Can anyone provide any pointers or code examples for Coding an app to use ActiveSync to sync between SQL CE and SQL 2000 / MSDE I want the app to use ActiveSync and to be a Windows form app on the PC and with a widest target platform (ie. XP home, so no IIS), therefore using IIS for Sync is...more >>

MSDE Windows User Account Problem
Posted by Clive McFarland at 1/12/2005 12:49:49 PM
Hi, OS: Windows XP SP2 MSDE: SP3a I have installed MSDE as a local administrative user acccount called MPS. When I add a domain user account to the pc (with "local" administrative privileges), this user doesn't even see that the MSDE application has been installed and thus can't us...more >>

MSDE Question
Posted by Skc at 1/12/2005 7:51:03 AM
I just deployed a Windows 2003 Server Std machine which has the SQL Service running (icon in the ashtray). Is this SQL Server or MSDE? In which case, how do I switch off the whole thing so it is totally disabled? Thanks....more >>

MSDE2000 and Netware 6.0
Posted by rexweber NO[at]SPAM gmail.com at 1/11/2005 3:41:57 PM
Is it possible to install MSDE2000 (SQL Server 2000 Desktop Engine) with its data files to a Netware 6.0 mapped drive so that the database engine need not be separately installed on each user's workstation and all the users can share the database? Alternatively, if MSDE2000 must be installed se...more >>

MSDE merge modules
Posted by Richard Wilde at 1/11/2005 2:16:15 PM
Hi I wonder if anyone can help. I am looking for the MSDE merge modules to use in a .net 2003 set up and deployment module. see http://support.microsoft.com/kb/325004/EN-US/ However I have already installed SQL server standard edition on my development server. How do I get these MSM's to...more >>

Moving tables, procs ... etc from full version of SQL Server to MS
Posted by MisterB at 1/11/2005 5:53:06 AM
I have all of the tables, procs ... etc created using a full version of SQL Server. Now I want to move the tables, proc ... etc to MSDE so I can distribute what I've created. Is there an easy way?? ...more >>

Autostart MS Agent on Win98/Me
Posted by Allcomp at 1/10/2005 1:49:58 PM
Hello, does anyone know how I could autostart the MSAgent on Win98/Me with a named instance. I try with scm.exe -Action 1 -Service SQLAgent$$" & str_InstanceName where str_InstanceName is the name of the MSDE Instance. The password is correct (I exported the crypted password from a comp...more >>

Renaming a system (host) after MSDE is installed
Posted by Manzoorul Hassan at 1/10/2005 1:45:21 PM
Should this be an issue? My system was working fine before I renamed my system (host), but since I have renamed it, my application is working from a remote system. From the local system (the machine where the MSDE is running) the app is working fine. Any ideas? - manzoor ...more >>

Installing Northwind
Posted by Hemang Shah at 1/10/2005 12:51:56 PM
Greetings. I just installed MSDE 2000A How can I install northwind database on it ? I looked up on the net and it asks you to install vs2003 version of MSDE So do I have to del this and install the other MSDE ? Coz I did run the ConfigSamples.exe from my VS 2003 sdk directory, but it ...more >>

attach?backup?export?
Posted by Napo at 1/9/2005 8:01:02 PM
what're the difference among these three functions? I can use sp_detach_db/sp_attach_db SP to attach a db in sqlserver. But what SP is in oracle to do the same work? If i want to migrate db from sqlserver to oracle. how to do the attach function in oracle? tks...more >>

Finding user(s) currently logged in
Posted by quilkin at 1/9/2005 6:09:01 AM
Hi, How do I find out what user(s) (if any) are currently logged in? I have methods to change roles for users (or delete them) but these obviously raise errors if the user being deleted is currently active. I just want to programmatically (using C#) check who is logged on before using (for ex...more >>


DevelopmentNow Blog