all groups > sql server msde > november 2005 > threads for november 1 - 7, 2005
Filter by week: 1 2 3 4 5
MSDE as replacement for other databases and licensing
Posted by Andre Weidner at 11/7/2005 11:46:09 PM
Can I use MSDE as a backend for an application, that two users access over
network? For example install the MSDE on a server and l access it from two
different workstations (at the same time)?
Would I have to pay licensing fees or are our ~200 office licensense
sufficent?
Thanks for any ... more >>
VarChar(2000) truncates to 287 characters! HELP!
Posted by VB6 4VR at 11/7/2005 3:01:06 PM
My application has been in production for years, and all of a sudden this one
field will not allow store more than 256 characters. It is defined in MSDE as
VARCHAR(2000), but when I do an insert of 287 chraacters (for example), only
the first 256 characters are returned to my application as we... more >>
moving data in a table to another server
Posted by den at 11/7/2005 1:55:45 PM
I am a newbie.
Anyway, I have a small web application with an SQL server back end. I have
a developement machine that uses MSDE as the SQL server. Then I have a live
web server and full SQL server 2000 machine for the actual live application.
My question is that I have a table with a lot of... more >>
changing service account as per kb 283811
Posted by bill tie at 11/7/2005 1:40:03 PM
Has anybody been able to change a service account following this article:
http://support.microsoft.com/kb/q283811/
In particular,
- SQL2k0 SP4,
- non-administrative, i.e. plain-vanilla User Group, account,
- MSDE SP4 named instance, or
- named instance,
Thank you.
... more >>
Multiple Databases?
Posted by aredneck at 11/7/2005 11:26:16 AM
I have a server running windows 2000 which I am using as my WSUS server
running a MSDE 2000 DB. I would also like to use this server as my Antivirus
server (Mcafee Protection Pilot). To so this I need to create another MSDE
2000 DB for this application. Can I have multiple MSDE 2000 DBs on ... more >>
MSDE Inatallation
Posted by Abdhul Saleem at 11/7/2005 7:45:03 AM
Hi,
I downloaded the MSDE release A (MSDE2000A.exe) from below mentioned link.
http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&displaylang=en
Extracted the MSDE2000A.exe to local directory (C:\MSDERelA).
Through Command Prompt executed the... more >>
dbcreator from command line
Posted by bill tie at 11/7/2005 6:42:07 AM
I've created an MSDE instance. I need to grant domainName\userName rights
to the instance, specifically to add it to
- security administrator group, and
- database creator group.
I'm unable to concoct correct commands. Can some good soul give me a
working example?
Thank you.
... more >>
Append to Self-Join Table
Posted by Islamegy® at 11/6/2005 12:00:00 AM
I have 5 Self-Join Tables with the same structure
Table1
|--> SubjID
|--> ParentID
|--> SubjText
I want to merge my 5 tables in one table with the same structure without
lose my Tree which have many levels not only one, I need help plz??
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to access an MSDE database over the internet?
Posted by Charles C. at 11/5/2005 1:12:06 PM
How would I access an MSDE database on a win2k server over the internet?
... more >>
Workload Govenor also in SQL 2005 Express Edition
Posted by J. Rusch at 11/4/2005 7:58:03 PM
Hello,
is the Workload Govenor, that limits the MSDE 2000, also implememented in
the new SQL 2005 Express Edition?
Tx,
Jan... more >>
restoring sql database without having SQL SERVER Enterprise editio
Posted by Csuszo Otto at 11/4/2005 6:21:01 PM
I have a backup of a database and trn files I want to restore them back
without having SQL SERVER just MSDE. Can I do it somehow? Please help me
someone I'm not so good with SQL SERVER's
--
VB.NET developer... more >>
Can't connect from SQL Server Management Studio (Beta2, on PC1) to SQL Server 2005 Express (Final, on PC2)
Posted by Davide De Santis at 11/4/2005 10:05:08 AM
Hi all,
I've a problem with the SQL Server Management Studio. I've 2 PCs, the first
one with only SQL Server Management Studio (Beta2) installed, the second
with SQL Server 2005 Express Edition (Final Release). When I try to connect
from SQL Management Studio to the other PC with the Expres... more >>
Installing examples database
Posted by Rodrigo Juarez at 11/4/2005 2:22:52 AM
Hi
I need to install .sql and .mdf files
I'm using MSDE 2000 and Visual Studio .Net 2003
Thanks In Advance
__________________________
Rodrigo Juarez
__________________________
... more >>
Installing MSDE 2000 on a system with SQL Express 2005
Posted by Phil Palios at 11/3/2005 4:18:54 PM
I noticed that when I install an app that uses MSDE 2000 on my system (which
has SQL Express 2005 installed) the MSDE setup will load and hang at "11
minutes" remaining. I can't cancel it, clicking Cancel switches the dialog
to say "Cancelling" but nothing ever happens.
Is it possible for ... more >>
MSDE setup errors
Posted by Shishir at 11/3/2005 1:45:02 PM
I am trying install MSDE on XPSP2 pro. It fails the following set of erros
in the setup log. These lines are from a non-verbose log I created while
running the setup.
Appreciate any help.
Thanks
Shishir
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D360512... more >>
Do I stand a chance of being sucessful?
Posted by The Dodger at 11/3/2005 12:43:36 PM
I'm basically a newbie; I understand the concepts of basic computer
management, databases, networks, and programming. But, I'm not experienced
in Sequel or MSDE.
I'm helping a friend who recently purchased a small service business (a
sports gym) that manages all the membership details usin... more >>
MSDE Setup and first database
Posted by Harley at 11/2/2005 3:59:01 PM
I'm deploying MSDE with a desktop app (windows forms .net).
after installing MSDE, how do I create the database for the application?
I cannot provide a createdb.sql script to the user because there is no
queryanalyzer or similar tools.
How can I run the create query from the setup? or what is t... more >>
Language differance MSDE
Posted by Peter Herijgers at 11/2/2005 1:48:03 PM
Does anyone know if there is a versie differance in an english version of
MSDE and a dutch version?
I have the following problem:
On an english MSDE every thing works fine but with a dutch version I am
getting a strange error message like: SQL Server Error: SQL State 21S01, SQL
Error Code ... more >>
Installing issue (Log included)
Posted by Dan at 11/2/2005 12:16:05 PM
When I try to install MSDE it just stops, the progress bar rolls back.
I've looked through the log file, but I guess I dont know what I am looking
for.
http://www.bercell.com/logfiles.htm (get the log file here)
I am using Windows 2003 Standard edition, with all updates installed. If
... more >>
Database Limit
Posted by Marc Meltzer at 11/2/2005 10:21:33 AM
I have heard the answer before, but I do not remember and I cannot find it
on Microsoft's website. Is the 2 GB limit per database or per server? Can
I have multiple databases reach 2 GB on one MSDE server, or is the maximum
for all databases on the server 2 GB?
Thank you,
Marc
... more >>
Error: %1 is not a valid Win32 application
Posted by Arnau Font at 11/2/2005 12:00:00 AM
Hi,
This morning I tried to start my MSDE instance like I do everyday. But,
sadly, an error message raised, telling me that '%1 is not a valid Win32
application'.
At this point, as I didn't have anything important at this instance, I
removed the program through the control panel, and reinst... more >>
From SQL SERVER TO MSDE
Posted by Sam at 11/2/2005 12:00:00 AM
i have an access application based on sql server
now i was told that for small offices msde is enough and chiper
if it is so can somebody tell me
how to convert the database from sql to msde?
and it cost a lot of code working?
thanks ahead
sam
... more >>
What the defaut login when creating db using Access?
Posted by techworks NO[at]SPAM clear.net.nz at 11/1/2005 8:46:19 PM
Ok I'm just having my first play with MSDE on my laptop. I've installed
it and created a new ADP in Access which has created the SQL Server db
in C:\Program Files\Microsoft SQL Server\MSSQL\Data\TempData.mdf
I've downloaded the web admin tool and also DbaMgr2k but neither of
them will let me c... more >>
Moving database to another server
Posted by Dan at 11/1/2005 5:15:01 AM
We currrently have MSDE running a few databases, but I want to write a few
apps to help with reporting. Ive taken the db and log files from the server,
but cannot seem to get them running on my machine.
I currently have both Sql server2000 developer edition and MSDE on my
machine. I can a... more >>
sql manager screen pop up
Posted by Vivek Sharma at 11/1/2005 12:00:00 AM
Hi,
I have an issue. Whenever I log on to my PC the sqlmanager screen pops up.
How can I disable it to pop up?
Thanks
... more >>
|