mmm. what are you using for your front end app. in asp .net u can make use of disconnected recordsets. as for the computations and data formatting, that should really...

you can try to use table hints in your select statement,i.e.

CREATE PROCEDURE [dbo].[GetWFSAInfo]

@WFSAID int

AS

SELECT WFSA.*, FirstName, LastName, EmailAddress, LoginName FROM WFSA, WFSAUsers WITH (NOLOCK)

WHERE WFSAID=@WFSAID AND WFSA.CreatorID =...

try http://www.quest.com/Toad-Data-Modeler/ but you will probably not get everything in your requirement set.

kavita,

I am failing to exactly understand your problem. Which part of the code above is the XML?

have you registered any servers in EM? was it working properly before

Jim,

What processing are you doing in your stored proc? if possible can u post the stored proc dml

 you will have to:

create a signed assembly in .net  environment

create an asymentic key on sql server for the .net assembly

grant EXTERNAL_ACCESS or UNSAFE permission set to the .net assembly

probably...

Ben,

The relevance of the Hier_level is it shows the position of the task in the path. i.e.

for PATH 1

1. Reporting - Cynthia Reece/4813 ===>>> 2. Interconnectivity...

you can try cute pdf, but its not free   http://www.cutepdf.com/ pdf sdk

from their sample code you will be doing something similar to

Dim objMyForm

Set...

> I need the data to be replicated to server B, after, the data be deleted on the server A.

I didn't think this was still replication, because the rows that are on B...

i will substitute your use of the word hierachy and use order by. to me your problem seems to be a network path problem akin to project management. you are...

you would need to get the pdf form API/component/ DLL

some developers usually create their forms using e.g. word and then print it to a pdf printer. the reason being the ease of use of the the apis that are...

why are you using a dts pkg to update a field in table. presumably it is much easier to do in in your stored proc.

... where SomeColumnName LIKE '%' + @ParameterName + '%'