I have a Maintenance Plan that keeps failing on an inherited system.  The
error is:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL
Server Driver][SQL Server]DBCC failed because the following SET options have

HI I have installed the adventure works db scripts and have both the
adventureworks and adventureworksdw databases installed.  I am missing the
adventureworks.sln  (adventure works project files).  I tried to install
adventureworksBI.msi but I got an error that the adventureworks ...

On the Books Online for sp_monitor:
     total_read Number of reads by SQL Server.
     total_write Number of writes by SQL Server.
Can anybody explain what is Number of Reads/Writes mean? Is it the number of

Been a while since I've posted here but I'm back to doing some
database programming (using Access VB, which allows you to rapidly
code the front end GUI at the severe expense of some debugging tools).
Access apparently only allows your control (buttons, textboxes and the

I'm trying to write a query that limits the number of rows returned for each
unique person in the table.  For this particular query, I would like to
limit the results to 2.  So John Doe may have 10 rows in the table but I
only want to display 2 rows in the results.  I also don't ...

as looking into numerous forum threads I have a common problem with no
common solution.
I'm running Win XP professional SP2 with MS Office 2007 including Business
Manager (if that is of any relevance...).

We have been having problems with some of our internal tables.  We have a
table that contains quite a few columns, and three indexes.
The primary key on this table is a guid, and there are about 8,000,000+ rows
in the table.  We are finding that the indexes on this table, after ...

I'm searching for some tips on using the Referential Integrity. I use it
almost always, but I'm not so sure if it is the best deal. I think about
cases in which the user must update (or must believe it has updated) the
referenced data without changing the referencing one. I'll try ...

We have a small sqlserver express database that is hosted.  It seems
to make more sense to take care of it on our own machine, so I'm
looking to copy a database.
I suppose one option would be to get a copy of the physical files from

Say if i have a join on 2 tables : Table1 with 1 row and Table2 with 1
million rows and if I dont have an efficient index and my query has to scan
every page in Table2 hence acquiring shared locks on that table, the
question I have is , for the duration that it reads through ...

I am collecting perfmon data in a SQL database but I dont know how to write
any web code,etc. to display the contents in a chart so I can look at the
data over a specified time range.
Are there any tools out there that I can download and just point it to the

Hi, I would like to know if is possible to loop through all tables (via pure
sql statement or SP) on a database and gives me the record count from each
one...
Because I need to know the table wich has more records on it! Can you help

Does anybody know how to get the total number of transactions for a period
of time on a SQL Server?
Thanks,
Lijun

If I dont use online indexing, will there be blocking for the entire
duration of the index creation be it clustered or non clustered ? I thought
there might be an exclusive lock on the table for the entire duration where
even selects would be blocked...but it doesnt appear to be ...

We are currently doing a project in which one of our SQL servers databases
and logins need to be moved to a new server that will eventually be renamed.  
We have a 3rd party backup application that can restore the databases to the
new server without a problem, but it doesn't do ...