I have a table with three fields, viz. EmployeeNo, WorkDate, Company.
Records for a particular employee (viz. 660) are given as follows:
EmpNo   WEDate        Company
660         19990530     SA Cargo

I am planning to upgrade my SQL Service Pack from 3 to 4.
Can any one guide me what are the points to be considered before
doing this.
One more point I want to do this in a Clustered Enviornment.

Having 'Google-ised' I've found that there does appear to be a problem
connecting to an MSDE 2000 DB from a remote machine (either LAN or WAN), but
I haven't found what the concrete solution is.
It definitely appears to be a Windows inflicted problem, as I can connect to

The Win2000 server in my office starting running slow and find that the
SQL2000 server eat up many cpu usage.... I'm thinking it may be caused by a
query in an in-house application which doing a Select Max query before
insert a history record, the history table probably the ...

I'm a developer, not a DB admin.  I'm writing a .NET app that uses
crystal reports.
The table I need to output is built inside a stored procedure.  No
choice, it makes use of some temporary tables.  (Believe me I've tried

Is there way to check what were the last modifys to specified database??
I mean the last insertion, deletion ........... ..  and in which tables.
Thanks for advance

I am new to database development and am writing a database as part of a
university course
I have created a table as below called CableWire - the table is created ok.
CREATE TABLE CableWire

I have SQL 2000 runninh on a 2-node cluster running Server 2k3.
When I start Enterprise Manager from my PC, a huge SQL.log file is created
(or gets appended) and each action afterwards takes quite long time to do.  
This happens only from my own PC.  Other admins' PCs do not have ...

in my app I've a constraint like
constraint sales_fk foreign key (salesman)
   references members (member)
What is the use of the keyname "sales_fk"? My idea is only to remove (or

Hello, another question from a newbie to mssql.
Is there a way of allowing access to database only by providing username and
password (disabling trusted connection and preventing administrator to
access database through enterprise manager or otherwise without supplying

I took the back from Enterprise version of sql server and trying to restore
at MSDE Version... it restored successfully but after that when I try to see
the tables and procedures it gave an error and like the database is not the
valid schema.. can any one tell me  what I have to ...

I am trying to setup a Performance Condition Alert and on this one SQL
2000 Server the 'Type:' drop down does not give me the option to choose
"SQL Server performance condition alert".  "SQL Server event alert" is
the only item listed in the drop down.  Is there some setting on the

I have a problem with my TEMPDB Database.It gets extra size through
importing data into one of my databases in same server.
How can I shrink my TempDB Databse?
Thanks

since yesterday I have this message everytime I try to open Sql Server
"Enterprise manager";  I reinstalled the outfit completely without success
any solution
thanks

I have inherited a SQL 2000 SP3 system running on W2K SP4.  We have a table
load process that uses BCP to insert data and build a temporary table.  I
then have a stored procedure that appends two system parameters onto each
row.  The procedure then selects all the rows from the ...