I normally keep my MSDE server stopped and start it only when I run the app that uses it (otherwise, my corporate backup prog complains abt files in use being not updated). How can I start my MSDE through a command line so that I can include it in a batch file that starts the MSDE and my ap...more >>

When I switch from office network to home wireless, my app using a MSDE instance has got problem in finding the database. Obviously, the change in IP Address is not liked by the MSDE server. I believed the XP Pro is more friendlier in switching between adapters, or am I wrong? Is there any ...more >>

I have for the past 1.5 weeks been trying to get MSDE installed on a Windows XP computer. We are installing MSDE sp3 which we have installed on more than 20+ computers. Some computers Windows 2003 Servers some Windows XP Pro. We have NEVER had a problem. So before anyone suggest it, I don't ...more >>

Hi, I have just installed SQL Server 2005 Express Adv. which I expected to have the Agent service. How do I install the agent service and where can I get it from?? Thanks ...more >>

How do I import a db into MSDE2000? Can it be done? I backed a db up from another server and now I want to import on to this new machine. Not sure how to go about doing that though... Thanks. ...more >>

Hello, I imported dbf files (dbase) into an msde database. I see the tables with the data in the msde database. The data is identical. The only change made to the code is in the DSN assignment in the Recordset's GetDefaultConnect(), return _T("ODBC;DSN=themsde"). Both DSN's are ODBC, t...more >>

Greetings, if anyone has advice or can point me in the right direction it would be appreciated. Been a week now, and I just can not make progress on this issue. Machine is windows xp sp2 UPS Application Error Message: "Installation failure during Step 7 of 27: MSDEInstaller:PostInstallationSt...more >>

Hi! I have tried to setup my SQL Server Browser to Network mode but I keep getting an error saying "WMI Provider Error", "Can't add or remove a member of the local group because the member does not exist" Very strange error. What can I do to be able to set it to network mode? Thanks much in a...more >>

Hey guys, I have the MSDE SQL Server 2003 running on my SBS 2003. I am using my laptop to develop my website with Microsoft Visual Web Developer. I've been trying to create a connection to the SBS 2003 SQL server but I keep getting a connection problem. Is it possible to connect with Visual We...more >>

Hi, I am using the "Web Data Administrator" on the MS SQL Server (2000 I think) database provided by my ISP. I use the Export function every so often so that I can make a copy on my local SQL server, (I have no access to DTS on the ISP server). However, lately, the sheer amount of recor...more >>

Hi I am trying to resolve a problem with an SQL database for a known antivirus application we use. Along the way someone has installed SQLExpress on the application server and managed to upgrade the database using this. Starting from the begining....I was resolving a problem with the appl...more >>

Hi I know that MS SQL Server 2000 versions (including MSDE) are not supported on Windows Vista, but still I'd like to ask if anyone knows why when MSDE is installed on Vista, each time after a user logs in to Windows, the instalation dialog appears for few seconds. The dialog ti...more >>

Any problems installing the client tools from Sql2000 on an MSDE instance to provide GUI management capability? -- Graham (Pete) Berry PeteBerry@Caltech.edu...more >>

Trying to add more functionality to the following trigger. Need to insert three field into another table using the ID from the first insert (i.id), the ID from the Trigger Insert (??) and a QTY value of .25? My question is how do I get the ID from the trigger insert? ITEM Table ID int ...more >>

Hello, I see that the max length of datatype text is some where abouts 2 million characters. My question is, when I conenct the MSDE database to SQL Enterprise administrator, and look at the table design, the length of the data reads "16" It's quite obvious this doesn't mean 16 characters....more >>

To all SQL guru I understand MS SQL Express can only "subscribe" which means u need Full version of MS SQL to do the "publication" . Is there any other way to do some sort of replication without the full MS SQL? Cheers Gigi ...more >>

Hi, I would like to have a ODBC connection to a MSDE 2000 database on a Win 2003 server from a client PC. Can this be done? On the client I can browse to the the SQL server, but I cannot connect to it. Is there a way to connect and retreive the data ? Arnold ...more >>

Trying to make a trigger - not sure of right syntax... Table ITEM ID Description nvarchar(30) ItemLookupCode nvarchar(25) DepartmentID int CategoryID int Price money PriceA money PriceB money TaxID int ItemType smallint Cost money --------------------------------------------------...more >>

Hi all, my server is suddenly crash. i hv got the MDF & LDF file back. but when i try to attach those files to other server, it's error "Error 5172: The header for the 'XXXX.MDF' is not a valid database file header. The PageAudit property is incorrect" What does it means? how i can fix? ...more >>

Hello, Several consecutive records have been deleted out of an MSDE database and the program that uses the database doesn't like it. I'm curious if it's possible to... say... reset the primary key count so that the records all shift to fill the "dead space" left by the deleted records. I ...more >>