Hi. I have lots of processing to do on the server - from the client
(Access) I call a sproc which returns a recordset (the sproc is
essentially a big "select"). With the obtained data , I need to
generate a report. How do I set the Recordsource of the report to the

I am trying to establish if the standard edition of SQL server 2005
actually has support for a 2 node active/passive cluster and if it
will be available in the proposed product release on November 7th.
I have seen references to this in

I've created a clustered two column index on a table where the second
column is an integer value.  When the first column is the same, instead
of ordering in numerical order it is ordering 1,10,100,2,20,200 etc.
How can I change the behaviour to order the data in numerical order?

I have a small theoretical issue.
I have one table, which is prettyu large. There is lot of evaluations
running on this table, that's why, each process need to wait for
another to be finished. Sometimes, for some critical functions, it

Periodically I run some very complex queries or stored procedures that
"hang", and the bigger problem is that it locks up all of the database
clients ie 50 users connecting to the db via a windows application.
I never know when this is going to happen, but when it does it leaves

MSDB.dbo.BackupSet logs all backups
is it possible find Status of Backup (Success / Failed)?
Table "BackupSet" hasn't any information about it.
I need log and notify all backups with status

Hello Forum readers,
Any advise on the following, will be much appreciated :
I have a customer who tries to extract some columns (fields) from an
existing SQL table or add more columns (fields)

I am trying to establish if the standard edition of SQL server 2005
actually has support for a 2 node active/passive cluster and if it
will be available in the proposed product release on November 7th.
I have seen references to this in

     I write you because I have a big problem with request access : when
       I use a sql server wiev in access (attached view) and i join it with
       a local access table, the sql server trace say sql server send all
       the data of the view to a access   . This view have ...

I'm just entering the SQL DBA field and i'm looking for article or site that
outlines little things to watch out about sql server. I'm more interested in
the operational aspect such as "never reindex during production hours", when
to run dbcc commands, and what hash join and nest ...

I have to download a MSSQL database, which shouldn't be a problem using
enterprise manager... the problem I have however is that I can connect to
the database and export most of the data in to a local database... all
except the main table... which gives an error... the problem I ...

is there any solution to use null values to the parameter
my sql commandtext=
"select * from info where name=@name and surname=@surname"
in visual basic .net

I have a SQL Srv 2000 table where one of the columns is a Phone number, but
all of the data is simply 10 digits (2065551212) ... I need to run something
that will either alter all of the values so that they display the
appropriate marks (206) 555-1212  or at least mask the column ...

In my application i have a table of 10,000 records. i need to fetch them
1000 at a time . Which mean
first fetch 1-1000
Second fetch 1001-2000

I have a table for storing alerts (exceptional situations) occuring on
devices that I monitor.  Associated with each alert is an alert code, a
description, the device responsible for causing the alert, when the
alert was generated, and when the alert was removed (device no longer