Thanks Maverik

Yup. Got to the bottom of it. It was orphaned users caused by backing up the Development database, and restoring it onto the 'Live' server.

Fix was....

sp_change_users_login @Action='update_one', @UserNamePattern='serviceaccount',...

Wonder if this is linked to the fact that we restored the database?

Hi,

Progress (I think!)......

Attached is a screenshot of the error I'm now getting. It occurs when I try and Map the serviceaccount user to the Midas database (by ticking the...

sorry to be a pain, but how do i access that in Management Studio?

I've tried a describe command, but it doesn't work

thanks for the advice!

More questions

The following code was posted earlier to allow me to list user tables

select 'grant select on ' + a.name + ' to serviceuser'

from sysobjects a where...

thanks guys, great advice and help.

is there a spool command in sqlserver? Im not being lazy, it's just that I find BOL so un-intuitive right now being an (ex)...

Thanks, I'm making progress. I can now get a list of the tables (50 of them), but I dont want to click 150 times for insert, update, and select...

Thanks again for your input.

If I go Server/Security/Logins

then right click on the ServiceAccount (that I created earlier), then select Properties.

I select the Securables Page, and click on the 'Add' button

It...

Is this the best way of going about this?

thanks for the advice.

Had a rethink how I want to go about this. As SA owns the database, I want to create a new single user, then get SA...

thanks.

I've looked at the standard database user roles, and they are not bespoke enough.

The system will have hundreds of users, so I need to create a role with the correct...

Hi guys,

Can anybody point me to a good link to Books on Line, which might give me a clue how to do this.

Many thanks

Hi,

We're actually using SqlServer 2005 express, and SqlServer Management Studio.

Do we get to the sql statement in the same way?

Many thanks

Thanks guys, I'm gonna have a play with this and get back to you soon