Installation
Tue, 14 Feb 2006 14:44:41 -0500
Hi,
I'm using the most current version of MSDE, I've ran all my updates on a
2000 Pro machine.
Someone else did the install and I'm receiving an error message that SQL is
not installed properly
or has been tampered with, pleas uninstall and reinstall, so I went to the
add/remove and uninstalled
MSDE and ...
|
BCP won't import into simple data table...
14 Feb 2006 10:34:34 -0800
Hi all...
alright I'm at a loss here...
I'm using BCP to import data into a table in my database....
I keep getting an error of " unexpected Eof' or somthing like that, so
I figure my problem is with the text file i'm importing from.
To see if I was barking up the right tree, I created a new database
a ...
|
BCP Error
13 Feb 2006 13:42:45 -0800
Hi,
I'm getting the following error when I use BCP to import a tab
seperated file exported from Excel.
I hope someone can help me figure it out.
I'm using the following command:
c:\>bcp myComm.dbo.cmrc_products in test2.txt -n -T -Sbiff\sqlexpress
SQLState = 22001, NativeError = 0
Error = [M ...
|
Upon reboot, MSDE SQL TCPIP connection denied
Mon, 13 Feb 2006 12:41:40 -0800
I have a client PC running a C# program that obtains data from an MSDE SQL
database. The computer hosting the database is on a local network and is
accessed by TCPIP protocal using the following connection string:
"Data Source=192.168.20.124,1433;Network Library=DBMSSOCN;Initial
Catalog=CenterDB;User ...
|
cannot connect to server - uh?
Mon, 13 Feb 2006 20:11:15 GMT
Hi all
Firstly - to say I'm a newbie with MSDE/SQL Server/.NET would be
undersatating it. I'm fairly au fait with Access but I'm attempting to
broaden my skills.
Usinge MSDE (downloaded form MS) and VB.NET 2003, on a single pc with Win
XP, I'm trying to connect to a database - pubs.
I do this:
I ...
|
Cannot use backup file %s. Originally formatted sector size 512 and now device sector size 2048
Mon, 13 Feb 2006 13:36:53 -0500
Customer is trying to restore a backup of their database. SQL Server gives
the error:
Cannot use backup file %s.
Originally formatted sector size 512 and now device sector size 2048.
Only one guy (in Germany in March 2000) has ever seen this error. And he
never got a resolution.
...
|
www.verbatim.wordpress.com
Mon, 13 Feb 2006 16:44:39 +0100
...
|
|
|
Timeouts with Express Edition on Web Project
Mon, 13 Feb 2006 00:37:27 -0800
Hi,
i am using Express Edition in a medium scale web project. As the perfomance
throttle has been removed compared to the Desktop Edition I thought this was
a possible solution as the other limitations (CPU and DB-size) are good
enough for me.
The problem is that I am getting connection timeouts quite o ...
|
Create a sql stement from existing tables
Sun, 12 Feb 2006 18:01:37 +1100
Is there any way to automatically create a "CREATE TABLE" statment using an
existing table?
I would simply want to execute this statement and it would create, in
another database, a table with the same structure (no data).
Is there a way to do this?
cheers
nathan
...
|
WSUS MSDE2000
Fri, 10 Feb 2006 16:06:50 -0700
I am trying to login to the WSUS instance running on MSDE. I keep getting
the access denied message when trying to connect using osql. I have tried
osql -E -d WSUS and osql -d WSUS -U username but I dont know if I am just
putting in the wrong syntax here or if WSUS has something special about it.
Your inp ...
|
