Thanks Erik!

I create a stored procedure which launch the package (package which contain the osql command).

In this mode the command window is hide.

Thanks! and good evening (opss.....good morning?

thanks Lowell!!

but, this morning I have found the solution of my problem.

My executable file .exe use the method  LoadFromSQLServer()  to load DTS from remote server

In the PC Client (platform XP),...

AJ Ahrens,

Thank you very mutch!

Bay bay,

  Flavio

Thank you very much,  Frank !

I have installed SP3a on my SQL Server, and now, it seems that function!!

Thanks

Flavio

Yes, Herb

Before to change the name of the column, I cheked (and modified) all the stored procedures referencing this column

Thank you veru much!

Bye bye

Flavio

Frank, thank you very much!

Bye bye

Flavio

Hi Frank, thanks,

but, I'm sorry, I don't understand !

What is the table mails_header ?

and the filed MsgID = '0000000005247....'  why this value ?

Sorry

Flavio

Hi Frank,

Into Query Analyzer,  I create this code (for example)

DECLARE @ptrval varbinary(16)

SELECT @ptrval = TEXTPTR(Field)

FROM Table_Name

WHERE Id_Identificator = 3

READTEXT Table_Name.Field @ptrval 1 25

This code, it's...

Fantastic Jonathan!

Your statement it's OK!

Thank you very much.

I have learned a new thing of T-SQL

Bye bye

Flavio

PS

Thanks DavidT !

Thanks DavidT

But, my principal problem is that the value of the variable @TableName must be of the type:

SET @TableName = '<name_database>.<dbo>.<name_table>'

I have used the system stored procedure sp_pkeys, but, for...

Yes, MS DTC is running !

I execute the statement with Query Analyzer.

In the Query Analyzer, I'm connect with my local machine.

I execute the query on my local SQL Server!

I don't...

Thanks Mimorr (Michelle)

I executed your code by Query Analyzer

and then, I tried to execute one SELECT statement like example.

The problem is resolved!!

Now, I think I'll execute my stored procedure,...

OK Frank, but

Do you know, because

SELECT * FROM [dbname].dbo.table_name_2

work

instead

SELECT * FROM [serverName].[dbname].dbo.table_name_2

not work ??

Bye

Bye bye

Flavio

Ops!!

Frank, not Cheers!!!

Excuse me, pardon!

Hello Cheers and thanks for your attention

Now

If I execute by Query Analyzer the statement:

SELECT * FROM [dbname].dbo.table_name_2

work, It's OK!

instead

SELECT * FROM [serverName].[dbname].dbo.table_name_2

not work!

Bye bye

Flavio