I've inherited a project which has numerous fields that have extra spaces in them -- this is causing a problem with data Inserts, Edits, and Deletions in my .ASP Website. I'm importing data tables from ACCESS 2003 into SQL Server 2005, and I need to know if there's a way that I can Right Tr...more >>

Hi there, I was just wandering if it is possible to send e-mail through MSDE. I have several jobs running on the MSDE instance that i would like e- mail notification for when they are completed. I dont seem to be able to set up an SQL Mail profile as it is greyed out. Any help on this ...more >>

Hello; I am trying to upgrade a MSDE 8.0 SP3 to SQL Express. I haven't been able to get the upgrade to work; when I select "default instance", the upgrade is blocked I was going to simply uninstall MSDE, but there's nothing in Add/Remove programs. When I attempted to upgrade MSDE to SP4, I r...more >>

I am running bcm2007 / sql2005 express sp2. I am unable to customize a page within BCM. How do I give myself permissions to be able to make customizations Thanks Bret ...more >>

Hi, I am Gokul, from Chennai - India. I have some queries on 'Microsoft SQL Server Express Edition' redistribution rights. We had developed our application in Microsoft .Net FW 2.0 and our application uses MS SQL Server Express Edition as the backend. We need to bundle MS SQL Server Ex...more >>

Hi, we have an application, that runs on 1000 PC's in different part of the world, and we are using MSDE to contain Configurations data. We are refreshing the data, by restoring a backup, made on our main server. We would like to upgrade the main server from MSSQL2000 to MSSQL2005. But there ...more >>

Currently, PaymentDate in my table is a SMALLDATETIME and NULL is allowed. I would like to alter PaymentDate column to be NOT NULL and set its default value to current date. I am using the following osql command but it generated an error; could someone please help? ALTER COLUMN PaymentD...more >>

I have a sql server 2005 based MyDB.mdf and MyDB.log in c:\MyData folder. All client components are installed on my machine but do not have Management Studio. How do I ALTER a table property in this database either by using osql or sqlcmd command line tools or any other tools? ...more >>

Hi, all, I was wondering if it's possible to Migrate data from SQL 2000 Enterprise to SQL 2000 MSDE? We might have a situation where we need to migrate current database on SQL 2000 Enterprise to SQL 2000 MSDE. If it's possible, is there a how-to websites? Thank you very much....more >>

I had to reinstall sql 2005 server and express.etc what services should I leave running so I can actually get the data itself. when I tried to fill a dataset in .net 2 vb or preview in visual basic 2005 express database explorer, I get --------------------------- Microsoft Visual Basic 2...more >>

Hi, I am trying to install the MSDE 200 Rel A on a windows 2003 Server with MS Win server 2003 enterprise edition, and I am having troubles doing so. Attached at the bottom is the log file from the install to assist in trouble shooting. Here's the command line prompt that I used for the instal...more >>

I'm trying to install MSDE2000A on a windows 2003 server sp2 via the command: setup.exe INSTANCENAME=SOPHOS SAPWD=3fishylip DISABLENETWORKPROTOCOLS=0 /L*v C:\MSDE_LOG.TXT It fails. The relevant portion of the error log is below. I have tried deleting all temp files but cannot figure ou...more >>

Hi all, I have to write a program which i compatible with both access and msde; is there a way of writing the following SQL query so that it works in both access and msde? This works in access... SELECT Count(1) as TheNumber, Format([DataAndTimeOfEvent],'Short Date') AS OnThisDay ....b...more >>