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 > october 2004 > threads for october 22 - 28, 2004

Filter by week: 1 2 3 4 5

SQL - MSDE - "pubs"
Posted by msnews.microsoft.com at 10/28/2004 9:23:36 PM
Hi, I looking for the data base called "pubs" of the SQL Server MSDE version. Does anyone knows where to find it? And how to add it on the Sql Server? Many thanks for your help. Regards, Germán ...more >>

MSDE 2000: Authentication failed despite BLANKSAPWD
Posted by Stefan M. Huber at 10/28/2004 10:31:15 AM
Hi! We're having troubles on a Windows 2003 Server. MSDE 1.0 does not install (even though we already have this setup at other customers). So I downloaded MSDE 2000. Unfortunately, somebody else just executed the installation procedure without setup-parameters. I wanted to have an emp...more >>

Is using linked server with MSDE the way to go for this problem?
Posted by Rick Pinson at 10/27/2004 3:59:06 PM
We have a problem and I'm not sure of the best way to solve it. Our situation: We have an ASP.NET application which uses a full SQL Server database. We want to add the capability for salespeople to initially install (in a separate procedure) our app locally on a tablet PC with a blank MS...more >>

how to change the decimal symbol
Posted by Jorge Lozano at 10/27/2004 9:42:17 AM
Hi , i have a problem i live in Europe (Spain) and we use the " , " symbol instead of " . " as decimal symbol for money. Actually my problem is that i have a table with some varchar fields storing money values but when i try to use them in stored procedures as money using Cast(field as mon...more >>

How to OPENDATASOURCE ?
Posted by Nieurig at 10/27/2004 6:19:36 AM
Hello Folks, i use MSDE to collect data from a Access-Databases. I'f got the following SELECT-Statement from this newsgroup yesterday: SELECT count(*) FROM OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\\TEMP\\FLS.mdb; User ID=Admin;Password=\'\'')...FLSA It looks l...more >>

enabled/disabled protocols for an msde instance
Posted by S Purkiss at 10/26/2004 10:01:41 PM
Hi folks, Wondering if someone could help me out with an msde/windows sp2 problem. Upon installing sp2, the network protocols for my msde instance become disabled: Sm, Np, Tcp, Via. Is there a command line syntax I can use to re-enable these network protocols? Or is there a windows inter...more >>

Port used by instance
Posted by Subhojit Banerjee at 10/26/2004 3:53:04 PM
Hi, 1. How to figure out what Port the MSDE instances are using? 2. If SQL Server is installed then whaich port does the MSDE instances use? 3. Do they all share the same port? 4. How do you change the Port for the instances(or rather can you?, If yes how?)? Thanks...more >>

Copying tables
Posted by Ademar at 10/26/2004 2:57:22 PM
I am able to query several different msde databases on my network using Query Analyzer from my pc. Using SQL Query Analyzer from my pc, I need to copy a table from a database found on my local msde installation to a database on another pc's msde installation. I was trying to find the SQL Quer...more >>



very new to sql
Posted by Brad at 10/26/2004 11:03:13 AM
I have a table that stores differnet types of data from a VB .Net application. There is one field where I have to store decimal values. For some reason when the value gets stored into the SQL (MSDE version) table the value is rounded or truncated. For instance, I save the value of 3.33 (v...more >>

Setting a database to read only via OSQL
Posted by Jen at 10/26/2004 8:53:07 AM
Hi, Would anyone know what the syntax is for setting a database to read only via OSQL? Thanks, Jen...more >>

unknown error - after months of working
Posted by Marc Pelletier at 10/25/2004 10:24:24 PM
Hello all, I've been running msde 2000 (the version that comes with visual studio) with a very simple database for months. I use Enterprise manager to manage it. Last week I installed xp sp2, but there wasn't enough disk space so I moved a bunch of stuff around, and deleted some things t...more >>

Correct way of unistalling MSDE instance
Posted by Subhojit Banerjee at 10/25/2004 3:45:02 PM
Hi, I am installing an MSDE instance using Setup .... call using a bat file. I know the name of the instance (its a Given). How do I uninstall automatically using a similar call? I cannot afford to ask the user to uninstall it manually by using 'Add remove programs'. Also I would like...more >>

MSDE without SQL Services Manager Icon in System Tray
Posted by Subhojit Banerjee at 10/25/2004 2:23:04 PM
Hi, I need to know how to install MSDE 2000 Rel A (instance) on a machine without the SQL services Manager Icon showing up in the System Tray. This is urgent. Please help. Thanks ...more >>

MSDE IMAGE "CLONED"
Posted by BobS at 10/25/2004 11:23:30 AM
Can MSDE be cloned? I would like to creates an install of MSDE in an image I am working on, and create an image of the load. Does anyone know if this will cause problems for MSDE? Thanks in advance. BobS ...more >>

Filegroup is full
Posted by Eduardo Crespo at 10/25/2004 9:48:50 AM
Hi. I've a msde database and I'm getting the following error every minute Error 1105, Severity: 17, ErrState: 2 Could not allocate space for object 'ProductSettings' in database 'epo_Srv-ms-avd' because the 'Primary' filegroup is full I've cleanup the database but the error keeps on. ...more >>

MSDE2000 deployment
Posted by Viktor Zadro at 10/25/2004 9:38:10 AM
Please help me! How attach existing database in MSDE when run setup.exe in my visual basic.net project. Here are the steps that must be completed during the installation of the database (custom actions): a.. Validate whether the MSDE instance is started. b.. Attach existing database a...more >>

Automating MSDE Setup
Posted by Lingua Terenzio at 10/25/2004 5:59:03 AM
On microsoft support web site "http://support.microsoft.com/default.aspx?scid=kb;en-us;234626" I saw the article 234626 "SAMPLE: Setup1.exe Fully Automating MSDE Setup with the Package and Deployment Wizard (PDW)" about automation of MSDE setup from PDW of Visual Basic but only setup1.exe i...more >>

MSDE Issue
Posted by Sundari at 10/25/2004 3:45:06 AM
Hi, I have a strange issue. We have a DataTable in MSDE with 800 columns. The column name strings are very long.. about 200 characters or more. When we try to do BULK INSERT into this table, MSDE results in a General Network error. We use SQLDataAdapter. I am working against a very...more >>

MSDE 2000 SP3 Merge Module does not installing on windowx XP
Posted by Irakli Lomidze at 10/24/2004 11:52:14 AM
Dear Sirs. MSDE 2000 SP 3a Merge Module Does not installing on Windows XP Without XP Service Pack. It is work if SP1 is instaled on Windows XP. But how i can use that merge modules if SP1 is not installed on Windows XP ? Thank you in advance. ...more >>

Access denied after installing XP-SP2
Posted by Olav at 10/24/2004 7:21:01 AM
Hi, we have an app running in a network where the MSDE database is running on win XP Pro PC. This has been running perfect since january but after installing XP SP2 we get "SQL server does not exist or access denied" when trying to run the app from a client. The app runs fine when started on ...more >>

MSDE over the network
Posted by Rob Reagan at 10/22/2004 11:51:05 AM
Please help! I've had this problem for FOREVER. It's driving me batty. I'm installing MSDE in a networked environment. I'm using SQL-DMO to find all instances of MSDE on the network. *Usually*, this works great. Unfortunately, sometimes MSDE instances refuse to advertise on the network. I ...more >>

How to export a group of tables ??
Posted by Pierluigi Terzoli at 10/22/2004 11:50:44 AM
Hi everybody, I have a simple problem: I wrote a C#.NET application that uses same tables through MSDE. I need to prepare a setup installation with the program and, obviously, the DB minimun. So, I need to export the tables and then import them during the setup execution. At the moment, I cho...more >>

MSDE made available on network
Posted by Raji Arulambalam at 10/22/2004 10:59:10 AM
Hi How do I make an MSDE remote instance to be available on the network. It was installed without the network protocols being enabled. Thanks ...more >>

MSDE 2000 install on W2K3 64bit
Posted by Ernie Billing at 10/22/2004 10:35:04 AM
I'm trying to install MSDE 2000 on an Itanium system running 64bit Windows 2003 Server. The install fails and the eventviewer shows: Product: Microsoft SQL Server Desktop Engine -- Setup failed to configure the server. Refer to the server error logs and setup error logs for more informatio...more >>

MSDE - Unknown Server
Posted by John J. Rambone at 10/22/2004 10:09:39 AM
Hello, I installed software called AutoAPP on a users desktop and this software automatically installs MSDE (No idea what version). When run under the administrator account everything is fine. When the user logs on under their account (power user) SQL Icon is on the task bar, but it is bl...more >>


DevelopmentNow Blog