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 > 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 >>



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 >>


DevelopmentNow Blog