Then you want to use the EXECUTE AS clause in the CREATE PROC definition to impersonate, say, dbo. That will give the rights necessary. When they execute the stored procedure,...

What behavior are you expecting and not getting?

With SQL Server 7, every database user is a member of the public role. If the public role has permissions against the tables, everyone that's a user of the database...

Is this user StatePA\PZarah the developer account or the SQL Server Agent service account?

Did it not run because of a permissions issue or did it not run because it collided with the data load job? What was the exact error? Also, can you...

Rayven (1/27/2009)

---

Erm, having seen the way that the network department configured active directory, it was migrated directory from the original domain, so it is just one huge chunk.:crazy:

Don't ask me...

Not sure. If the SQL Server was set up to once upon a time run as System or Network Service (not positive about this one) it might have registered the...

Rayven (1/27/2009)

---

As soon as a change is made to a group or user, we always ensure that they log out of the network and log back in to ensure that...

Unless you have a lot of sites with multiple site links, it shouldn't normally take that long for security changes to replicate. What may be, though, is that the change...

Three things to check that come immediately to mind:

1) Is his Windows login disabled?

2) Is his Windows login denied access to connect?

3) Are any of the Windows groups he is...

Is that one user a member of a lot of Windows groups (including nesting)? Is the user having login issues for any other resources (such as file shares, Exchange, etc.)?

Steve Hindle (1/27/2009)

---

I have now run the setspn command and received the following message:

C:\Program Files\Resource Kit>SETSPN -L PAPOTH17

Registered ServicePrincipalNames for CN=PAPOTH17,OU=Application Servers,OU=Serve

rs,DC=intra,DC=blackburn,DC=gov,DC=uk:

MSSQLSvc/papoth17.intra.blackburn.gov.uk:1433

HOST/PAPOTH17

...

If you mean how to change SQL Server from Windows authentication only to Mixed Mode (where it does both SQL Server and Windows authentication), see Books Online:

Books Online - How...

What is the error or result that you get? Is the Symmetric Key already open before executing this INSERT statement?

Jeff Moden (1/24/2009)

---

Michael Earl (1/24/2009)

---

I am a big believer in "Le mieux est l'ennemi du bien" - for many one-time, small-record count operations I often use RBAR solutions just to...