I wish to send dynamic SQL to Openquery but it seems OpenQUERY only accepts
string constants. Any advise on how to do this. It would convenient if
Openquery could execute similar to dynamic SQL EXEC.
Please advise.

We are calling a stored procedure that accepts a very long comma delimited
parm.  In the body of the stored proc, we loop through the parm using a user
defined function to pull out the tokens.  The function call uses 2 input
parms: the original long parm and the int position of ...

We have a mysterious problem connecting to a SQL database with ODBC.  Here's
a little background on our environment:
- We're connecting to a named instance of SQL 2000 on a Win 2003 Server
cluter.  The virtual server name and the instance name are the same (so the

We would like to include it in our install to help facilitate any
connectivity issues.

I have a simple problem, and on the paper I've solved it, but the
results are absolutely baffling and inconsistent, hence my cry for help.
My client has an SQLServer database (designed and fed by my software) at
a hoster, with, for the sake of this exercise, 2 related tables, lets ...

I am trying to get an ODBC connection created from a commandline, I
have   created the ODBC connection, exported the registry key, and have
tried doing regedit /s "regkey", problem is after I do that it never
shows us in the ODBC manager, it shows up in the registry under

I have a connection to SQL Server set up via SQLConnect() referencing a
System DSN. Is there a programatic way to obtain the SQL Server machine's
host name and port number from the established connection? The documentation
for SQLGetInfo and SQLGetConnectAttr doesn't seem to cover ...

I'm trying to run a view that calls a table in a linked server (linked to
Exchange on an SBS 03 box)
The linked server shows the correct tables in the Exchange public folders.
The query is;

I posted this question in the SBS newsgroup as well.
I have two internal client machines who connect to an external SQL server.
Both were working fine on our old NT 4.0 domain but now that we have updated
to SBS 2003 with ISA 2000, the two internal clients (XP SP2) are having

I am using Analysis Services and SQL 2000. On my Analysis Services machine I
define my data source to point to a remote SQL 2000 server using windows
authentication with my domain admin account. I can create the cube and
everything looks great but when I process the cube I get ...

am trying to update an access file table contents using osql and am getting
all sort of error
Can anyone help
This is the querry

I just installed a virtual sql server 2000 sp3a named instance on a MSCS
cluster.  I was trying to get the log files onto a separate LUN in my SAN.  I
changed the startup parameters in Enterprise manager to point to a new
location for the -l parameter (log) and removed the ...

Recently i installed SQL server 2000(EE)on my remote dedicated server( win
2003). I haven't installed ant Service packs. Now the problem is i am not
able to connect to the SQL server either thru Query Analyzer or thru the
application. I have disabled the firewall, still no use. Can ...

I'm running an application the is running on Weblogic 8.1.4 and uses MS SQL
Server 2000 as the db. I used the MS SQL JDBC driver SP3 and everything works
fine on a Windows 2000 box.
Now when I installed the same app on a Windows 2003 Enterprise Server, I get

Hello, I don't know much about SQL Server processes/SPIDs but everytime our
web app creates a ADO.NET connection and closes it, the SPID is still hanging
around in "sleeping status" well after it's closed in the ADO.NET code.
Is this normal or I am making database calls ...