Since RDMBS and its language SQL is set-based would it make more sense
to call a given stored process "Stored Sets" instead of current
theorically misleading Stored Procedure, as a measure to prod
programmers to think along the line of sets instead of procedure?

I have a table in which their is record which is exactly same.
I want to delete all the duplicate keeping ony 1 record in a table.
Example
Table A

I have a strange question and hope someone can shed some light on the
problem.
First let me give you my scenario.  We are using doubletake to replicate our
database server files between the local site and off site.  I will name

Could someone help me get the following SQL statement working?
SELECT
standardgame.gamename,
standardgame.rowteamname,

Good day,
Can SQL Server tools (QA, EM) can be installed on a client machine from
a full SQL Server installation on a server?  I can't find the CD.
Thanks for your time.

I am getting a failure on the db backup job of one of my maintenance
plans.  It is coming back with the generic error message of,
"sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).  The step
failed."

I'm looking to find out how I'd go about setting up a database where a
visitor to my site could punch in their postal code, and find out how far
they are from another postal code.  For example, AutoTrader has this feature
I believe to tell you how far the vehicle is from you.  ...

i have a little problem here.
im attempting to write a stored procedure that compares two tables of
the same data structure and adds (inserts) extra records  that exist in
table1 to table2.

First off, sorry if my cross posting offends anyone. I'm posting this
in Access and SQL Server groups - not sure which one is appropriate.
I have a relatively simple ASP.NET/VB.NET application that is now
hitting an Access 2000 database over an intranet. We have to migrate

I've seen this noted in many posts, but nothing I've checked out gives
me any clue on how to do this.
Basically as my topic says, I have a DTS and I simply need to export
some data from a table in MS SQL 2000 to an Excel spreadsheet.  I also

I have MSDE installed on an HP server as some of the utilities required
a database.  I have also subsequently installed SQL 2000 onto this
server which is a windows 2003 box.  I know it complains at the start
of the installation but I was under the impression that it would still

When i use to work on Windows 2000 advance server and Sql 2000
I was able to do network restoration by using a mapped drive where my
backup use to be lying.What i did was I assigned administrator rights
to my login and in Services (mssqlserver)i added my login.

Has anyone seen a 25 TB data warehouse on SQL Server?  I do not know of
such a thing, but maybe it exists out there.

I am looking for a pre-packaged solution for auditing record level changes to
SQL tables. I know this can be set up through custom triggers but my
organization does not have the resources to develop this. We are looking to
buy something that will work out of box.

When I restart a machine, the following message appears, note that the
SQL Server status icon in the server tray has a blank circle:
The network path was not found.
When I double-click on the SQL Server status icon in the system tray