Are you saying that, the data is truncated when you issue a select statement on the text column in Query Analyzer.

This will be the case because, the query analyzer by...

I tried the following option and it seems to work.

1. Defined the text file content (test.txt)

0123456789ABCDE0

total length 16 bytes.

2. Created a odbc dsn pointing to the...

One alternative is as follows

Update mytable

set Col2 = CASE

WHEN @2 IS NULL THEN Col2

...

This is because when QA executes the stored procedure, it sets the ANSI NULLS ON explicitly (see current connection options).

asp.net SqlConnection class does not do this. So when the stored...

The easiest way to verify this is do a select on this table. if rows exists then you are safe. The Query is rolled back.

Sql server works on implicit transaction...

You can do this in two ways

1. SELECT count(autUID)

From tableName(nolock)

or

2. Set transaction isolation level read uncommited

SELECT count(autUID)

...

I had a similar problem in one of the project and found the solution as follows.

Thought it might be of help to you.

This project was similar to yours where it...

Any mathematical operation running in infinite loop might consume CPU 100%.

For example if you are familiar with VB then you can try following code

dim lngIndex as Long

Do while true

...

Do you mean using ASP code?.

Use ADO to connect to database. Use ado connection object to connect to sql server using OLEDB connection string.

Provide the server and database details in...

You can use the sql similar to the following to get all the values in table 4 using key of table1

SELECT t4.*

FROM table4 AS t4

JOIN table3...

<<So if i have 200 tables I need to run this 200 time?>>

Yes. This works one table at a time.

If you have 200 tables then you need to have 200...

Good idea.

Thanks for the same.

Sorry I forgot to mention.

No it will not work for generic tables.

You need to replace <SERVER> <DBNAME> <USER> <PASSWORD> and <TABLENAME> with the values specific to your environment.

When you create a recordset(eg., ado) with server side cursor option and cursor type other than static, you will get sp_cursorfetch in trace.

The sp_cursorfetch is called for each...

Dim usrServer As SQLDMO.SQLServer

Dim usrBcp As SQLDMO.BulkCopy

Dim lngRowsImported As Long

Set usrServer = New SQLDMO.SQLServer

usrServer.Connect "<SERVER>", "<USER>", "<PASSWORD>"

Set usrBcp =...