Hi, I'm using the most current version of MSDE, I've ran all my updates on a 2000 Pro machine. Someone else did the install and I'm receiving an error message that SQL is not installed properly or has been tampered with, pleas uninstall and reinstall, so I went to the add/remove and uninsta...more >>

Hi all... alright I'm at a loss here... I'm using BCP to import data into a table in my database.... I keep getting an error of " unexpected Eof' or somthing like that, so I figure my problem is with the text file i'm importing from. To see if I was barking up the right tree, I created a ...more >>

Hi, I'm getting the following error when I use BCP to import a tab seperated file exported from Excel. I hope someone can help me figure it out. I'm using the following command: c:\>bcp myComm.dbo.cmrc_products in test2.txt -n -T -Sbiff\sqlexpress SQLState = 22001, NativeError ...more >>

Customer is trying to restore a backup of their database. SQL Server gives the error: Cannot use backup file %s. Originally formatted sector size 512 and now device sector size 2048. Only one guy (in Germany in March 2000) has ever seen this error. And he never got a resolution. ...more >>

Hi, i am using Express Edition in a medium scale web project. As the perfomance throttle has been removed compared to the Desktop Edition I thought this was a possible solution as the other limitations (CPU and DB-size) are good enough for me. The problem is that I am getting connection t...more >>

Is there any way to automatically create a "CREATE TABLE" statment using an existing table? I would simply want to execute this statement and it would create, in another database, a table with the same structure (no data). Is there a way to do this? cheers nathan ...more >>

I am trying to login to the WSUS instance running on MSDE. I keep getting the access denied message when trying to connect using osql. I have tried osql -E -d WSUS and osql -d WSUS -U username but I dont know if I am just putting in the wrong syntax here or if WSUS has something special about...more >>

I have my database on the E drive. It's a partition on the same physical hard drive as C and D. It's on a Windows 2000 SBS box. I noticed this morning that the database was marked as suspect. I checked the file system and both database files are still there. I detached the database and tri...more >>

I have MSDE installed on a number of windows 2000 servers. Some of these servers have developed a problem running a scheduled task which seems to be caused by the SQL agent. When i try to stop the agent is will not stop, asks if i want to stop the agent but then doesnt do it. This is resolv...more >>

Hello, I am having problems with an installation of MSDE. The computer alraedy has an instance of MSDE installed with Outlook for the Contact Manager and I have no problems with that instance. A new application I have installed also uses an instance of MSDE for a database. During the instal...more >>

Hello, All Sorry for the cross post, but thought these three groups would be best suited to answer my question. I would like to write a VB.Net app that will take an Access 2000 database that has tables, relationships, and data (no queries, forms macros, etc), and create a corresponding SQL Ex...more >>

Hi all, I am trying to configure a pull merge subscription in MSDE (2000, not sql express) at installation-time and am hoping someone can help. Here is my situation: I have a publisher/distributer on machine X. I have a client application that uses MSDE as its db. I want to have an in...more >>

I have just installed VS2005 along with sql server express. I couldn't connect from vs2005 to express so i specifically enabled tcp/ip and started the sql browser service. I then tried to connect. Still had problems. So i went and enabled named piples. I tried again and it still failed. I have...more >>

Not sure if this is a MADE or Visual Studio issue, but here goes: I have MADE and SQL Server GUI tools installed (GUI from Developer Edition) to support database app development with Visual Studio .NET 2003 (VS 2003). I have the sample databases installed (pubs, North, etc.) via an executable ...more >>

I installed SQL 2000 MSDE 2000RelA on Win2K Adv. Server w/ Win2K SP4 (fully patched), and operating as the only domain controller. I have also run the IISLockdown Tool on this server. I originally ran setup using the following parameters: setup sapwd="xxxxxxx" and SQL Service Manager was co...more >>

It's possible to create a maintenance plan with Enterprise manager in my MSDE db? When I try to create a "maintenance plan" I have blank menu (for example "Use this directory" or "remove files older than" or "backup file extension" ). Any help will be appreciated. Thanks...more >>

Hi all, I've been progamming for some years now and only now do I have a situation where I may choose the back-end db for a small new application - I was thinking about SQL Express. Firstly, I have SQL Server 2005 and Analysis Server 2005 running on my machine as well as Sharepoint Porta...more >>

Hello there, Is it possoble to to do MSDE backup from windowsXP- Control Panel(Admin tools) by stopping the service, copying mdf anf ldf files.? Does any body know how to restore from there then? ...more >>

Ok - now that I have a way to manage my Sql Server express files through management studio, is there any way to import data from a csv or like file without having to go through the trouble of using BCP. I see that I can 'script' a table to 'insert to', but I don't think this is what want. B...more >>