Strange!

I tested on SQL SERVER 7.0 SP2 and SQL SERVER 2000 SP1.The difference was that I got the exception every time I run the query in SQL SERVER 7.0 but...

SET NOCOUNT ON

DECLARE @Var varchar(20),

@Countint

SET @Var = ''

CREATE TABLE #Var ( ID INT IDENTITY(1,1),Var varchar(40) )

INSERT INTO #Var SELECT 101

INSERT INTO #Var SELECT 102

INSERT INTO #Var SELECT ...

I thought that if patt is 6 character long (it could be max from 0 to 10) you could update every character in the patt variables at the same time....

I'm not sure if I understand what you want to do but maybe this could help you :

CREATE TABLE #temp (nmon INT,patt VARCHAR(10))

INSERT #temp VALUES (123456,'000000')

INSERT #temp VALUES (156,'000000')

INSERT #temp...

I've got the same exception when I try to create a temp table.

You can't insert records into 3 tables at the same time and have data integrity.But in the same dts package you could insert first into 1 table and then into...

Hi Steve,

Thanks for your answer.

There is no space or anything else...

The connections file name is 60 not 30 as I wrote before.Here comes an exemple:

SELECT LEN('\\STR_SQLMAR01\FOC\OUT\ONLINE\WITHD_FOC_STS_focadm_marius_test1')

This is 63 long...

Belive me,I check that a couple of times and there is no problem.The weird thing is if I have less then 30 character in the excels connections filename,than it works...

I checked a bit closer and the problem is when I create the excel connection then I get the error message.Is there any limitation how long the excelfile name could...

Check this out :

http://www.sqldts.com

Hi Andy,

What is the name of your tuning book?

It may be usefull to have one at home.

Best regards,

Sica

Which is the best way to transfer 4 milions posts from one db to another?

BULK COPY or DTS ?

Thanks for you time.

Please excuse my ignorance but I'm not sure if I get it , so please correct me if I'm wrong.

I have truncate on checkpoint enabled ,but as you say this...

I increased the space allocated to msdb and the locks are gone now...

Thanks anyway.