Hopefully I am posting in the right newsgroup...
I am trying to troubleshoot an issue with a user who needs to access a SQL 2000 database from Ubuntu.  He is passing the following command which is generating the error below (I've blocked out the IP Address):
tsql -H XXX.XXX.XXX.XXX ...

i've a linked server. i force security context using remote login and
password (last option in security tab).
In this way every user on every database can use this linked server,
this is correct (for me), but i have an exception.

I have a client that I need to enable the Windows firewall since he's
on a University network, but having delt only with secure network
before, I have never really taken any time to research the WF (I know,
my bad in a way, but like I said, I have always dealt with network

Based on the assumption that Windows stores some sort of (GUID?) value when
an application uses Impersonation to connect to a SQL Server database, is it
possible to obtain this value at either the application or database level?
My objective is to maintain an audit log of changes ...

I need to know all the permissions available in MS SQL 2005 and also the
privilleges that each role has been given.
Is there any system table in SQL 2005 from where i can get both these
information.

I'm trying to grant a database roles (contract_role) to have "select" to the
tables within schema1. Is there a way that I can grant select on all of the
tables to contract_role instead of choosing one by one and click?
Thanks

OK,
I set up SQL Server 2005 Express on an XP Pro workstation.
Then on a Windows 2003 server I installed SQL Server management studio
express (SSMSE).

Could anyone tell me what are the Minimal permissions needed to generate a
script of all of a database's objects?  I want to have a daily job doing that
for me, collecting the scripts from some servers, running as a user with
minimal permissions.

I am trying to determine if granting CONTROL permission on an asymmetric key
is a good or bad thing?
What does CONTROL mean in the context of the key?  I want to assign it to a
database role that is used by typical users.  I need to do this to use the

I have a query regarding the Default Public role to any New SQL Server Logins.
Its exists by default
can it be removed ??
Has Microsoft given any recommendations about this behaviour??

I'm running an SQL 2005 in a classroom environment. Students are allowed to
create databases and did so last night for a test. The instructor wants me to
deny them access to the DB's they created so she can grade them. I can't seem
to drop them from their DB's because they are ...

I have several views and I have granted update permissions to different users
against these views but when the user tries to update they get a permission
denied error referencing the table the view is against. When I grant update
permission to the table to the users can update. I ...

I'm hoping someone already has a script out there to grant only necessary
permissions (not SA role membership) for a user to run the following:
Database Tuning Advisor
SQL Profiler

I am using SQL2005 Enterprise Edition with mixed security and part of my
maintenance plan is the cleaning up of old backup, reports and logs. Owner of
the MP is the SA account.
What NTFS permissions does the SA account have?

I have a application (Net Framework 2.0) connect to SQL Server 2005 through
SQL Client. When I run application (without debug in VS 2005 SP1), it's ok,
but I start debug in VS 2005 SP1, an exception throw when I open connection
to database: