I have an application that loads a dotnet assembly into sqlserver and it
works fine on my dev machine, but fails with the following error on the
customers machine.
Assembly 'MyAssembly' could not be installed because existing policy would

I have a java app that runs as a Window's Service.  It is configured to log
on as Local System.  When trying to connect remotely to SQL Server 2005
using Windows Authentication through the SQL Server jdbc client, an
exception is raised saying "Login failed for user NT ...

I'm trying to install SQL Server 2008 Express on Vista Enterprise SP1. The
install ran until 99% done but at the end it reports an error "database
engine services failed - access is denied".
- I tried 3 different flavor of Express with the same error: Express

Good morning
1. What is the proper terminology? Permissions or Privileges?
2. How do I find out what permission a user has on any object in the database?
I am looking to find out all permissions for this user on any object.

I would like to determine the tables that a particular application is
accessing.  I am running Sql Server 2005.  Is there an easy way to achive
this?
Thanks for your help!

i have the following question:
user1 as sysadmin, if i execute "select * from master..sysprocesses". i  
receive all users info
user2 as public, if i execute "select * from master..sysprocesses". i  

I need to be able to programmatically verify the SA password from a .cmd
script.  Is there some piece of code that someone could recommend to do this?
Thanks,
Mark

Hi Friends,
I am new on sql server database. I try to move all front-end database which
is attached with MS ACCESS applications. I read several books but getting
confuse for all. I think because I have no experience on this. Please help me

my regular PC crashed, and I installed the client tools on
my laptop. However, when trying to connect to the instance
the windows authentication login, an password tboxes are disabled,
and I cannot change them. from the default credentials in my machine

Is there anything on the server side one can doe to cut down the excess Login
that are in the "sleeping" Status, for example is I excute sp_who2, I will
see user Test1 with 45 connections (SPID's) in a "Sleeping" Status.  Add that
with the other users that are logon with multiple ...

A developer added http endpoints to a test sql server to be applied later to
a production server. Would you consider http endpoints on a sql server even
though its just for internal use a security risk?
thanks for any advice

I am using SQL 2005 and have created a schema:
  CREATE SCHEMA [CRM];
Then I created a bunch of stored procs under this schema. These CRM procs
call other [dbo] procs:

I have had problems on one of my sql databases where stored all procedures were dropped, indexes were deleted, permissions changed. Icannot find who or waht did this
I want to lock anyone from making changes to the sql objects such as tables, procedures, views etc
What is the way ...

This seems logical place to post this question, if not, recommend a more
appropriate group.
SQL 2008. Developer and Enterprise Editions, planning to use TDE
(Transparent Data Encryption).

What SQL permissions are required for a user to perform a restore?  We have
some test DBs (SQL 2008) and the user will be performing his own restore.
Thanks
Blake