I'm confused about permissions...  
I have user X, who is a member of db_owner role.
I have stored procedures owned by dbo.
The database is owned by dbo (sa).

Hi,
im required to display chinese names out using ms sql server but i do
know how to use the unicode. Can anyone help me along with it?
Thanks,

Hey Guys,
This is my first foray into SQL Server. We are going with SQL Server 2005.
We are upsizing our Access Database to SQL server and using our old Access
Frontend as we re-build the application in .Net. The Server will NOT be

I am running into an issue when I run the following query to revoke access
to all the SQL 2005 users from other DB.s
use master
Revoke View any database from public

I want to implement row level security in SQL Server 2005 without
implementing views. The desired effect is firing a query on a table
like "select * from <tablename>" should return only rows which are
accessible to the logged in user. Which rows are accessible will be

Hello.  Does anyone know of a way or tool that can tell you if the data/info
being sent over the network is being encrypted to a SQL Server 2000 on a
Win2K?  My certificate expired and just wanted to know if I need to install
a new certificate or not.

I have an application and I want to add/edit/del Logins and Users in Sql
Server 2005 through the application, can I do it?  I am using windows
authentication.  Currently I call a stored proc that I try to pass a login
and it doesn't work.  For example this is my Delete.

When I try to run a DTS package as a job, this is the error message I
receive. The user has db_datareader, db_datawriter and db_ddladmin rights.
All the DTS does is execute a stored procedure and put the results in an
excel file.

I just installed SQL Server 2005 and am configuring it prior to migrating
some SQL Server 2000 databases from another server to it.  I have two domain
accounts that I plan to use as the logon accounts for SQL Server services.  
I noticed that the 2005 installation created several ...

I run several DTS Packages that load databases residing on two seperate
instances of SQL Server 2000 on the same server.  For security reasons, I
need to be able to set the Databases on one instance to Read/Write access,
set the database access on the other instance to Read only, ...

I am developing a client/server application using sql server as the back end.
This app must allow for two login scenarios other than the usual one
user/one workstation.  First, the app must allow users to log in from any
machine on the network even when using a machine running ...

In SQL Server 2000, we were successfully able to use database chaining to
allow xp_cmdshell to be called by a stored procedure in our database without
granting any specific rights directly to xp_cmdshell.  In SQL Server 2005, we
find that this doesn't work and our procedure fails ...

I have a system that before I arrived, they granted all permissions to all
objects to the public role instead of creating there own. While in the
process of trying to fix this we discovered that all users through the public
role have the ability to create objects.

In SQL 2000, sometimes it takes a long time to fetch data from a very  
simple table that in normal cicumestances I can get the information in a  
glance. and when I take look at
(enterprise manager->management->current activity->locks/process id)

Is it possible to find out ‘Who’ created a specific database user in database?
Thanks
bb