Your data does not make sense. The second table does not indicate a client.

And then a tip on posting...

What would help is if you post with some sample data...

The first direction I would go is to use a temp table rather than using an actual table. This would prevent your processes from running into each other.

If the file is alone in the directory, you could use a ForEach loop and loop through the files (of which there will be one).

I am not sure why you...

Reorganizing your clustered index (and other indexes) will "shrink" the table to it's optimal size, but it will not give anything back to the operating system. It just leaves...

Your domain is being renamed, or your server is moving to another domain?

If your domain is being renamed (not that I would recommend renaming a domain), the SID's should still...

That will only work if you cannot insert more than one row at a time. Triggers in SQL are set-based - your INSERTED table may have one row with...

Transactional replication updates one record at a time on all subscribers by default.

You have some ability to manage this, but it can be tricky to manage replication once you have...

Didn't you post the same question yesterday?

You said it works from your dev box - which I will assume is the server your service is on.

My first guess would be an Excel issue. Log into...

I would expect this to work:

(DT_CY)(TRIM(REPLACE(Copay, "$", "")))

I think this is what you are trying to do:

[font="Courier New"]SELECT

*

FROM

Inserted I

LEFT JOIN dbo.User U ON I.CreatorID = U.ID AND U.Inactive = 0

WHERE

I.CreatorID IS NOT NULL

AND U.ID IS NULL[/font]

I would...

I am not a big fan of linked servers or cross-server stored procedures because they tend to promote bad practices and end up with poor performance. They can be...

SET PARSEONLY ON

The client tools are the same.

You are saying that you have users without an NT Login and you want them to have access to your report server.

Then you indicate you want to pass some kind...