I register the server using SQL Server Enterprise Manager. Next day,
all my settings are gone. So I need to register server everyday.

i have a login with role who have rights
Grant Select, update, insert, delete, view definition to onLine --online is
role
but i want to attribute right SET IDENTITY_INSERT  on my role

I'm running this command on my SQL server and I'm getting an error 'Access
denied.'
  EXEC master.dbo.xp_cmdshell 'cacls "\\PC1\Temp\3.bmp" \E \G
DOMAIN\User:R'

I posted this in the server-group, but no response, I removed the
message and now trying with this group...
I installed a SQL Server 2005 Workgroup on a W2k server.
Every 20 second the SQL errorlog log the two lines below:

We have an application that allows users to add and drop logins. In Sql
Server 2000 it was not allowed to drop a login that was linked in some
database but in 2005 this is allowed. We need a way to check if login can
really be dropped.

I have a SQL Server database and I want a user to be able to execute
stored procedures only.  These stored procedures use SELECT and WHERE
statements and return integers.
I have set EXECUTE permissions to the sp's as needed for the user.

I attempted to add a column to a table containing around 10 million
rows (will do it differently next time :-) and ever since the server
has been hanging and only occassionally can you connect to it and do
anything with it. It all seems to be hinging on a process that is

We have a database on SQL2005 with 50 tables.
We want to grant someone read table rights to only some tables.
Right now we created a SQL account and he can connect and read all
tables in this database.

I've got a 2000 server that I want to make sure is within best practices for
Sql Server 2000.  I know that "permissions granted to the public role are
applied to
all users in the database and permissions granted to the guest user

      I did EXEC sp_adduser 'Vidur', 'Vidur', 'Recruiting'
      And now I see the user Vidur.
      What will happen if I'm doing
      EXEC sp_adduser 'Vidur', 'Vidur', 'HR'?

I am trying to get a SQL Data Source working with my ColdFusion MX7.  I am
trying to connect to a remote SQL server.  I have created to identical user
ids on each server so that they can do pass-through authentication.  Do I
have to give these users any ntfs rights or are all the ...

I'm interested in querying my domain's Active Directory database from SQL
Server 2000.  In particular, I would like to be able to take a network user
name and determine its membership in network groups so I can list all the
network logins that user has to a SQL server instance.  ...

It all stared by observing and error when running Bulk Insert with a sp where
the input file was on the C drive – it was fine. Then I switched to where the
file was on a shared network drive – it failed with Access Denied. I did a
work around which works fine but did not still ...

I posted this message to the wrong group (sqlserver.programming), so I'm
reposting here.  Sorry for the repost... it's late... so here goes:
OK, so I'm testing EncryptByCert with some code like the following:
DECLARE @v varchar(8000);

There's a system procedure that Crystal Reports (for example) invokes upon
connection to a SQL Server database:  sp_schemata_rowset
In SQL 2005 this returns the three default Schemas:
 dbo