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 > august 2006 > threads for august 15 - 21, 2006

Filter by week: 1 2 3 4 5

Determine if database is SQL or MSDE, from Enterprise Manager.
Posted by nicough NO[at]SPAM gmail.com at 8/20/2006 5:52:42 PM
>From SQL Server Enterprise Manager, how can I determine if the database is SQL or MSDE? I suspect one of our databases is MSDE but I need to know for sure. Thanks Nick ...more >>

Move SQL from Drive to Drive
Posted by Qnguyen at 8/17/2006 3:47:01 PM
Hi, Do you know how to move SQL and its database from one drive to another drive (C to D for example). My C drive is almost full but D drive still has a lot of space. I would like to move my SQL and its database to D. Thanks for any help ...more >>

Help with importing dts package.
Posted by CharlesC at 8/16/2006 9:21:52 AM
Hello, I used SQL Server Enterprise Managers' Export Wizard with source Dbase III files and destination ODBC driver for SQL to create a dts package in the structured file format. I entered the following dtsrun line (msde 2000 sp3) and received the errors shown. dtsrun /S servSQL /U s...more >>

Using SQLDMO with Inno Setup
Posted by Bill Hicks at 8/16/2006 12:00:00 AM
Just wondering if anyone here has had experience with sql database setup operations in an Inno setup file using SQLDMO. ...more >>

Can a dts package be imported into Sql Server 2005 Express?
Posted by CharlesC at 8/15/2006 4:20:39 PM
Can a dts package be imported into Sql Server 2005 Express? Thanks. ...more >>

Can't connect to MCDE2000 server after host name change
Posted by Microsoft news at 8/15/2006 1:52:22 PM
This MSDE 2000 SQL server comes with ISA server and we renamed host server (windows 2003). From CMD prompt (osql) I dropped old sql server name and added new name. Now I can't connect anymore using SQL server service manager. Any help will be greatly appreciate Thanks ...more >>

Collation issue with MSDE?
Posted by Jon Pope at 8/15/2006 10:23:37 AM
My international (non-American) users are receiving the following error when my application tries to access its MSDE-based database: Error: Column <blah> is not of same collation as referencing column <blah1> in foreign key <FK_blah> Could not create constraint. See previous errors. I...more >>

Problems installing SP4 to MSDE Release A
Posted by NO[at]SPAM at 8/15/2006 8:41:02 AM
I'm having problems installing the above. The server already has an instanseof SQL 2000 installed and this is a named instanace. Errors are basically that the installation package doesn't think that there is avalin instance of MSDE installed. command line parameters being used: - setup /...more >>




DevelopmentNow Blog