I'm running Vista Business edition on 2005 Virtual PC. Installed SQL Server 2005 Express latest download, with instance of MSSQLSERVER and service accounts running under "NT AUTHORITY\SYSTEM". Mixed mode authentication specified and sa password specified. Used server manager to create user login...more >>

Hello!! I have a application that creates an instance of MSDE 2000 called MMSQL$EMMSDE. It uses its own login to pass inforamtion called embuser. This company does not provide information on how to recover data from the database. I have a client that had their motherboard crash and needed a...more >>

I'm having problems working on a DNN Site. I'm doing all the dev work local on my machine. I've got SQL 2005 Developer Edition. I'm running a DNN site on the local IIS. I've enabled both tcp and named pipe connections and I've started the browser service. The web config is pointed to Server=(l...more >>

Hi All, One of my costumers have a program that connects to a servers MSDE database. The name of the program is Winfinance. Trough DbaMGR2k i have granted a Windows 2003 security group full permissions on the database. When a client uses the program to connect to the MSDE database using ...more >>

Hi All, I have two servers with the following detail: Server #1 Server Name: SQL2005WIN2003SERVER Windows: Win 2003 Server SQL DB: SQL Server 2005 ('sa', 'pswd123') MS.NET: .NET Framework 1.1 and 2.0 Firewall: NO Server #2 Server Name: OLDMSDE\WIN2000SERVER Windows: Win 2000 Server ...more >>

I hope this is the right ng for sql serer 2005 express I looked for guideline for optimal table design with regard to attribute word boundary and other best practise, I failed to din any. can anyone point me some quick guideline? In some database, each attribute should ideally start on cer...more >>

I'm getting the below error when I try and run a simple OSQL command to = backup the database "TotalSpeech". --------------------------------------------- C:\>OSQL -Usa -P -n -Q "BACKUP DATABASE TotalSpeech TO DISK =3D = 'C:\Program Files\ Microsoft SQL Server\MSSQL.1\MSSQL\Backup\TotalSpeech-F...more >>

i log into my msdn and i cant find sql server 2000 to download. is it still available? i see sp3 and 4 but i do not think they are full verison right? thanks, sd...more >>

Hi Folks I am a newbie trying to attach an MSDE dbf from a whatever.mdf and whatever.ldf files. I keep getting an error that I can't attach the database to the same name as an existing database. Any help would be appreciated? Danny ...more >>

Hi may i know is there anyway for me to find out from any system table in MSDE what are the triggers that have been created ? I wish to delete all and log in a new set of triggers, just in case some old triggers cause some problems to the new ones. Thank you Best regards Boon Yiang ...more >>

OK so I've downloaded and installed this 1.7MB wonder, but now what? I just wanted a nice easy to deploy db to use with my VB 6 app and although the size is now great it doesn't seem to be doing much else. Nothing in the start menu, sys tray, desktop, etc. Just a folder in my program files ...more >>

Does the Personal Edition of SQL Server 2000 (bundled with Enterprise Edition) have a limit on the database size? I know the Desktop Edition has the 2 gig limit, I wonder if the Personal Edition is also limited at the same size... Thanks in advance.......more >>

Hi all, I've installed a program called Winfinance who saves it's data to MSDE. When i log on to the database with my credentials as a server administrator i get access, however, when i try to log on as the "sa" i get access denied. Does anybody have a guess why i don't get access or a way...more >>

Hi, I am running SQL Server Personal Edition on a Win2k Pro box, and I need the server name in Enterprise Mgr toi be something other than (LOCAL), which is default, can I rename it or do I have any option to reinstall it and give it a name? Will MSDE do as much if I need a nerwer product? ...more >>

Hello, I jave a PC with BlackBerry 4.1 installed. So, I have a MSDE installed with default instance. Now I want to install a named instance of MSDE SP4, but it seems to be impossible. I have add the option to create the log file of the installation, but there is no log file created. Seem...more >>

I am aware that there is a 2G limit in MSDE. However in some of our production databases we are running out of space. There is a long term plan to upgrade to SQL2005 to double the space available to us. However in the short term is there a quick way to have more space available ? I could cr...more >>

Hi I wonder how the 4 GB limit is found. Is it the size of the datafile only, or does the size also inlcude the transaction log? Regards Kjell Arne Johansen Kongsberg Maritime as...more >>

Hi, I am planning to develop a asp.net 2 project running on Windows 2003 Web Edition. I am aware of OS and SQL 2005 Express hardware limitation. The followings are my plan, and I appreciate if someone could tell me any issues that I sould be aware of and could arise in a production enviro...more >>

Hello, I have a table simular to the following: ID = int (Key) Name= VarChar Department = nChar Example Data ID Name Department 1 Chuck A 2 Mark A 3 Chuck T 4 Chuck S 5 Mark S I am...more >>