how to set read only permission to whole MS SQL 2005 database for some user?
How to set read only permission to some tables in this database only and
other tables in this database are denied? It is for some user again?
thank you

I have been looking over a Sql Server 2000 they have dts  packages saved as
file storage packages and packages saved on the server in msdb. They also
have packages saved in meta data services.
Does anyone know the benfit of saving a package to meta data services, is

I created two maintenance plans:  one to reorg the indexes on two specific
databases and another to rebuild the indexes on those same databases.  When I
ran a report called Index Physical Stats available from the Standard Reports
in SSMS, the report indicated a number of indexes ...

Here's the environment:
SQL2005; 2 nodes; Active/Passive; Named Instance
I used SQL Server SAC to connect to the Virtual server. I noticed that
remote connections is already enabled and the option "Local connections only"

I can't do these inserts into INTERNAL_CAR table.  I get an error on
line 2.  It says near the ",".  I don't know which "," has the error.
I have a lot of inserts to do.
INSERT INTO INTERNAL_CAR (car_id, equipment_id, aar_id, build_date,

I would like to have your opinion on what would be the best disk
configuration for our application. Our DB server runs SQL Server 2005
and has 5 physical drives: 4 are SAS (15RPM) and 1 SATA (10RPM). Our
application is transaction intensive and I would like to configure the

I use sp_who to look at how many connections are made to our production
server. Normally there are about 300 connections, but sometimes the
connections will jump up rapidly to more than 1000 for several minutes, then
gradually come down to normal again. I need to investigate why ...

I have a developer who has give me a mdf file she would like uploaded to our
production sql 2000 machine, what is the best process to do this.
I believe it was created in sql express 2005 edition.
Please help

Hi every bodies,
Other than SQL Server Encryption and SQL Server MD5, in the market, are
there any other 3rd party product can do data encryptions ?
I understand this news group is talking about Microsoft product, but I raise

we have a few servers that are running SQL7 and SQL2000
we are looking to move them and upgrade them to SQL2005, but some of the
DB's within these are still being used daily, but most of the programmers
that created these DB are no longer with us so we are trying to find out

On the same instance of SQL 2005/SP2 (win2003 sp2) if I backup a database
with a full text catalog and then restore the database (on the same instance)
I get the following warning:
Warning: Wordbreaker, filter, or protocol handler used by catalog '%ls' does

I have a SQL 2005 server in production and a standby server off on a remote
site. I use log shipping to keep the databases on the standby server in sync.
I was wondering if there was a way to extract the logins from my production
server, and somehow synchronize them to my standby ...

Hello. I have a SQL 2005 job that runs every 2 hours in the morning. If it
runs to completion at any time I set a flag to tell subsequent instances not
to run. Works fine. The job normally takes about 1 hour. So what if, for some
reason, the job is running longer than 2 hours and ...

Twice this week, I have gotten in trouble with SQL 2005 preventing me from
conducting different tasks because it gives me a message saying that
something is "in use".
I know about running sp_who and sp_who2, in order to track down a database

We have a problem connecting to a server over a WAN and after some
experimenting found that Named Pipes would connect ok whereas TCP/IP fails
I am using cliconfg to set this on the workstation..  The error reported is
a network error.  SQL is 2000 version