Have you tried running the statements individually? Are there any errors?

Thanks...Chris

I have determined that it is either a problem with the XML string being returned from the query (it is too long) or the query to generate the XML string...

I've already tried using a script component, which hasn't worked.

No data is outputted to the text file, which is the problem. I will post some of the data later...

Having a central database that all of the companies access would solve this issue, wouldn't it? Might be the right way to go.

Thanks...Chris

Well that just seems like a waste...having to write cascading deletes/updates yourself, considering that it is already built in.

Look into the substring function.

I hope that this helps.

Thanks...Chris

Sorry for the delay in my response...power went off here yesterday.

It seems that I've managed to resolve this issue, by the way.

I was mistaken;the query that I thought was causing...

Thanks for the reply. Here's the information, as requested:

Table definition:

CREATE TABLE [dbo].[SEOCandidateMatch](

[ID] [uniqueidentifier] NOT NULL,

[CandidateID] [uniqueidentifier] NOT NULL,

[JobID] [uniqueidentifier] NOT NULL,

[MatchPercentage] [int] NOT NULL,

[RowStamp] [bigint] NULL CONSTRAINT [DF_SEOCandidateMatch_RowStamp] ...

Please post your stored procedure (and table layout/ddl), as it may be re-compiling on every execution thus causing the change in execution times. Thanks.

Hi, John. Please post the structure of the table that you are querying, some sample data and the query that you've used so far. Thanks.

Pradeep, if the users are a part of the same group, wouldn't it make better sense to go the route that the user is already taking...setting up the Active Directory...

I've seen it done.

For help with your service broker implementation, search for Remus and service broker. He was able to help me a few weeks ago with my implementation.

Yes, there is more than 1 ID per person. I only wanted the most recent ID. Gail's post helped me do that. Thanks.

Chris

It does...thank you VERY much!

Chris

How often are you doing SAN snapshots (both full database and transaction log snapshots, right?) and how often are you backing up to tape, after the SAN snapshots occur? ...