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



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


DevelopmentNow Blog