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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
|