I have an SQLServer 2000 instance with a DataBase.
I have 2 users: sa, new_user.
The [new_user] has membership role: public, db_datareader, db_datawriter
It has permissions to manipulate some table and stored procedures. He can

After some (significant) effort I successfully requested and installed
a certificate on my test sql server box on my intranet.
I then selected "force encryption" on the SQL Server Network Tool.
SQL Server started up just fine indicating (as far as I knwo) that it

I have a SQL Server 2000 with about 20 databases, each database with few
hundreds of objects (tables, sps, views etc).
I have a new user (application) who should read data from few columns (not
all), from only one database, only one table. The rest of 19 databases are

Dear all,
When i backup a database to a device(file) and then restore it into other
computer. The user always use to know the name of the database in order to
restore the database, can i make a backup to user without know the name of

I create a new login; let's say "aaa" with authentication "SQL Server
Authentication" and no database access specified.
Now... I'm able to connect to my SQL Server 2000 using Query Analyzer with
this "aaa" login and read data/execute stored procedure even I didn't specify

How can I assign a user the ability to change/reset password for users
assigned to one particular database only in EM. Example, Northwind is one of
the databases in my system; I want the user john to be responsible for
changing/resetting password for users with access to ...

I am trying to identify if I have unwanted guests gaining access to my
system or it's a run away query by a user on my network.   I am thinking of
recording SPIDs as one way.
Via Spotlight I can see that I'm having beyond normal usage.  Granted I have

how do i reconfigure an installed sql server to use standard security
(sql login/pwd) instead of only accepting trusted connections
(requiring windows login/pwd)
thanks,

I was running SqlServer 2000, on windows 2k server with several Access linked
servers all running fine. I upgraded my server to 2003 Enterprise, and
applied sp4 to SqlServer and now cannot get the linked servers to work. Error
7399 Authentication Failed.

How does one create a copy of an existing SQL login account.  I have a
database that has a single login with everything setup.  I just want to be
able to copy the existing account to a new user so I can set a different
password.

Is there an easy way to capture existing user rights from a SQL Server
instance in a scripted format and simply run the script in a new SQL Server
instance to set all of the user privileges?  Thank you.

Hi, all:
 Dev Tool: VB6
 Server: SQL Server 2000.
 Environment: Windows 2000/Windows XP/Windows 2000 Server

I keep getting this error when i send a large document into sql server with
ADO.NET System.Data.SqlClient.SqlException: XML parsing error: Not enough
storage is available to complete this operation. I have about 8 gigs of
memory on the machine and sql server isnt using even half of ...

Good afternoon,
I need audit all the events in the databases, from the basic users until the
operations of DBA. How I can enable this detail of events?
I have a SQL 2000 sp4 and windows 2000 server SP4

We have a bunch of client machines that use MS Access (pretty sure all of
them are XP) that has linked tables to our SQL Server 2000 database which is
on it's own domain and server.  I was wondering if the data that is
traveling between each client that connects to our SQL Server ...