Shane,

I usually give db_datareader and db_datawriter permissions, that takes care of your tables. I think you have to give Execute permissions on stored procedures using your script. Create another role,...

Then I suggest that you may use GRANT statement that is more granular then ddladmin. You can look up the syntax in BooksOnline searching for the keyword GRANT. It will...

I noticed that the first time you said "datareader and datawriter" the second time in your reply you say "datawriter only". Yes, datawriter is only for writing, not for selecting....

It does look like Deny somewhere. Sysadmin membership overrides "Deny"

(1) What is the exact error message?

(2) Does he log in from another computer?

(3) There are lots of situational "Special Identity" groups in Windows: Everyone,Authenticated Users, Batch, Dial-Up, Interactive, terminal server...

Hi, could you test the following

1. How much time does it take for this statement to be executed locally on server B

2. What is the network protocol that you are...

Hi,

Is this user a member of another group or role? The permissions may be restricted based on his group membership. Did you by any change restrict access by applying db_denydatareader...

Max,

I have lots of experience supporting both R&D developers and users that don't have lots of computer skills. I find it that regular users usually describe the problem exactly  because...

Chris, there is a certain way then: scripting. I don't think you will be able to transfer SID's  and passwords. Does not matter. If you will be using Integrated, they have to...

Ronnie, sa24 means something like that:

To add users:

declare mycursor cursor for

select name from master.dbo.syslogins

where name not in (list of names or select statement goes here,

'sa')

and name in (

list of...

Chris, what authentication do you use now? Integrated or standard?

Max,

Check sysxlogins and sysdatabases on both servers for dbid of your database (sysdatabases) and what is default for the login (sysxlogins).

I was able to reproduce your error when connecting using...

I didn't peek using BOL. I ran it in Query Analyzer. It was a 6 digit number the same for each database, so it is not a connection, not a...

Hi all,

There is another "project management" problem with a trigger. The task states: " It is important that each change be captured ..." But...

Steven's advice is good. Stop SQL Server and copy out your Data directory. I restored the servers twice using this technique. If the system databases are in this directory too...