+1

Thanks for the quesion

Thanks that the bit I was looking for. To be honest I would...

Assumed I had rights to person and beneficiary schemas and got it right.

Otherwise the answer could be it depends,it depends,it depends

- Is the user account running the client application a member of the workstation domain or the server domain? (Or perhaps a third domain?)

The are two domains Client pc is...

Thanks for your feed back.

I'd done some initial checking before coming here (not in first post - sorry) the SQL box runs fine from either clients within the same...

Good question and Hugo raises some good points too.

My mistake in not getting a point today for being too literal with my interpretation of the question

Goonhilly

Crisis

Swing Time

Bugger (just found out through company internet, company has been sold)

Koen Verbeeck (11/28/2012)

---

The only correct answer is 0.

There are 8 statements in the estimated execution plan, but no queries.

From BOL:

A query is a request for data that is stored in...

journalist

Also I would check that you have the same software installed / services running on both machines. I had a similar issue a few years ago but after investigation found...

Jumping in late on this party - I agree entirely with not using cursors loops etc.

A "quick and dirty" solution would be to create the tables as permanent table not...

And if anyone questions why you are being pedantic about backups / corrupt databases etc - get them to read this[/url] - you might want to have a look as...