Since the desktop had only one drive, there could be no RAID, so the server RAID configuration will definitely slow performance.

Did the desktop have an IDE Drive ?  If so, be aware...

Are you aware of stored procedure "parameter sniffing" ?  That is, when the stored procedure is first invoked, the query plan is created based on the values of the passed...

In the future, please post create table statements including all primary key and foreign key constraints such as:

Create table Customer

 (ID integer not null

 , DateCreated datetime not null

, CurrentStatus varchar(40) not...

Since the diagrams are saved in table dtproperties in each database, you could copy the data from one database to another.  Here is an example which has been tested:

set identity_insert <targetdb>.dbo.dtproperties...

Look in Books OnLine for sp_add_jobstep where the specifaction for the @command can include one or more of the case-sensitive tokens which are replaced at run time.  These token are not...

Try creating a table (named "sequences"&nbsp with all numbers between 0 and 32767 as detailed below.

Your actual query can then reference this "sequences" table such...

This is untested, but since you have already hacked the system tables, try this:

In sp_addlogins, there is a section of code:

if @encryptopt = 'skip_encryption_old'

begin

 select @xstatus = @xstatus | 0x800, -- old-style...

<so the GUI  is my crutch! >

Yes, it gets quite complicated using T-SQL but being unable to reproduce your actions...

1.  Are you getting this error ?

Server: Msg 18452, Level 14, State 1, Line 1

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

For SQL Server 7.0, the samples (which are an option when installing) has the TEXTCOPY.exe  From Books On Line:

TextCopy is a Microsoft Foundation Class (MFC) C++ example that illustrates...

exec master.dbo.xp_msver 'PhysicalMemory'

Please be sure to post the DDL for 1 of the tables & its indexes, along with a sample SQL update statement.  Does the table have a unique clustered index...

Regarding the differences between the same query having major differences in response times on different servers, this could be a problem with the physical database such as out of date...

I have used SQLIOStress many times to prove hardware configuration problems.  What specifically to you want to know ?

Regarding "Same or near similar spec drives etc and some are just...

Having a single column containing two pieces of information (the value and the sequence within the value)  is a violation of the rules of normalizatoim...