I am very new to SQL Server 2000.  We have SQL Server 2000 SP 3 on Windows
2000 SP4.  I have 4 instances running on the server.  I am able to register
the 4 instances in my copy of Enterprise Manager at my desktop and using
Windows authentication with out issue.  But, after a day ...

I currently restored a databae from another agency with a 4.5 G .bak file.  
After restoring I was questioned why the databaes was so huge.  I used the
sp_spaceused stored procedure and it reported 3.7 G used.  There are
approximately 700 tables but many of them have no rows.  ...

I have to create a database application (multiuser) for about 15 users using
SQLExpress and C#. I am very new to SQLExpress so I need some basic
direction. Do I put the data file on the network drive and install
SQLExpress on each machine or do I install the data file and SQL on ...

Assume I have a table like:
CustomerName    OrderDate     OrderPartID
London           7/7/99           33
Paris           7/6/99        22

I am reading Administering SQL Server, a study guide for 70-228
on page 27, it says:
"INSTEAD OF triggers are useful when a DML operation is unsuccessful."
I think this is nonsense. Any comments?

Hi all, I am brandnew with SQL2000, so sorry in advance for
stupidities....
SQL2000, SP3, running on a SBS2003-server with WindowsSharePoint
Services.

I have strange problem.
I write to MySQL data to table with one column of varchar(8000). I write
750000 bytes, so it get 93 records of 8000 bytes and the last - 6000bytes.
but what is strange - when I check length of this records:

Hi, any help is appreciated. I dont know the best way I can do this
fast and easily.
What I want to do: Move a MAX value of a column to a variable from my
SQL Server and be able to store it as a table or other recommended way,

I am writing a program in .Net to retrieve properties of Sql Server.
How can I find the following properties without querying the database:
1. Replication enabled
2. Default language

Is there an way to create a table of months using SQL functions?  If
"July" is entered for the beginning month, and "December" is entered
for the ending month, then I'd like to create a table with 6 rows, one
for July, August,....December.

I have masde Installation which have to execute dts packages to connect
to my sql server and load the data to the SQL databases.
Would anyone have any experience with this and know how to make this
work?

Yup i am "newbie" to SQL and i need to rename a database so it will work with
a program we have istalled.  The last DB administrator left the company
unexpectantly and the current database has 5.1 GB log file that I cannot get
to shrink and is filling up our harddrive.  there is ...

How to export/import database role?
How to export/import all user on all database?
Thanks

When we create a diagram which defines the relationship between two tables,
there is no way to specify the exact reltionship type, as there is in
Access.
We need to create a relationship that is, in SQL, a left outer join. In

I am having a serious problem of removing and adding again an user in a
database.
Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
    Dec 17 2002 14:22:05