Hi Chris,

I've taken a quick look at this and may have something of use.

First off I have a couple of scripts to create the tables and data, presumably you won't...

Personally I came across a similar issue when I was involved with the transfer of an application from a site in Holland to my office in the UK. It seems...

Well it looks like the solution is to remove my users from the sysadmins server role.

I only recently added the users to this role, the reason being that I wanted...

Steve,

thanks for your post. I think it's helped me get a bit closer to finding the source of this problem.

I tried out removing 'malinowm2' from the system administrators group,...

>>Does the userid 'malinowm2' have database owner permissions on the database? This could be automatically mapping you to 'dbo'.

No, the user has membership of several database roles, 'public', 'fcc_admin',...

I tried that out and got slightly different results to you. I used a windows account, and also a sql account (malinowm2). My results were the same for both users...

Yeah that returns 13 as my user_id.

I've tried deleting the user and recreating through enterprise manager, assigning to roles etc., same result though.

Thanks for your help with this by the...

I saw this article w hile back. Haven't actually tried it but it might be useful for you:

http://www.simple-talk.com/sql/t-sql-programming/temporarily-changing-an-unknown-password-of-the-sa-account-/

ok, i've tried this out with a couple of other logins, both of whom are members of the fcc_admin group.

I also get the same results for the 'select user_id() as...

ok, so i ran these commands:

select user_id() as UID, user_name() as Uname

select suser_sname() as SUname

go

select  is_member('fcc_admin') as [is_member]

go

sp_helprolemember @rolename = 'fcc_admin'

and this is what i got in my results pane:

UID   ...

looks like the image isn't showing so here is what I see in query analyzer (I am logged in as user malinowm2)

query pane :

select  is_member('fcc_admin') as [is_member]

go

sp_helprolemember @rolename = 'fcc_admin'

results...

Hi,

I tried using sp_helprolemember, and it shows my user id as being in the role, however is_member is still not working.

iwg,

First off I was slightly wrong earlier, our indexed columns are query id (fk to another table), company id, dealer id, person id and company name.

in answer to your questions:

>Do you...

Ed, iwg,

first off thanks for your responses.

Personally I was thinking that a clustered index might not be particularly appropriate given the way the this table is used, but it's always...

thanks for the help on this!

I think the way to go is dynamic sql (why didn't I think of that!). This has uncovered a couple of issues with user permissions...