Hi there, I found this script on Microsoft's site for creating a Database,
User, and Account in SQL 2005, it works really well and I like it alot, does
anyone know how I can modify it to allow that user to view/edit their
database via the Microsoft SQL Server Management Studio?

I have a sql 2005 database i can look the tables but not execute pro, i have
regsiter the users iwan and iusr in the database
Microsoft OLE DB Provider for ODBC Drivers erro '80040e09'
[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on

When I create a new SQL login via SSMS the user gets assigned db_owner role
by default. This only happens on the one database.
Removing the db_owner role during creation of the user causes SSMS to fail
with an error because it tries to remove the user that is being created from

Using Microsoft Office Accounting 2008, database on SQL Server Express -
Whenever I start the application from a client, an error is entered into the
event log on the server.  This does not appear to be causing any issues with
using the application but is obviously annoying.

Does anyone use tools from www.lumigent.com, www.guardium.com,
http://www.idera.com/Products/SQLcm/ for this?
Others I've looked at a little are www.tizor.com, www.rippletech.com,
www.iplocks.com, www.consul.com and www.gridapp.com.

             I don't know if this is an IIS or SQL Server issue.  I have an
ASP.Net web application that is set up with Anonymous access turned off and
Windows Authentication turned on.  The SQL 2000 server (on another machine)
is set up for Windows only authentication.  The ...

How do I grant execute proc privileges in SQL Server 2005?

On a SQL 2000 SP2 box that pre-dates me, I have some databases that came
from who knows where, and in the sysusers table there are some orphaned
records (no master..syslogins records that match on sid) which are aliases
(isaliased = 1).  I'd like to clean them up, but ...

I'm new to the subject but I'm working on implementing column encryption and
want to make sure I understand exactly how everything fits together. I've
created a master key and certificate. I've backed them up to files and then
restored on a secondary server.

I have a test SP on sql server 2000 running on Win2003 server.  Workstations
are all XP SP2.  On some workstations, MSAccess can run the test sp, but
Access does not recognize the same SP on other workstations.   I tried
logging into another workstation using my account - which ...

I am new to SQL Server 2005.  Here's my issue:
I am installing PeopleSoft with SQL Server 2005 backend.  When I try to
create the database it is giving me an error message Msg 5123 operating
system error (Access is denied) while attempting to open or create the

I have store procedure with dinamic sql which run select from 2 tables.
I want my users to run my store procedure without granting the select on
them.
How can i do it?

After I setup 'sa' password in SQL Server 2005,  I get out SQL Server and
re-login using SQL Authentication mode with 'sa' and pasword, I get error:
"A connection was successfully established with the server, but then the
error occured during the login process. (Provider: Shared ...

I posted this in the server group, but haven't gotten help, so i
thought I should try the security group.  I'm trying to give my users
the ability to run sp_who2 on SQL 2005 and
see all sessions, without granting them additional permissions.  I

How can I allow a user to see single database size, and kill process on that
DB, without make it "sysadmin", on SQL 2005?
thanks