Hi Can i use sql server 2005 express instead of MSDE2000 ? My applications connect using TCP/IP I have some third party MSDE2000 administration tools, will the work with SQL 2005 express ? Thanks Johan ...more >>

Hello All, I'm using Access as a front end to MSDE 2000. What is the best way to shrink the database using code? Presently I'm using a stored procedure called from VB, however error 3251 is generated and the database is still shrunk. It works, but I thought maybe there may be a problem due ...more >>

I am running a default instance of SQL Server Developer 2000 SP 4 on a machine. I installed a Named Instance of MSDE SP3 on the same machine. Everything was fine, then I uninstalled the MSDE Named instance. I rebooted the machine and when I open Enterprise Manager, I can not connect to my ...more >>

Vorrei configurare il file .ini del setup di MSDE in modo tale che dopo l'installazione tutti e tre i servizi di SQL:Sql Server, Seql server agent e ditribuited transaction ... si avviino automaticamente all'avvio del computer, qulcuno sa come fare ? ...more >>

Hello, folks. Don't laugh! I am still dealing with customers who are still using Win95 and WinNT4 primarily in hospitals that are stuck with old equipment and operating systems. The company I work for uses MSDE 1.0 as a part of their installation...I know, MSDE 2000 is preferable but I ...more >>

Hi, I need to backup a MSDE database with sql -E -q "BACKUP DATABASE <database name> TO DISK = 'E:\Database.BAK'" - but I don't know the name of the database. I have tried with '*' without success (as I know there is only one database). However how can I list the MSDE database to know...more >>

Howdy, I just accidently wiped out a table that had some pretty important data in it. Can I restore it from the transaction log? Here's what I've tried so far and I get the errors as stated below. I did do "net pause mssqlserver" before running it. USE master RESTORE DATABASE cpts FR...more >>

Hi there, i have searched for an answer to my question but can't find one anywhere so far, hopefully this is the right place to post such a question, thanks in advance for any help you can give me! I've just moved our company DB from access to msde and while its gone fairly smoothly I have one...more >>

Hi peeps Ok, we have an instance of MSDE running several databases, which is installed on the C: drive (c:\MSSQLSERVER$INSTANCE). Because of space problems on C:, we want to move the entire Instance (including all dbs) to another drive. How do I do this with the minimum of fuss?! Ch...more >>

Hi I need to set security for row level but not based on Database user's login. It should be based on the user table login. For the particular user I need to allow only the particular records to access insert, update delete and select. Let me explain clearly For example think we are usin...more >>

hi i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and run SQL Statement? -- Best Regards Tark M. Siala Development Manager INTERNATIONAL COMPUTER CENTER (ICC.Networking) Mobile: +218-91-3125900 E-Mail: tarksiala@icc-libya.com Messenger: tarksi...more >>

Hello All, I'm in the process of learning T-SQL while using MSDE 2000 SP4 with Access 2002 and the NorthwindCS.adp database. I've purchased the "SQL: Access to SQL Server" published by Apress. Unfortunately the code for the chapter is not included in the download file from http://www.apress....more >>

I am attempting to install MSDE 2000 SP4. Here is my invocation: setup DATADIR="D:\" SAPWD="xxxxxx" DISABLENETWORKPROTOCOLS=0 It fails with the following error: "Setup failed to configure the server." Here is an excerpt from the setup log: <...> MSI (s) (E4:30) [21:30:18:500]: Invoking rem...more >>

We are trying to move our Sharepoint MSDE database from our C: to a new local drive P: The KB article 833797 has a walkthru but we keep getting incorrect syntax errors. We've tried to nest using the ' character in many ways but always get a syntax error near the "-" or "STS_mySrv00-c01n2_1" in ...more >>

hi i working on SQL2000, and want to make "Stored Procedure" that's working every 5 mibute, without making any calling. how i can make that ? -- Best Regards Tark M. Siala Development Manager INTERNATIONAL COMPUTER CENTER (ICC.Networking) Mobile: +218-91-3125900 E-Mail: ...more >>

Hi my Friends. I need to convert a mysql database(structure and data) to a sqlserver database. Have you something (a document, a example) that explain how I do it? thank you ...more >>

Hi We have an intranet running MSDE and we're about to start testing an updated version of the code. We obviously don't want to affect the current data while testing, so we want to backup the MSDE database and then create a replica on the same server that we can use for testing (with up-to-...more >>

Hi, I would like to know whether MSXML parser libraries are shipped with MSDE 2000. Our customers are already using MSDE, and the application we develop uses MSXML parser. So should we supply the XML parser libraries along with our application? Thanks & Regards Sandeep...more >>

First - thanks in advance for any assistance, second - must admit I have very limited knowledge with SQL SEM but here's the issue. I have moved several tables from Access over to a SQL server and all of the tables work fine when linked to an Access db (ODBC connection). One table, however, is ...more >>

Been through a support issue with one of our users. Our software was failing during a small routine which uses the msdb database to check when selected databases are backed up by the user. Our software was reporting an error when we tried to set the .DefaultDatabase property to "msdb". Upon m...more >>

Hi, I'm new to sql but have a website running it on a hosted site. I want to have a local copy of the site running here for testing. I have everything set on my local machine to run it including MSDE and Enterprise Mgr. I've created a blank db with the same name,username and password on ...more >>

I'm trying to Insatlling MSDE 2000. I want to install it on a praticualr D in this case the D drive instaed of C. How can I do this? ...more >>

The code below was working very well in DAO for years (in Access)... Due to the fact the db is being migrated to MSDE/SQL server I changed to connection method (from) DAO to ADO. I am still testing the ADO migration in Access (the original table) hence I am using Jet provider. Please see code b...more >>

Hi I have a backup copy of the master db, but how to retore it ? Should i recreate all user and login info with by entering the t-sql commands to add and grant users, or can i resore my backup of the master database in some way ? (i already tried single user mode to restore the master db ...more >>

Hi All, How do I make use of SQL Express on a website? I am trying to make some first steps with SQL express and need some hand-holding. I have supported a plain-vanilla html website for some time and I am trying encourage the owners of the website to move to at least some database-related...more >>

Someone posted a similar question about a year ago with no real solution given. The problem: My computer will not automatically connect to my local SQL Server upon boot up unless I am a user with administrative rights. In fact, my own computer name doesn't exist in the SQL Service Manager ...more >>

Hi Guys!!! i really need your help now. i tried my level best to make some tricks on this problem but didn't make it. i've got a Big Int datatype column contains the "Ticks" (Long value) and i want to convert it into DateTime but i'm not able to do it. the value is like this 632557193645506...more >>

Hi Using MSDE 2000 on Windows XP Sorry if this is a bit obvious but I've never had to use MSDE without EM before I need to install MSDE from a machine that doesn't have Enterprise Manager. Using Windows authentication only, whats the easiest way to make sure that a) I create an admini...more >>

Hi, I've followed the instructions in the MSDE Rel A distribution, but everytime I try to get MSDE installed on my Server 2003, SP1 box the install gets to about 2 seconds to go and then rolls back and doesn't install at all. It's becoming a problem now since a variety of 3rd party products...more >>

Hi From the local PC windows authentication seems to work, but from remote pc's te client seems to logon as guest. Do i need to install MSDE on a windows server edition to get the windows authentication working ? SQL Authentication works from remote machines, but becorse the password is...more >>