Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
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 >>



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 >>


DevelopmentNow Blog