all groups > sql server msde > october 2005 > threads for october 29 - 31, 2005
Filter by week: 1 2 3 4 5
Attaching a Database
Posted by nbohana at 10/31/2005 7:14:03 PM
I need some help, I am new at MSDE. I know the command to use but I am not
so sure how to use it. I tried to 'EXEC sp_attach_db @dbname = kennel' at
the command prompt. Can someone point me in the right direction please.
--
Norm Bohana... more >>
MSDE install problems...log attached
Posted by youngveh at 10/31/2005 2:20:10 PM
I am trying to install MSDE desktop engine and I having the most
difficult time.
I installed it once and then tried uninstalling it while it was still
running. Half of it uninstalled the other half still being there. I
then could not reinstall or uninstall cause a the DLL kept running. I
boot... more >>
One Table or Many??
Posted by Islamegy® at 10/31/2005 1:09:36 PM
I'm working in a large database of 4 Million Records of laws in 20 Country..
I have created the law info (text, year... etc) in separate table foreach
country And named my Tables "law"+country id.. but when i need to search in
all countries i write code to rename the tables dynamic but i have a... more >>
MSDE
Posted by Marek at 10/31/2005 10:02:13 AM
Hi,
I can't uninstall MSDE from W2K server. Add/remove doesn't work.
It's any possibility to remove the engine?
Thanks
Marek
... more >>
need help to connect to remote msde db with SQL Web Data Administrator
Posted by comic_rage NO[at]SPAM yahoo.com at 10/31/2005 5:14:47 AM
HI,
I installed the SQL Data Administrator on my client machine, but I'm
having problems connecting to the MSDE database on another machine. At
the MSDE machine, I can us the local SQL Data Administrator to connect
with the following info
login name: sa
password: pwd
sa server: (local)\MY... more >>
MSDE Database size limit (SQL 2005)
Posted by Dan at 10/31/2005 5:10:05 AM
Hi
We have recently been looking to use MSDE for remote users, but are
concerned about the limit of 2GB for a database.
With the launch of SQL 2005 just days away, I was wondering if there is an
SQL 2005 MSDE equivalent? and if so, what is the database size limit?
Any information on this... more >>
MSDE 2GB Limit
Posted by yitzak at 10/31/2005 4:14:49 AM
Hi
A Client has an MSDE install - checked by running @@version (clearly
says developer edition in the result text).
However the size of the data file is over 3GB, even allowing for empty
spaces the amount of data far exceeds 2GB. Pls explain?
The database was filled by regular insert stat... more >>
language option
Posted by danielepasian NO[at]SPAM nospam.com at 10/31/2005 12:00:00 AM
Hi i need to install a Msde on italian server.
i set rigth the collation - caracter set and sort order but i found that
language for the sqlserver is set "italian"
how can i change it to english?
I look on setup.ini settings without success.....
i found another db that has set englis la... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Retrieving Indexes and SQL Relationships programatically
Posted by Mark Hollander at 10/31/2005 12:00:00 AM
Hi All,
I have been able to retrieve the tables within a database automatically via
an sql query. Is there a way that I can retrieve the indexes (with the field
names they are indexing) and relationships (Fields plus tables they are
referencing).
What I am trying to achieve is this.
In ... more >>
redistribute MSDE2K SP3
Posted by Is MSDE2000 free redistributable at 10/30/2005 10:26:02 PM
I developed an application for my customer. I need the MSDE2000 to run the
application. Can I install the MSDE2000 for my customer? Should I pay any
runtime
license fee? Or is it free redistributable?... more >>
SQLEXPRESS: Login failed for user 'sa'. Reason: The account is disabled.
Posted by Oleg Ogurok at 10/30/2005 8:58:17 PM
Hi all,
I've installed Visual Studio 2005 professional with SQL Express Edition. A
third party app needs to use it. When installing, it's asking to login as
'sa' user.
I've enabled MIXED MODE in Registry and reset the 'sa' password with
'sp_password'.
However, if I enter the correct pas... more >>
NewBie, how to trap: SQLAllocHandle Error
Posted by Rob Dob at 10/30/2005 5:06:08 PM
I have a MFC VC7.1++ program using VS2003, and also using the MSDE2000 for
some reason my import is now failing and I cannot figure out why, before
today this first statement use to successfully process. The return value of
retcode now is 0, it use to be retcode = 1 I have looked up the
d... more >>
|