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 > march 2006 > threads for march 29 - 31, 2006

Filter by week: 1 2 3 4 5

Need help setting up RDA
Posted by Phillip N Rounds at 3/31/2006 4:02:20 PM
I'm trying to use RDA to exchange data between a CF 2.0 app and SQL Server 2005 ( Developer Edition ), and I guess I really don't know what I'm doing. SQL Server 2005 is up and running. I've installed SQL CE ( 3.0 ) on my development machine. I've configured IIS ( 5.1 ) for RDA as follows...more >>

Connecting To Remote MSDE With Server Management Studio
Posted by virgin69 NO[at]SPAM gmail.com at 3/31/2006 11:20:38 AM
Hello, I am having issues connecting to an MSDE instance on a remote machine using MSSQL 9's Server Management Studio. I am also have issues connecting to a remote instance of MSSQL v7 using Server Management Studio. Later, I will have to connect to MSSQL v8. If there is a step-by-step ...more >>

Can MS SQL Server 2005 Express Installed On Windows XP Embedded ?
Posted by Jeff Phang at 3/31/2006 12:00:00 AM
Hi, Appreciate if any friends here can do me a favour by telling me whether MS SQL Server 2005 Express can be installed on Windows XP Embedded ? I have run the SQL setup file and while the setup process was trying to start the SQL database service, the Setup screen prompted "The SQL server ...more >>

Why is it getting slow?
Posted by Paul Pedersen at 3/30/2006 11:41:00 PM
I have a small (12 MB) database. I don't think it's full, but in any case it's set to grow without limit as necessary. It is accessed only by MSDE on the same machine, and then only by one application, via ODBC. Everything was working until about a month ago, when it became very slow. Ev...more >>

How to use Windows Authentication for MSDE connections ?
Posted by Sagaert Johan at 3/30/2006 12:00:00 AM
Hi From the local PC windows authentication seems to work, but from remote pc's te client seems to logon as guest. Do i need to install MSDE on a windows server edition to get the windows authentication working ? SQL Authentication works from remote machines, but becorse the password is...more >>

weekday Problem (falscher Wochentag)
Posted by Raymond Geering at 3/30/2006 12:00:00 AM
Hallo, Beim Umschreiben einer Abfrage von Access XP auf SQL (bzw. MSDE) bin ich auf ein interessantes Problem gestossen. Gem. Access Hilfe ist die T-SQL Funktion für Weekday DATEPART(dw,x) Nur gibt mir in Access für heute (Donnerstag) weekday(now) -> 5 und SQL DATEPART(dw,GETDATE()) ...more >>

can't upgrade msde sp4
Posted by ak9408 at 3/29/2006 5:20:02 PM
i'm trying to upgrade to sp4 using the following command: <setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=username UPGRADEPWD=password /L*v C:\MSDELog.log> it starts, then stops, without giving me an error. Please help!!...more >>

Icon Tray SQL
Posted by Bob Day at 3/29/2006 1:02:49 PM
In the icon tray is the SQL icon with a green arrow that briefly shows a red dot to the lower right of the arrow. All programs that use SQL work fine. I am just wondering what the red dot means? It is like a heart beat to show it is acitive? Or does it indicate an issue? Bob Day ...more >>



MSDE Backup Size increases
Posted by ABB at 3/29/2006 8:39:02 AM
Our clients are using MSDE. Our VB application provides simple full backup feature usng DMO. We have noticed that their recent backup size goes to 2GB. to investigate, When backup taken from enterprise manager it is 60 MB. What could be the rerasons?. The clients are doing hundered of inserts...more >>


DevelopmentNow Blog