all groups > sql server msde > february 2006 > threads for february 22 - 28, 2006
Filter by week: 1 2 3 4
replacment for MSDE
Posted by gerryR at 2/28/2006 3:20:47 PM
I've read that MSDE will cease to be supported and developed from 2007 some
time. What is the alternative DB to use once this happens? Is there a
MSQLFree for example?
cheers
gerryR
... more >>
Multi-field Index
Posted by SAC at 2/28/2006 11:43:21 AM
I'm using MSDE 2000.
How can I make a multi-field unique index? Doesn't seem to be a way.
Thanks.
... more >>
my doc.mdf
Posted by SAC at 2/28/2006 9:17:53 AM
I can't create a db because my doc.mdf already exists.
I've stopped the server, deleted this file as well as it's related file and
made a new db but now I don't know where the two new files are located.
They are not in the same directory as the other dbs.
What should I do?
... more >>
I got error when installing MSDE 2000 on WinXP Pro
Posted by John Chan at 2/24/2006 11:59:27 PM
I downloaded SQL Server 2000 Service Pack 4 and installed. I setup it up by
typing in the command line:
setup SAPWD=â€sapass†SECURITYMODE=SQL
It started but up to "Gathering required information", an error box poped up
with message:
"unable to determine system defaul... more >>
error with sqlmaint.exe
Posted by gerryR at 2/24/2006 2:32:52 PM
Hi All
I'm using McAfee ePO here which uses an MSDE database. I am trying to run
the recommended maintenance command on the DB but keep getting an error. It
seems to be related to the -U and -P account I'm using but I've tried every
variation of user and password it could be including domai... more >>
SQL Express gives me (In Recovery) message.
Posted by Dave Dessex at 2/23/2006 11:33:47 PM
I have a fairly large database that takes up around 7GB of space on my hard
drive and on top of that, one of the tables in the datatbase with about 25
plus columns has 4 million rows. The problem I am getting is whenever I
restart the SQL Server service or at bootup, my database shows an (In ... more >>
how to specify a remote SQL Server as a linked server ?
Posted by akiuni at 2/23/2006 10:12:02 PM
Hi,
I have a small problem and I suppose the solution to be very simple but
I don't find it and I'm blocked.
I have to build a query that will merge some information from a database
of a provider and our sql server. When I test the query, it returns me
an error saying that the remote ser... more >>
MSDE and MSSQLExpress
Posted by Xavier Boneu at 2/23/2006 8:30:09 AM
Hello.
I have had MSDE installed and running for some time and a few days ago I
installed Microsoft Visual Studio.Net 2005.
During the installation, MSSQLExpress was installed so I think that I have
two engines running.
While MSDE icon is visible in the Notification Area, MSSQLExpress... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Attachment Error received
Posted by John at 2/23/2006 5:06:10 AM
Hi all,
I've just started dabbling with SQL Express (I've an up-coming project and
would like to use it). I had no hassles connecting to the db I created in
VS2005 std but now I want to test connectin to it outside of the inetpub. I
copied the MDF and LDF to another folder on my drive and chan... more >>
Help with most efficient column sorting technique
Posted by MJB at 2/22/2006 4:12:32 PM
I have a SQL 2005 database with 4 million+ rows. One table in
particular has about 35 columns. I have implemented a paged data grid
results view for them. They want to be able to sort on the majority of
the columns. When they sort they want all the results sorted not just
the visible r... more >>
xp_cmdshell returns unexpected Return codes
Posted by Solly at 2/22/2006 3:50:51 AM
Hi All,
I am using xp_cmdshell bundled with SQL2K to copy a file from one
location to another on the same machine. This sometime works and
sometimes fails and return an error code as 128. The documented return
codes of this extended procedure is only 0(success) and 1(fail).
Has anyone faced t... more >>
Failover Clustering
Posted by Thomas Tsang at 2/22/2006 12:00:00 AM
Does anyone know if it is possible to apply Failover clustering service over
2 servers with MSDE?
... more >>
|