I presume this is what you require, execute this script in northwind database and get back to me if your problem is something other than this.

CREATE Procedure ProductFilter

(

@FilterFields varchar(1000)

)

As

...

Yep, That also sounds great only. Will modify accordingly.

Thanks for the suggestion.

Thanks,

Ganesh

I found in the net the only document of your need

http://www.only4gurus.com/techlib/greatplains/solomoniv/40mc2wp.pdf

I will let you know if I find something else.

Thanks,

ganesh

Pls follow the links

http://support.microsoft.com/default.aspx?scid=kb;EN-US;283899

http://support.microsoft.com/default.aspx?scid=kb;en-us;330307

Pls give the full details of the error you are getting and that will make others to respond quickly.

Thanks,

Ganesh

Hi Robert,

sorry for replying very late. Those are all string constants.

You can modify for your needs. Now I gave an example as the global variables you have added are GlobalVariable1,GlobalVariable2,GlobalVariable3....

So you mean the connection is an user dsn.

Have you tested the Test Data source, is that connecting ?

thanks,

Ganesh

Can Java bind to and use COM objects? If so then you can load, execute, change or even build DTS packages from Java.

In VB.NET or C# I would add a...

Sorry for posting this again. Let me take the example of Northwind database.

Stored procedure:CustOrdersOrders

Table

No need to feel stupidity for this.

Follow the link

http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

Download the executable and execute it.

thanks,

Ganesh

Code not visible.

The problem might be with the way you give the connection string. I would suggest you to build a connection string this way. Make sure all the files...

Tommy,

When the following code work, it is obvious your query should also work. I think the Adguid doesn't match with ObjectGuid.

Pls try this following code:

create table mytable (empname varbinary(100)...

I found few discrepancy from your code

1.You are using . in the place of Server name. Pls try to take the server name from app.config or hard code it.

2.You are...

You can't achieve this. When sql server encounters a error (Fatal or non-Fatal Error) - the program terminates accordingly.

Pls follow the link, on how the error handling should be done...

Hi Roger,

1. When you drop the index name, SQL Server would throw an error saying there are dependencies for this index, provided if you have explicitly named the index in...

sorry for posting again.

I found this tool would be the one you are looking for

http://www.sqlsentry.net/

Thanks,

Ganesh