|
Please Help!
I run W2000Pro.
Installed a new instance of MSDE into c:\one.
MSDE created the following:
\MSSQL$ONE
\Binn
\Data
\Install
\Log
I cannot find any servers in the service manager.
Can someone tell me how to register a server and then be able to connect to
it.
I am j ...
Mon, 18 Oct 2004 10:29:02 -0700
|
Issuses installing MSDE 2000 SP3a on Windows XP SP2
Dear All,
PROBLEM
========
MSDE 200 SP3installs but the default server instance is registered in SQL
Server Service Manager on Task Bar
I have VERIFIED that the services MSSQL$VSDOTNET and SQLAgent$VSDOTNET have
started.
I have also tried typing in the instance namely ClientName\VSDOTNET in
Server drop ...
Mon, 18 Oct 2004 17:50:04 +0100
|
Unable To Launch Enterprise Manager
All,
Here is the scenario...I have SQL Server MSDE installed on a Windows 2000
machine. I uninstalled SQL Server MSDE and reinstalled it. I am unable to
launch Enterprise Manager after reinstalling. I receive the following error:
"Microsoft Visual C ++ Runtime Library
Runtime Error!
Program: c:\winnt ...
Mon, 18 Oct 2004 09:19:04 -0700
|
bcp
How implements bcp.exe in visual basic.net project.
...
Mon, 18 Oct 2004 11:45:54 +0200
|
ANN: Database Workbench 2.5.5 released
Ladies, gentlemen,
Upscene Productions is happy to announce the next
version of the popular database development tool:
Database Workbench 2.5.5 has been released today!
Based on user feedback, there are numerous bugfixes
and some small improvements.
Download a trial at: http://www.upscene.com
Features an ...
Mon, 18 Oct 2004 10:34:04 +0200
|
OLE DB Provider for Microsoft Directory Services from MSDE 2000
FYI
Get AD OpenQuery working from MSDE 2000 (sp3a, Windows 2003 Server)
I could not find any single source of information for the above on the
Internet, so here is what I discovered.
1. Try adding the following to your server registry if you want to query AD
using ADsDSOObject from MDSE 2000 (sp3a):
...
Sun, 17 Oct 2004 16:40:20 +0100
|
Missing Tools after Setup
In the MSDE BOOKs there is a list of utilities and there directorys that i
should have:
x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
-bcp2
-console
-isql2
-sqlagent
-sqldiag
-sqlmaint
-sqlservr
-vswitch
x:\Program Files\Microsoft SQL Server\80\Tools\Binn
-bcp2
-dtsrun
-dtswiz
-isql2
-isq ...
Sun, 17 Oct 2004 02:35:08 -0700
|
Transaction Log Shrink
I have a Transaction Log file thats growing over 1GB, that i don't even use
for anything. But its there 'just incase' I don't even take backups for it.
I wanna keep that file around <200MB at all times. What would be the best
practice for this. Can a script be run for this and can it be automated??
Is this he ...
Sat, 16 Oct 2004 13:05:04 -0500
|
How can I tell if any connections exist on a given SQL database?
If I log on to the master database in an SQL server, is there a way for me
to tell if a non-master database has any connections to it?
VB6
ADO
MSDE (SP3)
William Hildebrand
wahilde@cableone.net
...
Sat, 16 Oct 2004 08:54:12 -0600
|
SQL SERVER
What is the main purpose for having an SQL Server? ...
Fri, 15 Oct 2004 11:49:13 -0700
|
MSDE
Use OSQL from the Command prompt.
>osql -U -Pselect * from Order_Table
2> Go
>-----Original Message-----
>how to execute queries like ...
Fri, 15 Oct 2004 11:35:52 -0700
|
MSDE2000
Ok, good.
But, how export MSDE2000 database "table" in delimeted text file. Any idea,
sample, link etc.
...
Fri, 15 Oct 2004 13:36:24 +0200
|
seek method in ado
hello to everyone
i would like to use msde instead of jet in my application. i use ADO, but it
seems that i cannot use the "seek" method on recordset to find some records.
any idea please ?
thanks in advance
philippe
...
Fri, 15 Oct 2004 11:34:09 +0200
|
DTS in MSDE2000
How export MSDE2000 database table in text file?
...
Fri, 15 Oct 2004 08:04:29 +0200
|
update query - how do I upsize from mdb to adp?
I have an mdb application in which new orders are based on previous orders
placed.
I have a current order table in which the order quantities for each product
are updated to reflect the selected previous order using an update query. The
new order ID is updated similarly using the order form's orderID contr ...
Thu, 14 Oct 2004 21:55:04 -0700
|