hi, i have a simple question, mit look silly question for some one..
but please look into it n let me know how to write a query for it.. i
have 3 cols
col1 col2 col3

SQL Server VARCHAR(MAX) column Returns error while Inserting records into
table(ODBC Driver: SQL Native Client)
 Was this post helpful ?      
I created very simple table with 3 columns and one is varchar(max) datatype

Hi,
We are using SQL Server and Access for a database application. Database
access is via ODBC.
The application was functioning correctly since appr. 2 years - but suddenly

I cannot connect to SQL Server 2005 Express on a Windows XP SP2
machine from a Windows 2000 PC using the SQLNCLI OLEDB provider in
VB6.  I can create an ODBC System DSN and connect just fine, but I
cannot use a connection string with "Provider=SQLNCLI" or

Subj: ::FN_DBLOG() - Problem in retreiving [row data]
Hello
While attempting to retrieve [row data] column using ::FN_DBLOG
an empty '0x' value is passed back:

I have downloaded Club Website Starter Kit from MS. I don't have SQL Server
Express but I do have SQL Server 2005 Development.
I have changed the name of the DB server in the connection string, but
nothing else in the string.

how to load csv files into a table in sql server 2000

Have asp.net applic connecting to remote SQL Server. Is it possible to
specify to use SPs on different server? ( i.e. local rather than remote)

I had MSSQL 2000 and I would like to upgrade this server to MSSQL 2005 and I
were wordering how much more disk space requires for the upgrade process.
Is there any document that I need to read before upgrade process to upgrade
the server from MSSQL 2000 to 2005

I've recently started experiencing an error in one of our development
environments whereby the user is pressing "submit" and their query is
timing out.  Now, i've ran a trace (using the SQLProfilerTSQL_REPLAY
template in SQL Profiler) while they were performing this process, and

Background... Server raid failed, rebuilt raid ran chkdsk but now I am
unable to run SQL service.
I've tried to manually start service but receive the following message
The MSSQLSERVER service on the local computer started and then stopped. Some

SQL Server 2005 enterpise edition with 8g or memory in the compaq dl380
server with AWE enabled.  I think the server is using about 7g.
Connections are 0 - unlimited
I have a .net application that tries to create 300 connections async and

I have installed SQL Express with advanced services and all the toys
on 2 machines. A desktop and a laptop intending to use the desktop as
a "server". I followed instructions to enable the server installation
for remote connection by enabling TCP and the browser.

I have a SQL 2005 instance (standard edition with sp2 on windows 2003
server) located on different domain.
I can connect to it by using sa only via SQL server management studio. I
need to use SQL login.

Here's a program that creates a temp table,
inserts a row, selects the data out successfully
with a plain statement, but can't select the
data out via a PrepredStatement: