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 > september 2005 > threads for september 8 - 14, 2005

Filter by week: 1 2 3 4 5

Second thought about using MSDE
Posted by Rene at 9/14/2005 7:38:26 PM
We just finished the development of an application that uses the MSDE as its database engine but we are now having second thought regarding using MSDE. There is really nothing wrong with MSDE, its just that we feel a little uncomfortable using it because we never used it before and we have th...more >>


Creating user
Posted by £ukasz at 9/14/2005 11:20:51 AM
Hi, I've just installed MSDE, and I'm wondering how to create user so I don't have to login as 'sa' user. Thanks in advance £ukasz...more >>

sql debugging
Posted by kevin at 9/14/2005 7:56:04 AM
using WINXP PRO SP2, MSDE and VS.NET 2003 When I attempt to "Step Into Stored Procedure" from VS ServerExplorer pane, I get the following error message: Cannot debug stored procedures because the SQL Server database is not setup correctly or user does not have permission to execute master....more >>

MSDE instance setup question
Posted by Rene at 9/14/2005 12:26:39 AM
I needed to distribute the MSDE components to the computers that use my software so I decided to build a setup program using InstallShield that included the MSDE files. After I ran the installation, I noticed that the setup created a folder on my computer using the MSDE instance name I told...more >>

Cant install SP4 on MSDE
Posted by Carlos De Matos at 9/12/2005 4:02:48 PM
I have installed MSDE 1A from the distribution. I have attempted to install the SP4 MSDE distribution several times, using the SAME setup.ini as the one I used to install the intance of MSDE in the first place. I keep getting 'The instance name specified is invalid.'. I have tested connecti...more >>

problem installing sp4 on msde 2000 release A
Posted by Leonardo at 9/12/2005 6:59:12 AM
Hello, When I try to run the setup with the parameters I need (I have a default instance installed already) to upgrade MSDE 2000 the setup program runs with a blue screen on background and a modal window appears showing me the parameters (like /i /p /v etc.). It seems to me that the setup i...more >>

Help for C# Interview questions and career decision
Posted by programmerforknowledge at 9/11/2005 6:57:04 AM
Hi All I am fresh college graduate who has done C and C++ during college times.After that i had done a C# course from one of our local computer institute.The course is BCM which ran for 1 year.But now when i am looking for job the questions asked in interview are really very very weird and does...more >>

Large Log File
Posted by Kevin at 9/10/2005 10:58:41 AM
Have a log file that seems to be growing out of all proportion to the database. Have tried SHRINKDATABASE and SHRINKFILE Get error message 'Cannot shrink log file because all logical files are in use' As all transactions completed ages ago, am puzzled as to why MSDE seems to want to hang on...more >>



Msde and backup-restore
Posted by Dithom at 9/10/2005 3:05:02 AM
I'm using Msde on a PC with XP SP2 acting as "server" and accessing a database on a PC with XP SP2 acting as "client". I can backup my database from the "client" using UNC format "\\client.computer.name\share.name\file.name.bkp" but when trying to restore it from the "client" PC i get errors...more >>

how to install MMC snapin
Posted by muyBN at 9/10/2005 12:40:03 AM
I installed SQL Server 2000 desktop (much different installation than 7.0!); then I went to fire it up, and discovered that I have no MMC or Enterprise Manager! I thought this would be standard stuff in the XP Pro package; I was able to find it right away when I used to run W2000. Any suggest...more >>

EXPORT
Posted by Jose at 9/9/2005 8:51:41 PM
HI How export sql table to ascii file delimited ? VB 6.0, msde 2000 Thanks Jose Perez ...more >>

SQL Trigger start email process?
Posted by Steve Koon at 9/9/2005 1:57:40 PM
I am fairly new to SQL development and have a question about task I am trying to do. I have a database where by users submit entries into a table on my SQL server. Is there a way I can setup a Trigger on the table so that when a record is added that I can have a process that then email me that...more >>

about using osql BACKUP/RESTORE commands
Posted by Mika M at 9/9/2005 1:32:14 PM
Hi! I'm using MSDE 2000 SP4 on local computer. I backed up database into local hard drive using osql command like... OSQL -E -Q "BACKUP DATABASE MYDB TO DISK = 'C:\MYDB.bak'" > LogBackupDatabase.log ....and it's working fine. But when I try to save backup file directly into network d...more >>

Choose MSDE install location?
Posted by I HATE PDAs at 9/8/2005 2:59:50 PM
I'm trying to install MSDE at c:\Program Files\Microsoft\SQL Server\ (as opposed to ...\Microsoft SQL Server\). I tried using the DATADIR= and TARGETDIR= options, but they don't seem to affect the COM and Tools folders (which always get installed at ....\Microsoft SQL Server\80\). I don't s...more >>

msde security...........................
Posted by techiebose at 9/8/2005 1:33:01 PM
I have a business directory software done in vb.net and sqlserver .We are using msde for distribution purpose .The problem we are facing is about the security of the data . The cd goes to common man and we are concerned about the security of the data.Is there any option where we can ensure th...more >>

sqlservr.exe doesn't relase the memory
Posted by Sreedhar at 9/8/2005 12:02:01 AM
Hello, We are using MSDE for our application. The service MSSQL$App will start automatically or when the application is started. While using the application, the memory usage by sqlservr.exe will be increasing and when the application is closed, the sqlservr.exe is not releasing the memory ...more >>


DevelopmentNow Blog