SQL scripting... is there anyway to create a script that inserts a column
into all the USER tables in a database that is a primary key column, doesn't
allow nulls and identity is set to yes, the seed is 1 and the increment is 1
as well? I am enabling a database for replication ...

I've seen ways to delete duplicate rows.
Can someone give me some sql to do this?
I have a table with varchar table_name_start, varchar column_name,
varchar table_name_end;

I am trying to obtain field definitons for all user tables.   I see the
columns I need if I use sp_help tablename, but do not see all the columns I
need (such as calculated) in inforamation_schema.columns.  Does anyone know
what the name of the table is where the fields reside ...

I have a table with news, they have dates and right now I
select * from table
order by date
How can I select only the top 5 results

I created a pass through query which concatenate a few fields. When one of
the fields is null, the whole string doesn't show. How do I over come this
issue.
the syntax

I received a db2 data file that I converted to MS-Access. From Access I
ran the upsize wizard to put the tabel in SQL. It put the table in ok
but all the data types are nvarchar. I have a couple of the fields that
are cureny and some that are numeric.

A client has to insert many files with bulk insert. I start it using windows
scripting host with VB Script and ole db provider for SQL Server. works good
and fast. Only really big files will take several minutes to terminate.
How can I set the client timeout?

 I have a table with two field (name of the table : table_with_two_field)
 field1, field2
when i create a simple view with no clause where:
create view dbo.view_on_field WITH VIEW_METADATA

I'm looking for some advice on the best way to execute a complicated
search on my eCommerce web site.  My example here is much simpler than
the real thing, but it should be enough to get the point across.
Imagine that I have two tables:

I'm trying to use DTS to import data from an XLS into a SQL table.
It works fine in that it INSERT's the data. However, I need it to
UPDATE the table, based upon a ProjectID. Can this be done?
Can a DTS package be fired from a SP using parameters?

i go to security and open a user
username=salih
password=12345
i have a database name Stok

i am confused about inputing decimal numbers to access database and then to
the sql database
i use double at access and foalt dataype at sql server is this ok for
inputing decimal numbers

We are gettingready to get the SQL Server 2000 Trial Software.  Is the trial
software a full version of the software or does it not give you everything?

First of all - sorry for may be stupid question, but as I am not
Win* administrator and my field is *nix, I am a little bit stuck wit
a problem, presented to me by one of the customers. He has few window
boxes with some webfile and (most important) - mssql database. And h

I am working with a SQLServer installation where all public permissions
have been revoked from the system.
I currently hold the securityadmin and sysadmin roles to perform my
logicall access control work (creating logins and adding users to