Not sure you would want this, though it's possible that you have different developers that have rights to create objects in the schema. In that case, the object owner and...

My guess is that you need to drop the endpoint and recreate it.

Users are not schemas. Do you mean you need to know which object is owned by a user?

If this is the user schema, then you could easily see from object...

How is the linked server configured? Are logins mapped? It is possible that there is a misconfiguration here.

Do you mean Integration Services packages? Maintenance Plan packages??

These are stored in msdb in various tables. You could give SELECT access to these tables to the developer.

This problem usually occurs when you are trying to get data into a space into which it will not fit. I'd actually recommend exporting this data (and decrypting), then bringing...

Are you using a passphrase or encryption by password?

The database master key should exist with the database. If anything, when you restored, you'd need this to continue to the restore.

The...

I don't think that there is anyway to slip data into the stream that would be susceptible to SQL Injection. I suppose it's theoretically possible to slip into the replication...

You do not drop the key or you will not be able to decrypt values. You assign users the ability to use the key. Typically you wouldn't encrypt with an...

what are you trying to do? This is such an open ended question, it's hard to answer.

SQL Server 2005 has data encryption features, but you want to be careful about...

If you have moved all services to their own network accounts, then this should not be a problem. Each service runs under the context of the service account, or under...

No, you have two constraints with different names,

Each instance requires its own IP. You can set those in the Configuration Manager.

However, you should be very careful about exposing 1433 to your public side. A report last week...

Check the links and is there a point to what you are asking? Meaning why do you need to know?

If it's curiosity, there's a lot out there to read about....

If you use one of the third party backups, LiteSpeed or Red Gate Backup, they might do object recovery for you (depends on version). SQLCompare from RedGate, does comparisons from...