I am running Backup Exec which installed it's own instance of SQL.  I have
also installed SQL Express on the same server.
They are started using the following command lines:
C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC|Binn\sqlservr.exe

I am getting the following error:
"""There are no primary or candidate keys in the referenced table
'UserPrecedence' that match the referencing column list in the foreign
key 'FK_USERS__UserPrecedence'."""

I have a table which has two fields which make up the primary key:  LORD and
LLINE.
I want to insert records from a temp table (TWDECLTMP) if they are not in
the table (TWDECL).  The following where statement does not work:

I need to install SQL Server Express on a low-performance PC, say 600
MHz and 480 MB RAM.
I know two ways:
1) Deploying my VB.NET application: the installer download from the

have installed this database[and accompanying log file].  followed technical
directions on how to install and try to attached but get this error:--
C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\MSS\MSSQL.1\MSSQL\AdventureWorksDW_Log.LDF" is

Does anyone know of a free query analyser tool. I want to connect to
sql server 2000 DB remotely and run some queries and stored procs. I
was wondering if there were any free tools i could use to do this.
Thanks

When I try to open any table in Management studio in design mode I get the error message "The parameter is incorrect"
Please Help
Tarek Al-Jamal

I've installed the SQL Server 2005 client utilities on a laptop that's used
for development. When I try to create an odbc connect to SQL Native Client
2005.90.1399.00 that specific driver doesn't appear in the list of drivers
available for selection. I've verified that it is in ...

I can't seem to find  the place in the Management Studio to configure if a
stored procedure will be executed when the server starts.
Does anyone happen to know where to find it in the Studio or if it's removed
from the GUI, and has to be done through sp_procoption now?

Each month, we get a table with all data for the month from a vendor.  We
use the data to generate reports.  We have been combining the data into one
larger table so we can run reports across months.  Now we are close to
running out of room on the hard drive.

Well, I tried posting this in the m.p.ss.tools group, and all I got was a
lot of "why aren't you using the Query Analyzer, it's so much better".  So
let me state right at the outset that I don't LIKE the Query Analyzer, and
telling me I should try using that instead is NOT the ...

I am trying to create a stored procedure that will add the last two
entries from a column.  If I had a column named box, I would want to
add the two values in box, for which my ID column is Max and Max-1.
Is there anyone who can help me with this?

I am running SQL Server 2005 and trying to make a copy of a database from
Management Studio.  Using the Backup wizard I go through all the steps that
you would normally walk through to make a copy, and actually start the copy,
but when I do I get the following error message from ...

I have some tables that I'd like to copy from a SQL6.5 database into a SQL
2005 database.
The table structure and data needs to come across, ideally automatically so
I don't have to create the tables first in 2005.

I really need some advice on fine-tuning a stored procedure
that is the meat of the search logic on my site. Customers
are allowed to save searches, which dumps the search logic
in a table called SavedSearches for later access to the search.