One option would be to use Bulkcopy object of Sql DMO. If you need code sample let me know.

This seems to me like a problem related to service pack

Try the following link

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B235401

One alternative is as follows

1. Create a temporary table #tmp_emp(emp_id),

Store the field values (25 fields) in this table in the calling routine.

2. Join this table with employee table to...

You can use the kill statement to kill the spid. The spids that are on a database can be obtained from sysprocesses table. You can loop through them and kill...

Just a thought.

You can use Sp_Oa ... methods for COM object access.

So you can create MSXML.XMLHTTP object using sp_oaCreate and call the Open method with web serice url.

The result will...

Yes. You are right. Using BulkCopy object and using Import wizard behaves differently in this perspective.

This is due to the following reason.

When you are using Import wizard if you click...

Try the following

DECLARE @p1 INT

DECLARE @p2 INT

DECLARE @m_start_month INT

SET @p1 = '200103'

SET @p2 = '200303'

SET @m_start_month = CAST(RIGHT(@p1,2) AS INT) -1

select CONVERT(CHAR(4),DATEADD(MM,- @m_start_month,period),112), sum(composite)

from cdh_price_gap

where CONVERT(CHAR(6),period,112) between @p1 and...

Assuming you are using ADO for connection and MDAC is installed on the clients.

Are you using OLEDB connection string?

If so try adding "Integrated Security=SSPI"

If it still comes up, there is...

There is one difference between running commands directly using command window and running xp_cmdshell.

When you are running xp_cmdshell Sql*Server executes the command under the context of SQLAgentCmdExec.

One way to trace...

The Stored procedure seems Ok to me.

This could be an issue within mail server (not able to distinguish between the mails that have been sent within short very duration of...

I could not find any option to truncate data automatically.

Instead one option possible with bulk copy.

You can avoid generating runtime error in VB6.

You can set the MaximumErrorsBeforeAbort property of...

Does the following option help ?

1. Create a temporary table with only the primary key fields say #tmp_keys

2. Do a Insert into select query to run the...

Sorry, I do not have sql*server 2000 and hence cannot comment on CHECKSUM as it is availabe only in Sql*2000.

Be aware that if you are using checksum then you cannot...

Yes. Varchar field has limitation of 8000 characters.

But I didn't understand the requirement to concatenate millions of field values in one variable.

Can you please elaborate as to what you are...

Yes. This is true. As per definition of IF UPDATE (column) in books online, says that UPDATE(column) checks whether an INSERT or UPDATE action has happend (and not whether the...