Thank you very much.

It works completely.

Here are my scripts:

EXEC sp_dropextendedproperty

@name = 'MS_Description'

,@level0type = 'schema'

,@level0name...

Thank you very much for your replies.

I still curious about this issue, why does the Microsoft does not used the feature that have been create?

Do you think that the microsoft...

Hi CirquedeSQLeil,

I have a problem with the license of PGNP. Do you know another tools that can be used to create linked server to postgrey?

I use MS SQL Server Express...

Thanks for the url. It so usefull for me.

I have to read it first. I hope this work on 32 bit.

Best Regards,

Eko Indriyawan

I'm sorry, I never use perl before.

Now, I only use the Delphi for programming.

I hope yourself or another people can solve your issue.

Regards,

Eko Indriyawan

Maybe, by using the schedule you can do it periodically.

But, If you use the MS SQL Server Express Edition, I recommend

you to create a service application to do that.

So, from...

Btw, have you tried to use Linked Server to consolidate them?

Since your instance is part of the MS SQL Server Database Engine,

I think you can use link server to solve...

If you want to know why about this issue, let you read the documentation first in this link:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/c626d75f-ff62-41bb-9519-10db3b50bee5.htm

Need to know that MS SQL Server Database Engine using this mechanism to...

Hi kwiggans,

Correct me if I'm wrong about multi-instance.

Btw, have you tried to use multi-instance and manage it?

Just for your information, based on my experience for

using multi-instance to manage big records,...

@shreyansh.bele

Can you show me your current connection string?

Don't forget to change your ip/server first...

Regards,

Eko Indriyawan

I think if you are using additional tables for storing information about reports that you needed is good way for facing much record.

If you are using MS SQL Server Express,...

shreyansh.bele (5/9/2010)

---

HI. I have a problem establishing connection in a java program with db through LAN. the sql server 2000 hangs up and responds to query in strange way after...

Let you try to read this article.

http://www.databasejournal.com/features/mssql/article.php/2205291/Generate-Scripts-for-SQL-Server-Objects.htm

I hope can help your issue.

Regards,

Eko Indriyawan

Hi David,

I did not lie, that this is a solution and I've applied to all stored procedures and all working properly.

Let you read this article http://support.microsoft.com/kb/272358

The Microsoft OLE DB Provider...

Hi David,

Finally I found the solution by create temporary table.

My first query in stored procedure:

...

SELECTA1.INVOICE_INCAS A,

A1.TRANSACTION_IDAS B,

A2.ITEM_IDAS C,

A2.ITEM_NAMEAS D,

A1.UNIT_IDAS E,

A1.UNIT_NAMEAS F,

A1.ITEM_QUANTITYAS...