Howdy!
I'm writing a little script that should run at bootime.
The script should connect to SQL Express and retrieve some values
from a view.

I am using dot net 1.1 framework to connect to one of my data base.
the connection string looks like following
"Data Source=.\SQLEXPRESS;AttachDbFilename=c:\DB1.mdf;Integrated
security=true;User Instance=True"

Is there anyone out there that has been able to successfully have SQL Server
2000 talk to Paradox databases, by using an ODBC Driver between SQL Server
2000 and the Borland Database Engine v 5.
We have been working with the Microsoft Paradox driver, with very poor

I have SQL/Server Express set up on two machines.  I turned on all the
protocols for each.  I started the server browser task on each. I opened
ports 1433 and 1434 on both firewalls.  I can sometimes find the servers when
I browse.  I just can't logon from either. I've tried ...

I am having a very frustrating problem trying to connect to a remote SQL
Server 2005 at my ISP. When I try to connect through Management Studio the
ISP SQL Server returns an error of 'Login failed for user xxx (18456)'.
According to the ISP they can see my connection attempt in ...

All,
I have looked and not found anything on this. Is it possible to setup a DSN
through the commandline, or a startup script?
Thanks,

I'm using SQL 2000 & MSDE 2000
I'm having a problem connecting to a local database running on MSDE but
only when the computer isn't connected to the network.  I've tried using
both TCP and named pipes, both work while connected.  This was not an issue

Create table myTable
( Name varchar,
  Description Text )
The description column contains more than 300 characters. The sql limit is

I've switched to using the new 1.2 CTP driver when I run locally.  When
starting Tomcat, I"m getting
    10:55:17,859 INFO JDBC Driver:
com.microsoft.sqlserver.jdbc.SQLServerDriver, major version: 1, minor

We have a Third party application that uses JDBC to connect to a database hosted on a SQL 2000 database server. No problem when we connect to a standalone database server. However, recently we copied our Production database to a Pilot db server which happens to be on a clustered ...

(CrossPost: microsoft.public.opsmgr.sql, microsoft.public.sqlserver.connect, microsoft.public.sqlserver.server)
I installed SQL Server 2005, then i reboot the server (w2k3 r2 std ed), then i saw the following event:
Actually i reformated my sql server because of this event, and now ...

My available memory is down to very little, yet my PF Usage is 8 gigabytes
(about how much memory is on the box), sql server keeps having memory issues
yet the sqlservr.exe is using hardly any memory.. how to fix this? is there
some way to limit how much memory can be used by ...

in sql server is it possible to get the amount of memory used by a stored
procedure? e.g. memory usage statistics per stored procedure?

My Application sends huge huge data to the SQL Server, when initially it
sends the data, it inserts all the records into the tables, when the data
comes next for the same records it needs to be updated.
In Sql Server autogrow is enables.

I am trying to create a linked server between 2 SQL Servers. The server that
I'm trying to connect to has 2 instances of SQL Server on it. One is SQL 2000
STD and is the default instance. The other is SQL 2005 Wrkgrp and has the
instance name 'sql05'. I need to be able to connect ...