Hi there--
I'm connecting to SQL Server Express from MS Access via ADO on a
number of older workstations.  Of three workstations, two connect just
fine with a connection string like this:

SQL Server 2005 SP2 (build 3054)
Consider the following scenario:
- A complex multi-statement table valued function is created. Let's call
it dbo.tfFunc(@Param1, @Param2)

Sorry about this. But I've worked primarily in access for years.
Does SQL Server have a boolean or  a yes/no data type for its table columns?
Thanks in advance,
Bill

I have a stored procedure with some input parameter and one output parameter.
I use SqlCommand and SqlParameter as following
///Set some imput parameters here
parameter = cmd.CreateParameter();

I need to do a report from data in a database that was provided by a
third party where there is no documentation at all. It contains more
than hundred tables and each table has different GUID fields.
In one table there is GUID as a primary key and another GUID as

Hello group.  I have created a csv file that contains alpha-numeric
data.  How can I export this file to include text qualifiers (" ") for
the all text data (i.e addresses, comments, notes, etc.)?
Thanks,

Hi.  I'm trying to copy from one table to another across 2 different
servers with the following:
select *
into #Tmp_Hdr

Hi Guru,
After we moved from old server (windows 2000, SQL 2000 and SP3a) to a
new server (windows 2003, SQL 2000 and SP4) that cutting down maximum
network packet size to a half, we run into a new issue below:

I am trying to update my optimization jobs so they will not optimize
the older partitions (for performance and snapshot space reasons).
ALTER INDEX {indname} ON {tabname} REORGANIZE PARTITION = ?
I can get the partition, but my question is, how do I determine if the

Is there a way in 2005 to tell what user is logged into what database
on the SQL Server?
thanks,
Scott

I have a program written in C/C++ compiled with MS Visual Studio 6.0 that
fails to connect to a french SQL Server instance (probably a 2005 instance)
with "SQL Server does not exist or access denied".
I can connect to the instance with SQL Server Management Studio with no

What is the correct syntax to do so.
I have the same fields in the table.
Tables called Books and Titles
Fields are TitleID and Titles

I have a query where I convert some numbers from float to char, but for
large number (Over 6 digits) it retuns the values with an exponent (ex.
1e+010)
According to the documentation, this is correct:

Using SQL Server 2000...
I wrote a wrapper to call a sub proc (code provided below).  The
intended varchar value returned in the output parameter of each proc
is a string implementation of an array.

I am getting the following error when I am trying to copy a text file to an
exsisting sql server 2000 table.
"Error during transformation 'directCopyxform' for row number 1234. Errors
encountered so far in this task: 1.