I am adding foreign keys to a database and saving the generated scripts.
What I do not understand is that all script begin with empty
transactions. Why ?
Example follows :

Is it possible to get metadata (i.e. descriptions of tables etc.) in
sql-server? In Oracle you can retrieve this information with tables like
all_objects, user_tables, user_views etc. For example, this query selects
the owner of the table 'ret_ods_test' (in Oracle!):

i need to import data to excel from an sql db. the sql db is on a server,
excel will be on a remote computer. I'm quite happy to use access as an
intermediary if needed. i would also like to be able to write from excel to
sql is poss. although it this if tricky then i might well ...

I know the number of rows returned compared to the number of rows that
exist---a percentage-- determines the selectivity of the data.  Is there a
commonly accepted percentage that determines, 'yes, this data is hightly
selective'?  Returning 90 of 100 is 90%, definitely not ...

I am attempting to execute the Stored Procedure at the foot of this
message.  The Stored Procedure runs correctly about 1550 times, but
receive the following error three times:
Server: Msg 512, Level 16, State 1, Procedure BackFillNetworkHours,

I need to recreate the system tables (sysobjects, syscolumns,
sysindexes, sysforeignkeys, sysconstraints, sysreferences, sysindexkeys
at least) in another SQL server.
You may say "Thats easy! Backup and restore the database!" and I would

We have VB clients connecting to a SQL 2000 server and some are using named
pipes and some are using TCP? does any one know why this would happen?
Thanks

NooB questions: What's the difference between a login user and a
database user?
Thanks!

We have a table that has an identity field along with 5 other domain
fields.  The identity field is not declared as a primary key.  The
table has 3.5 million records.
A consultant was hired recently to provide insight.  His major

Hi, All
I use SQL Server 2000 and Win 2003 Server. I try to create a SQL Server
Login audit log using Profiler, but cannot find the tools. I looked at the
Windows Event Viewer, it only logs Windows authentications users for SQL

I wish to run this script daily. Can this be scheduled?
backup log shipmateDB with truncate_only
G

I am no expert in sql, but I keep stubbling on this problem:
I have a table t1 with 2 columns (a,b)
I have a table t2 with 2 columns (c,d)
I need to delete all records from t1 which have the same value (a,b)

I have one field organization_operating_name that is on two tables vendor and
vendor_loc
I want to update the vendor name to the vendor_loc name
I tried this but get errors...

This is what one of the tables looks like - they are all similar and there
are about 60 different tables:
CREATE TABLE SalesData1(
smalldatetime TimeStamp,

I have a scheduled job contain 2 steps. Step 1 is execute DTS Package
using CmdExec 'DTSRun', step 2 using TSQL to execute just simple query.
This job execute recurely every day, every 6 hours.
The problem is, sometimes this job was successfull, but sometimes