all groups > sql server msde > february 2007
SQL Server Express edition 2005
Posted by Manikandan Jawaharlal at 2/27/2007 5:33:27 AM
I installed SQL Server Express edition 2005 in my Windows XP sp 2. I enabled
TCP/named pipes settings in SQL Server Surface Area Configuration.
I am trying to access from other XP Clients. I got the following error.
An error has occurred while establishing a connection to the server. When
... more >>
Is 'Jet' only available on machines with Microsoft Office installed?
Posted by Dave at 2/26/2007 12:00:00 AM
I'm writing an application that needs to run on Windows machines that don't
necessarily have Microsoft Office installed (so no Microsoft Access,
either).
Can I count on Jet being there, even if Microsoft Office isn't? (I doubt
it, but have to ask...)
I know I can automate an installation o... more >>
learn msde basics
Posted by Artplus Lda at 2/25/2007 3:22:01 PM
hello people, im a nwebie...
i need to understand msde, for example:
what is an instance ?
how to install ?
how to install another instance and modify settings (setup.ini)
what i would like is a manual that could guide me...
thanks
... more >>
Enterprise Manager - create table/column
Posted by Vanessa at 2/23/2007 11:55:18 AM
I'm sorry, I've been searching for information that I need but I was in the
middle of the sea. Please point me to the right direction of where should I
post my question. Sorry......
We are using SQL Server 2000. At design table view at SQL Server Enterprise
Manager, it has "Description", "... more >>
SQL Express and MSDE older
Posted by Bunert at 2/21/2007 1:53:45 PM
I have a few apps that are based on and required MSDE instances.
I would like to load SQL Express on the same box as those MSDE instances
reside.
Any issues I might encounter?
... more >>
enumerate the list of MSDE instances
Posted by nidhisharma01 NO[at]SPAM gmail.com at 2/21/2007 3:31:06 AM
Hi All,
I want to enumerate the list of MSDE instances on LAN using VB6.I
cannot use SQLDMO or SMO library.
I am using NetServerEnum API but it displays only SQL servers and
default MSDE instance.
Is there any API or other means to get the list of named instance of
MSDE in VB6.
Please ad... more >>
sql express newsgroup?
Posted by Keith G Hicks at 2/19/2007 9:38:50 PM
Is this generally being used for sql express specific questions or is there
a separate newsgroup?
Thanks,
Keith
... more >>
backups OK in MSDE2000 but won't work in SQLexpress
Posted by quilkin at 2/19/2007 8:32:02 AM
I'm migrating our app from VS2003/MSDE2000 to VS2005/SQLexpress. Generally no
problems, but the backup of database always fails.
The backup command is
"BACKUP DATABASE icespy5 TO DISK='C:\testbackup'"
I get:
"Cannot open backup device 'C:\testbackup'. Operating system error 5(error not
found... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Unicode UTF-8 Support
Posted by ARPREET via SQLMonster.com at 2/18/2007 1:41:32 AM
I wondered if MSDE and PHP allowed for Unicode character sets (such as by
using
the UTF-8 standard)?
Would this also require changes to the MSDE tables/fields or global settings?
We are planning on selling our product to the international market. Our
product currently uses MSDE and PHP... more >>
I need SQL/msde instance to run as user (not admin)
Posted by Gary at 2/17/2007 9:24:03 PM
I have two applications that need to run on a user login (power user rights)
.. One application is a commercial app that installed it's named instance
(that runs fine with user rights); another is a "home-brewed" app (not by me)
that (I believe) uses the default instance. This default instan... more >>
error handling
Posted by ibrahim at 2/15/2007 7:41:36 AM
hi,
i want to catch the error messages and take the control
in delphi, i can do it like this
try
--- statements
except
on e:excepdion do statements
end
can i do it within sql server
... more >>
Silent install
Posted by Jonas Pedersen at 2/15/2007 12:00:00 AM
I am trying to build a install program that will deploy the MSDE2000 silent,
with the configurations I would like.
But I can't find a parameter that can set the server to use local system
account, and not the deafult of the user installing the engine.
Any help would be appreciated.
I have g... more >>
Using MSDE with admin and non-admin on laptop
Posted by Peter Hartlén at 2/13/2007 12:00:00 AM
Hi!
I've installed MSDE 2000 on a laptop using a admin account. I then logon
using a user account. Now MSDE isn't started, and as I don't have admin
privileges I cannot access services etc.
If I am logged on as both user and admin (switching between the accounts)
the MSDE icon in the act... more >>
MSDE Automatic script at each night
Posted by Danny at 2/9/2007 3:53:33 PM
Can you setup within MSDE a script to be run automatically at 12:01 each
night.... The script is very simple...
such as "UPDATE Item Set SaleType = 0 where SaleEndDate < getdate()" Right
now is run this script vi osql and a schedule batch job.
Is saw something about SQL Server Agent ...
A... more >>
MSDE 7 and MSDE 2000 don't working on one PC
Posted by Földvári Ferenc at 2/8/2007 7:04:10 AM
Hi!
On PC workinq one MSDE-7. I can not deploy the MSDE-2000 this PC. This not
work?
Thanks
Ferenc
... more >>
MSDE Maximum Connections
Posted by medentmatt at 2/8/2007 5:18:01 AM
Quick question on MSDE maximum connections. If you use MSDE on several and
the MSDE on each computers is pointing to one PCs MSDE, does that mean they
are always connected regardless if the software you are using is requesting
data or not? Meaning if you have 5 PCs pointing to one PC's MSDE, d... more >>
MSDE 2000 vs SQL express 2005 ???
Posted by calderara at 2/6/2007 10:21:00 PM
Dear all,
We are starting a new developmement of our supervisiob system that will run
uner vista and we will use VS 2005 as a development platform ..
Based on that we need to select proper local database for our local data
archiving.
For that I will certainly us SQL express advance featur... more >>
Error on deleting SQL/MSDE database
Posted by Usman at 2/6/2007 6:08:33 AM
Hi,
On calling the source attached below to drop sql database, I get the
following error randomly,
"Cannot detach the database 'DBNAME' because it is currently in use.
[Microsoft OLE DB Provider for SQL Server]"
I am not sure what am I doing wrong here.
Any pointers in this regard will... more >>
New db??
Posted by Jeff Klein at 2/1/2007 2:26:30 PM
I am going to design a new db that will be accessed thru web pages on my
intranet and the internet. Currently I am using a MS Access db and I have
been told that this is not the best, most efficient "core" for a db. Will
the "Express" edition of MS SQL give me what I am looking for or do I... more >>
Difference between MSDE 7 and SQL 7
Posted by Monik at 2/1/2007 12:14:02 PM
Is there a registry key that will tell me if am running MSDE 7 or MS
SQL 7?
Thanks
... more >>
|