Viewing 15 posts - 1,231 through 1,245 (of 6,105 total)
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...
April 9, 2008 at 9:57 pm
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:
April 9, 2008 at 9:55 pm
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...
April 9, 2008 at 9:51 pm
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:
April 9, 2008 at 9:44 pm
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...
April 9, 2008 at 9:38 pm
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...
April 9, 2008 at 9:33 pm
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...
April 9, 2008 at 9:31 pm
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...
April 9, 2008 at 9:28 pm
sunshine (4/8/2008)
April 9, 2008 at 7:19 pm
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....
April 9, 2008 at 7:15 pm
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...
April 9, 2008 at 7:07 pm
Manoj (4/9/2008)
I would recommand you to stick with the dbo mode for all tables, It is the best practice from the microsoft.
I don't know that I would agree with this....
April 9, 2008 at 6:51 pm
Apex SQL Log is compatible with SQL Server 2005:
April 8, 2008 at 7:42 pm
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...
April 8, 2008 at 7:35 pm
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...
April 8, 2008 at 7:32 pm
Viewing 15 posts - 1,231 through 1,245 (of 6,105 total)