Robert

Or create a view of the two joined tables and update that?

John

Reet

What I'd say about indexed views is that just because you can create one, it doesn't necessarily mean you should.  In my opinion, it's more important to have proper indexing...

Jules

Unfortunately that won't work.  From Books Online (Creating an Indexed View):

The SELECT statement in the view cannot contain these Transact-SQL syntax elements:

.

.

.

• Outer or self joins.

This is...

Reet

Just a few ideas:

What indexes do you have on the seven underlying tables?  Look at the execution plan of the query and look for table scans or clustered index scans. ...

Jakub

You can't insert the results into a table, because the procedure returns more than one result set.  And you can't do a UNION of the results for the same reason.

As...

Neil

Create a login, say WebUser, give it access to the database, put it into a role, say WebRole, and grant WebRole execute permission on each store procedure.  You do have...

Wayne

(1) You could set up master and target servers so that all jobs are defined on one server.  Then you could combine the two jobs into one, with the execution...

You could use roles instead of assigning permissions to individual users.  Then all you need to do is assign the permissions to the role, put the new user in the role...

And what better way of doing so than calling on the help of members of this community?

Terence

Before you implement this, search for other discussions on this topic.  There is a gotcha with this type of approach.  If you will be updating this table at the publisher...

You'd have to test the impact of taking transaction log backups every 20 minutes.  I would be surprised if it had a noticeable effect on performance, though.  Don't forget that...

Happy to help - can't explain the Microsoft thing, though!

John

Jon

From Books Online:

char[(n)]

Fixed-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is n bytes. The SQL-92...

Is it possible that one of the other triggers on the table is removing the updated data?

John

The answer to your question is I don't know whether it's actually possible.  But even if it were, I wouldn't want to do it.  You'd have performance issues with transmitting...