A user has right to create and operate a SQL job, but only limited to the
jobs that this user is created.  Without granting sysadmin right, how to
grant a user to be able to operate and change the job which is created by
other users?

I cannot display Chinses at ASP page. All chinese data (whatever is
Traditional or Simply Chinese) are displayed as ????.
My website connect to MS SQL Server 2005 and all the chinese data are
displayed as ????.

I've been trying to get linked servers set up on two servers. Here is what i
have done in my test environment.
I've got two servers. Test1 and Test2. They are Standard 2005 installs.
I've got two user accounts set as local admin on both servers They run the

I am new to SQL Server 2005.  I have a user who is db_owner equivalent.  
However, when he starts SQL Server Management Studio (logged in with his ID),
he cannot see anyting in the Securables box under database user properties or
database role properties.  Is there anyway to have ...

I am working on my first CLR project, having progressed to the point where I
have a working version in VS2008.
Project is set to "external", and the assembly is signed with a PFX file.
On both servers, I am running in the role of sysadmin, and would like my

"Using the CAS layer is a huge improvement over running extended stored
procedures under default login credentials..." (SQL Server 2005 Unleashed, p
1332)
Yes, this is wonderful, but in the context of my project, we would all be

I want to make some changes regarding accessing my SQL Server Database, but
before I start playing around with it, I want to post something to see if
anyone can give me some guidence so I don't end up locking myself out of my
SQL Server Database or SQL Server all together.

I'm trying to migrate one SQL Server 2000 database to SQL Server Express,
and I'm having the following issue.
In the SQL Server 2000 database I have two users A and B. User A belongs to
the sysadmin server fixed role, and user B belongs to the db_datareader and

I have a database with multiple schemas and each contains Tables, Views and
Stored Procedures.  My users are on the intranet.  I have a windows
application that the users run to Select, Insert, Update, and Delete data
from the database through the Stored Procedures and Views.  No ...

I have several SQL Server 2005 databases on my server.
What SQL Server 2005 security role has the least priviledges to complete the
following capabilities?
Able to create tables, triggers, create primary and foreign key

I have situation over here where I need to give a user only create
table access to one of our environment. How do I do this? Is there any
way where I can create such a role? We're using Sql 2000 SP3a and
windows 2000.

What permissions are required by an AD account/login to access a SQL Server
host?  For example, if my login - [mydomain\myuserid] needs trusted access to
remote databases on the host MYSQLSERVER, does my account require "connect to
machine" access as well as being granted access ...

I have a problem connecting my SQL Server 2005 from a ASP Webpage.
When I trying to connect using the following connection string:
"Provider=SQLOLEDB; Data Source =2xx.xxx.xxx.xxx; Initial Catalog = xxx;
User Id = xxx; Password=xxx"

I'm trying to set up a login and a database, in order that :
* The login can do anything inside its database, except dropping it or using
'dangerous' sql commands
* Once logged using Management Studio, express or not, the login can see its

I notice when I create a new database within my SQL Server that the
permissions for the new database automatically adds a user (Who is configured
as sysadmin) with dbo permissions to this database.
Both within the login properties of the select user (User mapping) is listed