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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|