Do you have any other servers in this EM you can compare? Also, does Services panel show started or starting? As well, have you tried starting a job to...

I believe Andy is right, but there is no real documentation on this field anywhere but I do seem to recall something like that.

"Don't roll your eyes at me. I...

Right truncate does not cause the file to shrink use EM to do this once will be easiest and fastest way or DBCC SHRINKFILE can be used.

"Don't roll your eyes...

The answer is you cannot. You can only specify with CREATE TABLE.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Then you may want to look at using Dynamic SQL via EXECUTE or sp_executesql. See SQL BOL for more details on these processes.

"Don't roll your eyes at me. I will...

First try right click and refresh in EM, may be the client not reading right. If still red then stop via services control panel and try to start from EM...

6.5 backup cannot be restored to SQL 7 or 2000. If using 2000 try the databae copy wizard. Should work like a charm.

"Don't roll your eyes at me. I will...

When you say synchronize are you talking data only or replication situation. Have you tried copying the data over or using a linked server to compare the data and mae...

Ok first the database structure does not change and the speed should not degrade. I also would go with SP4. You also state PeopleSoft is not compatible, have you check...

Or as you had started

Select <col list> from

tablea left outer join tableb left outer join tablec

on

(<Table a - table b join condition>)

on

(<Table a - table c join...

It depends on the size of the table and how each field is used. If the table is not updated then I would consider using a clustered index to limit...

Note: it is best not to use in SQL 2000. Truncate log and shrink work just fine and the issue no longer exists as 7 suffered.

"Don't roll your eyes at...

First depending on how many records change and how often deletes and inserts occurr I would make the indexes on ListAnimatedDVD and ListBugsLifeRebate clustered and this will should improve both...

Odd and I cannot find anything on this. Are there any more error details. Also, since you have a SQL2000 copy of the database a sure fire workaround should be...

Check out http://sqlindex.com/item.asp?ItemID=9066

It is helpfull and has several links that go into detail.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)