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

SQL2005 Compact Edition
Posted by SkyDave at 12/27/2006 2:26:01 AM
I've been reading up on SQL 2005 Compact Edition. I take it this is the death of Microsoft Access? Comments? -- Dave...more >>

any good books for sql server 2005 express edition?
Posted by freeman at 12/22/2006 12:00:00 AM
I am a new user to sql server 2005 express edition. Any great books / ebooks for this version (for a beginner)? thank you for your kind help! ...more >>

MDF size way too large
Posted by Lucvdv at 12/22/2006 12:00:00 AM
I've got a SQL Express database with, right after running DBCC SHRINKDATABASE, an MDF file size of 1.59 GB. The log file size is neglectable, less than 1 MB. The database properties say size 1632.50 MB, 159.07 MB available. When I look at the properties of all tables individually and add th...more >>

setup failed to configure the server
Posted by fnaqvi NO[at]SPAM gmail.com at 12/20/2006 3:46:12 AM
Hi All I have got problem in installing MS SQL Server 2000 Enterprise Edition on Windows Server 2003 ... after completion of 99% of setup this error was occured ... I don't know how to deal with thta .... I am new with SQL server ... error log is given below ..... Please do help me ... Chee...more >>

SQL Server Express 2005 and remote connections ?
Posted by Peter Stojkovic at 12/13/2006 12:00:00 AM
I have installed SQL Server Express 2005 I have read, that by default the express edition is set to local connection only. Is it possible to switch to local AND remote for the express edition 2005 ? ...more >>

Uploading data from Excel to SQL Server
Posted by Doctorjones_md at 12/8/2006 11:53:19 AM
I assume that I'll need to write a cursor to accomplish this -- how would I write a cursor to upload data from Excel to SQL Server (1 row at a time)? I have the following code which does the following: 1. Deletes all rows having a value of "0" in column C 2. Uploads the data in Row 2 to m...more >>

Converting Access to msde Design issues
Posted by Steve Long at 12/7/2006 3:53:06 PM
Hello, I'm converting an application from MS Access to MSDE (most likely as compared to SQL S Express) and I have a few design questions. Background: I'm dealing with a disconnected scenerio in which inspectors go out into the field, generate reports and then come back into the office. Back a...more >>

MSDE or SQLServer Express
Posted by GRK at 12/7/2006 2:16:00 AM
Hi In our vb.net application we are using sqlserver2000 database. we are planning to move to another free database engines.I have few queries. 1.in MSDE or SQLServer Express which one i have to select 2.Where can i get the documentation of how to dump my database in those because those d...more >>



upgrade not working??
Posted by rodchar at 12/6/2006 6:18:00 PM
hey all, i'm trying to updgrade my msde but i don't think it's working. i'm at the following version: Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Cop yright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT ...more >>

login failed because it is not associated with a trusted connection
Posted by ndmadden NO[at]SPAM gmail.com at 12/4/2006 12:22:57 PM
I am trying to setup a user to access the BEDB database that gets created on a veritas backup exec 10.0 box so that I can pull data from the db. From what I can gather it uses a MSDE to run the db, its creates its own instance when the veritas software is installed and I have tried: http://su...more >>


DevelopmentNow Blog