Why are you using -c AND -t , -r \n when the BOL documentation states -c uses \t and \n for the field and row??  I would also try putting...

Why not DECLARE 4 different variables and then define as follows:

SET @max1 = (SELECT MAX(SUM(field1)) FROM dbo.tableA)

SET @max2 = (SELECT MAX(SUM(field1)) FROM dbo.tableA WHERE MAX(SUM(field1)) < @max1)

SET @max3 = (SELECT...

I would just re-install the client tools then.  IF the EM is missing from the box however, I would wonder who has been doing what to your production box AND...

Right mouse on the shortcut for Enterprise Manager, navigate to that folder and see if the MSC file exists or not.

IF it doesn't exist you will need to re-install.

IF it...

What are you trying to accomplish and then we may be able to help better...

Research SYSOBJECTS, SYSINDEXES, SYSCOLUMNS, SYSCONSTRAINTS....

Edwar, IF you DON'T want the data integrity porvided by the FK don't add it.  This way the CHILD table won't be deleted.  However, you will need to code to...

Have you tried DEATTACH/REATTACH or restoring from SQL 7 > SQL 2K????

IF you cannot see it and you know it is there CREATE a NEW package....  Only way I know of...

Not that I have tried this before (seriously) just thinking out of the box...

Have you created a stored-procedure that does the DBCC that you want have that owned by the...

Defragmenting windows is a lot like gluing a vase back together again.  A lot of work and if done right nobody notices that there is a hole in the back...

There are plenty of discussions here on how to do that.  I would try using the search option on the toolbar and type in list databases.

I don't know why it changed but I have never seen the servername/ = DEFAULT instance before either....

Spence,

I believe that version does have Reverse Engineering in it.  I would read the HELP file on how to do it.  I don't remember it being difficult.  The bad...

Erwin and Visio can reverse-engineer tables/views.  SQL itself can provide the code for all objects and you can look at sysdepends/syscomments for additional information (may not always be 100% accurate...