Every user with permission to connect to the database is a member of the public role. Permissions granted to the public role would then be granted to anyone who can...

The Desktop Engine might not have any network libraries enabled (only Shared Memory is enabled). If that's the case, this KB explains the issue and what to do:

How to help...

To change the schema owner, execute the following query, making the appropriate substitution for **Schema Name** and **New Owner**:

ALTER AUTHORIZATION ON SCHEMA :: **Schema Name** TO **New Owner**

Once you've changed...

If you accidentally cancel out of the provisioning tool and you run into a situation where the service isn't running at the time, you can execute it manually:

SQL Provisioning Tool...

You want to use normal database roles. Application roles must be specially enacted by a stored procedure. It sounds like the setup you have, that's not the way to go.

And...

After the fact this is hard, but log reader products can do it if the evidence hasn't been overwritten or truncated.

Prior to the fact, there are 3rd party tools to...

You're looking to take all the logins for a particular server and making each login a user for the database? Is that correct? In other words, if you have 17...

I'm looking on the Technet forums and it looks like others have this problem and it's due to the fact that the installer is looking for the file from the...

sunshine (4/8/2008)

---

Now I get this error logging into sql server with my windows login. It is part of the domain otherwise it would not let me add myself as...

I apologize for the delay in replying, it's been a busy few days.

If you're going to re-use the same LUNs, you effectively can't have both running at the same time....

It is not specific to just SQL, but represents best practices concerning different types of servers, to include being able to manage them reasonably. However, if you want a list...

I don't know that I would agree with this....

Apex SQL Log is compatible with SQL Server 2005:

http://www.apexsql.com/sql_tools_log.asp

Is the account which connects to SQL Server running as the database owner? If not, is INSERT, UPDATE, DELETE granted against those tables? If so, is there a need to...

Agreed. The best practice is to do it at the schema level, as Carl indicated. It's the simplest approach and it ensures that any tables/views which get created in the...