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 > october 2005 > threads for october 29 - 31, 2005

Filter by week: 1 2 3 4 5

Attaching a Database
Posted by nbohana at 10/31/2005 7:14:03 PM
I need some help, I am new at MSDE. I know the command to use but I am not so sure how to use it. I tried to 'EXEC sp_attach_db @dbname = kennel' at the command prompt. Can someone point me in the right direction please. -- Norm Bohana...more >>


MSDE install problems...log attached
Posted by youngveh at 10/31/2005 2:20:10 PM
I am trying to install MSDE desktop engine and I having the most difficult time. I installed it once and then tried uninstalling it while it was still running. Half of it uninstalled the other half still being there. I then could not reinstall or uninstall cause a the DLL kept running. I boot...more >>

One Table or Many??
Posted by Islamegy® at 10/31/2005 1:09:36 PM
I'm working in a large database of 4 Million Records of laws in 20 Country.. I have created the law info (text, year... etc) in separate table foreach country And named my Tables "law"+country id.. but when i need to search in all countries i write code to rename the tables dynamic but i have a...more >>

MSDE
Posted by Marek at 10/31/2005 10:02:13 AM
Hi, I can't uninstall MSDE from W2K server. Add/remove doesn't work. It's any possibility to remove the engine? Thanks Marek ...more >>

need help to connect to remote msde db with SQL Web Data Administrator
Posted by comic_rage NO[at]SPAM yahoo.com at 10/31/2005 5:14:47 AM
HI, I installed the SQL Data Administrator on my client machine, but I'm having problems connecting to the MSDE database on another machine. At the MSDE machine, I can us the local SQL Data Administrator to connect with the following info login name: sa password: pwd sa server: (local)\MY...more >>

MSDE Database size limit (SQL 2005)
Posted by Dan at 10/31/2005 5:10:05 AM
Hi We have recently been looking to use MSDE for remote users, but are concerned about the limit of 2GB for a database. With the launch of SQL 2005 just days away, I was wondering if there is an SQL 2005 MSDE equivalent? and if so, what is the database size limit? Any information on this...more >>

MSDE 2GB Limit
Posted by yitzak at 10/31/2005 4:14:49 AM
Hi A Client has an MSDE install - checked by running @@version (clearly says developer edition in the result text). However the size of the data file is over 3GB, even allowing for empty spaces the amount of data far exceeds 2GB. Pls explain? The database was filled by regular insert stat...more >>

language option
Posted by danielepasian NO[at]SPAM nospam.com at 10/31/2005 12:00:00 AM
Hi i need to install a Msde on italian server. i set rigth the collation - caracter set and sort order but i found that language for the sqlserver is set "italian" how can i change it to english? I look on setup.ini settings without success..... i found another db that has set englis la...more >>



Retrieving Indexes and SQL Relationships programatically
Posted by Mark Hollander at 10/31/2005 12:00:00 AM
Hi All, I have been able to retrieve the tables within a database automatically via an sql query. Is there a way that I can retrieve the indexes (with the field names they are indexing) and relationships (Fields plus tables they are referencing). What I am trying to achieve is this. In ...more >>

redistribute MSDE2K SP3
Posted by Is MSDE2000 free redistributable at 10/30/2005 10:26:02 PM
I developed an application for my customer. I need the MSDE2000 to run the application. Can I install the MSDE2000 for my customer? Should I pay any runtime license fee? Or is it free redistributable?...more >>

SQLEXPRESS: Login failed for user 'sa'. Reason: The account is disabled.
Posted by Oleg Ogurok at 10/30/2005 8:58:17 PM
Hi all, I've installed Visual Studio 2005 professional with SQL Express Edition. A third party app needs to use it. When installing, it's asking to login as 'sa' user. I've enabled MIXED MODE in Registry and reset the 'sa' password with 'sp_password'. However, if I enter the correct pas...more >>

NewBie, how to trap: SQLAllocHandle Error
Posted by Rob Dob at 10/30/2005 5:06:08 PM
I have a MFC VC7.1++ program using VS2003, and also using the MSDE2000 for some reason my import is now failing and I cannot figure out why, before today this first statement use to successfully process. The return value of retcode now is 0, it use to be retcode = 1 I have looked up the d...more >>


DevelopmentNow Blog