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 > november 2005 > threads for november 1 - 7, 2005

Filter by week: 1 2 3 4 5

MSDE as replacement for other databases and licensing
Posted by Andre Weidner at 11/7/2005 11:46:09 PM
Can I use MSDE as a backend for an application, that two users access over network? For example install the MSDE on a server and l access it from two different workstations (at the same time)? Would I have to pay licensing fees or are our ~200 office licensense sufficent? Thanks for any ...more >>


VarChar(2000) truncates to 287 characters! HELP!
Posted by VB6 4VR at 11/7/2005 3:01:06 PM
My application has been in production for years, and all of a sudden this one field will not allow store more than 256 characters. It is defined in MSDE as VARCHAR(2000), but when I do an insert of 287 chraacters (for example), only the first 256 characters are returned to my application as we...more >>

moving data in a table to another server
Posted by den at 11/7/2005 1:55:45 PM
I am a newbie. Anyway, I have a small web application with an SQL server back end. I have a developement machine that uses MSDE as the SQL server. Then I have a live web server and full SQL server 2000 machine for the actual live application. My question is that I have a table with a lot of...more >>

changing service account as per kb 283811
Posted by bill tie at 11/7/2005 1:40:03 PM
Has anybody been able to change a service account following this article: http://support.microsoft.com/kb/q283811/ In particular, - SQL2k0 SP4, - non-administrative, i.e. plain-vanilla User Group, account, - MSDE SP4 named instance, or - named instance, Thank you. ...more >>

Multiple Databases?
Posted by aredneck at 11/7/2005 11:26:16 AM
I have a server running windows 2000 which I am using as my WSUS server running a MSDE 2000 DB. I would also like to use this server as my Antivirus server (Mcafee Protection Pilot). To so this I need to create another MSDE 2000 DB for this application. Can I have multiple MSDE 2000 DBs on ...more >>

MSDE Inatallation
Posted by Abdhul Saleem at 11/7/2005 7:45:03 AM
Hi, I downloaded the MSDE release A (MSDE2000A.exe) from below mentioned link. http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&displaylang=en Extracted the MSDE2000A.exe to local directory (C:\MSDERelA). Through Command Prompt executed the...more >>

dbcreator from command line
Posted by bill tie at 11/7/2005 6:42:07 AM
I've created an MSDE instance. I need to grant domainName\userName rights to the instance, specifically to add it to - security administrator group, and - database creator group. I'm unable to concoct correct commands. Can some good soul give me a working example? Thank you. ...more >>

Append to Self-Join Table
Posted by Islamegy® at 11/6/2005 12:00:00 AM
I have 5 Self-Join Tables with the same structure Table1 |--> SubjID |--> ParentID |--> SubjText I want to merge my 5 tables in one table with the same structure without lose my Tree which have many levels not only one, I need help plz?? ...more >>



How to access an MSDE database over the internet?
Posted by Charles C. at 11/5/2005 1:12:06 PM
How would I access an MSDE database on a win2k server over the internet? ...more >>

Workload Govenor also in SQL 2005 Express Edition
Posted by J. Rusch at 11/4/2005 7:58:03 PM
Hello, is the Workload Govenor, that limits the MSDE 2000, also implememented in the new SQL 2005 Express Edition? Tx, Jan...more >>

restoring sql database without having SQL SERVER Enterprise editio
Posted by Csuszo Otto at 11/4/2005 6:21:01 PM
I have a backup of a database and trn files I want to restore them back without having SQL SERVER just MSDE. Can I do it somehow? Please help me someone I'm not so good with SQL SERVER's -- VB.NET developer...more >>

Can't connect from SQL Server Management Studio (Beta2, on PC1) to SQL Server 2005 Express (Final, on PC2)
Posted by Davide De Santis at 11/4/2005 10:05:08 AM
Hi all, I've a problem with the SQL Server Management Studio. I've 2 PCs, the first one with only SQL Server Management Studio (Beta2) installed, the second with SQL Server 2005 Express Edition (Final Release). When I try to connect from SQL Management Studio to the other PC with the Expres...more >>

Installing examples database
Posted by Rodrigo Juarez at 11/4/2005 2:22:52 AM
Hi I need to install .sql and .mdf files I'm using MSDE 2000 and Visual Studio .Net 2003 Thanks In Advance __________________________ Rodrigo Juarez __________________________ ...more >>

Installing MSDE 2000 on a system with SQL Express 2005
Posted by Phil Palios at 11/3/2005 4:18:54 PM
I noticed that when I install an app that uses MSDE 2000 on my system (which has SQL Express 2005 installed) the MSDE setup will load and hang at "11 minutes" remaining. I can't cancel it, clicking Cancel switches the dialog to say "Cancelling" but nothing ever happens. Is it possible for ...more >>

MSDE setup errors
Posted by Shishir at 11/3/2005 1:45:02 PM
I am trying install MSDE on XPSP2 pro. It fails the following set of erros in the setup log. These lines are from a non-verbose log I created while running the setup. Appreciate any help. Thanks Shishir TempFolder is C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D360512...more >>

Do I stand a chance of being sucessful?
Posted by The Dodger at 11/3/2005 12:43:36 PM
I'm basically a newbie; I understand the concepts of basic computer management, databases, networks, and programming. But, I'm not experienced in Sequel or MSDE. I'm helping a friend who recently purchased a small service business (a sports gym) that manages all the membership details usin...more >>

MSDE Setup and first database
Posted by Harley at 11/2/2005 3:59:01 PM
I'm deploying MSDE with a desktop app (windows forms .net). after installing MSDE, how do I create the database for the application? I cannot provide a createdb.sql script to the user because there is no queryanalyzer or similar tools. How can I run the create query from the setup? or what is t...more >>

Language differance MSDE
Posted by Peter Herijgers at 11/2/2005 1:48:03 PM
Does anyone know if there is a versie differance in an english version of MSDE and a dutch version? I have the following problem: On an english MSDE every thing works fine but with a dutch version I am getting a strange error message like: SQL Server Error: SQL State 21S01, SQL Error Code ...more >>

Installing issue (Log included)
Posted by Dan at 11/2/2005 12:16:05 PM
When I try to install MSDE it just stops, the progress bar rolls back. I've looked through the log file, but I guess I dont know what I am looking for. http://www.bercell.com/logfiles.htm (get the log file here) I am using Windows 2003 Standard edition, with all updates installed. If ...more >>

Database Limit
Posted by Marc Meltzer at 11/2/2005 10:21:33 AM
I have heard the answer before, but I do not remember and I cannot find it on Microsoft's website. Is the 2 GB limit per database or per server? Can I have multiple databases reach 2 GB on one MSDE server, or is the maximum for all databases on the server 2 GB? Thank you, Marc ...more >>

Error: %1 is not a valid Win32 application
Posted by Arnau Font at 11/2/2005 12:00:00 AM
Hi, This morning I tried to start my MSDE instance like I do everyday. But, sadly, an error message raised, telling me that '%1 is not a valid Win32 application'. At this point, as I didn't have anything important at this instance, I removed the program through the control panel, and reinst...more >>

From SQL SERVER TO MSDE
Posted by Sam at 11/2/2005 12:00:00 AM
i have an access application based on sql server now i was told that for small offices msde is enough and chiper if it is so can somebody tell me how to convert the database from sql to msde? and it cost a lot of code working? thanks ahead sam ...more >>

What the defaut login when creating db using Access?
Posted by techworks NO[at]SPAM clear.net.nz at 11/1/2005 8:46:19 PM
Ok I'm just having my first play with MSDE on my laptop. I've installed it and created a new ADP in Access which has created the SQL Server db in C:\Program Files\Microsoft SQL Server\MSSQL\Data\TempData.mdf I've downloaded the web admin tool and also DbaMgr2k but neither of them will let me c...more >>

Moving database to another server
Posted by Dan at 11/1/2005 5:15:01 AM
We currrently have MSDE running a few databases, but I want to write a few apps to help with reporting. Ive taken the db and log files from the server, but cannot seem to get them running on my machine. I currently have both Sql server2000 developer edition and MSDE on my machine. I can a...more >>

sql manager screen pop up
Posted by Vivek Sharma at 11/1/2005 12:00:00 AM
Hi, I have an issue. Whenever I log on to my PC the sqlmanager screen pops up. How can I disable it to pop up? Thanks ...more >>


DevelopmentNow Blog