all groups > sql server msde > december 2005 > threads for december 8 - 14, 2005
Filter by week: 1 2 3 4 5
Memory Leaks using MSDE 2000
Posted by Eli at 12/14/2005 7:26:07 AM
Hello.
Our company is running an application that uses the MSDE 2000 (SP4), to load
large amount of data using bulk inserts.
The sqlservr.exe process increases from the 4-10MB that it starts with to
80-100MB after all transactions has been completed.
When starting a new transaction sessio... more >>
Creating a user in SQLExpress with SQL Server Management Studio Express
Posted by Andrew Chalk at 12/13/2005 11:49:50 PM
I have created a user in SQL Server Management Studio Express. However,
whenever my ASP.NET application tries to connect I get the error
Cannot open database "ABC" requested by the login. The login failed. Login
failed for user 'Fred'.
If I change my login string to Integrated Security=SSPI ... more >>
MSDE 2000 and Multiple Applications
Posted by Gene at 12/13/2005 2:43:01 PM
I built a server that will have three applications that require MSDE 2000. We
do not have a SQL server. The apps are SharePoint Services, NAI's ePO and
Veritas' Backup Exec. Can all three applications use one copy of MSDE? This
is a small shop, so there won't be incredible load on the server. ... more >>
MSDE Purge/shrink not allowed as it would take over 2048MB?
Posted by edavid3001 NO[at]SPAM gmail.com at 12/13/2005 10:47:15 AM
I have a database file which is close to the 2048MB limit, but not
there yet.
I am trying DELETE FROM TABLE many of the tables so that I can shrink
it and get under the 2048 limit.
When doing this, I get errors that ALTER (?) would put me over the
2048MB limit..??
I have many full blown... more >>
SQL Server Express as an embedded database
Posted by Dean Mitchell at 12/13/2005 10:43:12 AM
Hi everyone,
We have a requirement to distribute a database with our client-server
application. From a database perspective the application is not
particularly complex. We have a couple of servers that need to connect to
the database using ODBC (none of the clients will connect to the databa... more >>
SQL Server 2005 Express on 2005
Posted by Keith-Earl at 12/13/2005 9:46:45 AM
We currently have SBS 2003 Premium running on a dual processor system. I
checked the requirements and SQL Server 2005 Express will load on SBS 2003
Premium, but what are the limitations? Will my dual processors prevent me
from running Express?
I only want to host my own internal apps, but... more >>
MSDE and SQL together
Posted by Shalini at 12/13/2005 9:08:04 AM
Can we have MSDE and SQL server on the same machine?... more >>
Locking a record.
Posted by William GS at 12/13/2005 4:58:02 AM
Hello, how can I lock a record? it must be modified only for one user at the
same time.
Thansk in advance.
William GS... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MSDE and Linux server
Posted by AA at 12/11/2005 2:40:52 PM
Can one put an MSDE database on a network share that is under the Linux OS
(while MSDE is on a Windows TS server).
AA
... more >>
Business Contact Manager Database locations on partitioned drive
Posted by Morse1 at 12/10/2005 10:01:02 AM
MVP on the Outlook 2003/BCM group suggested I bring this question to SQL
server msde:
I have a partitioned drive with the "C" partition holding only system files
and enough room for a manually sized swap file. Therefore, I need to have
the BCM database files reside on the "D" partition. H... more >>
MSDE DISABLENETWORKPROTOCOLS?
Posted by Dan at 12/8/2005 2:17:02 PM
I have an MSDE database running on a PC for the Microsoft Retail Management
System. In the connection configuration on the local PC where the database
is, the only way I can get it to work is to put a period in as the server
location. The IP of the PC is 192.168.0.112. If I put that IP in as t... more >>
Migrate MSDE data to SQL 2000
Posted by Robert Gandrud at 12/8/2005 12:35:02 PM
I have local copy of MSDE 2000 on an XP workstation.
My program has already been reconfigured to point to a remote (from the XP
viewpoint) SQL 2000 server. As such, it has created the 2 databases that it
uses and is already populating those databases with data.
The question is, how do I g... more >>
|