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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|