So if "create schema abc authorization dbo" would grant ownership of objects to dbo schema. Does this mean anyone with access to dbo schema would have access to objects owned...

I would agree. However, the nightly process logic will dictate whether it's insert (there by generating a new id) or an update to an existing record.

I can see situations where, the nightly production loads may need to be loaded to non-production systems every once in a while. In this case, you would need to generate...

The test won't be adding positive...

In our case, Uniqueidentifier / guid's won't work for account_ids.

We could either restore from backup or replicate data or sync using SSIS to instance_2.

I think this should work:

Use Identity column...

The issue is when that instance_1 is production only and instance_2 needs both prod and test data. There is the need to maintain the prod ids in instance_2 with the...

Thanks for all your responses. This issue has been resolved.

In a nutshell here's what was going on...

Our AD sec admins created global groups and we recently began migrating to a...

Apparently, user has rebooted the machine already, and had not reset their password. The reboot should have updated the access token information as well.

I will drop the group and re-add...

did you ever get this to work? I'm having similar problems, where some users aren't able to login to SQL Server while others part of the same group are able...

Can anyone provide any insight on the impact of Security group vs Domain Local Security on cross forest authentication?

That is correct, I created a login and then mapped it to a user in a database. The default database is master. They are using SSMS to connect to the...

Not only did I go the quetion right, I also had a note in the discussion. How about that?

This without logging in to the site.

It may have to do with the registry not updating during the setup or the restart causes the agent to go back and reload all the settings.

Out of curiosity, are...

Go back and drop the data / log files since dropping an offline database doesn't delete these files.

Are you running the services under a domain account? If so make sure the service account has access to the folder.