SELECT SERVERPROPERTY ( 'MachineName' )

When I run this it returns the name of the virtual server, not helpful in this case.

Temp table are only visible to the connection that created it (except ##temp tables), so you won't be able to see it in EM.  Remi's code won't work either on...

Check the growth properties on tempdb, and the disk that the tempdev file is on.  The problem is not (necessarily) with the log file but with the .mdf file.

Your process sounds good to me, however I don't think you need to bring anything offline.  I would just move the SQL group to the next node before rebooting.

I don't know of a trace flag, but I once wrote a stored procedure that created a trace to log all CREATEs, ALTERs, etc., then set it to run on...

You can make most constraints NOT FOR REPLICATION, though not a primary key constraint.   Usually if an index has PK_ in front of it it's part of the primary key...

1. What's going on with the 2nd table is that SQL Server is bulk inserting the records, then waiting to commit all of them.  If you watch the log file...

It has been my experience that the Extent Scan Fragmentation is less relevant and less reliable than Logical Scan Fragmentation.  The statistics I look at are Scan Density and Average...

I've used the drop and add with sp_repladdcolumn and sp_repldropcolumn before without any problems.  Last night I had to change a column from varchar(5) to varchar(50) (grumbling at the developers...

Assumption 1 is incorrect.  The nestlevel does not depend on the number of rows affected.  You can fire one trigger and have hundreds or thousands of rows in the inserted...

Several things wrong with your SQL:

select *, identity(int,1,1) AS ID into mytemp from tmp_product_inventory

declare @id INT

set@id =0

While @id<= (SELECT MAX(ID) FROM mytemp)

Begin

set @id =@id+500

insert into [122.23.23.2].ed.dbo.product_inventory

select col1,...

If you reinstall MSDE it should not affect any user databases you have created.  If you're not sure you can back up the files before installing (.mdf and .ldf files). ...

Could be a firewall issue.  I've had problems writing files to the DMZ.  I've had to change the process to write to a local drive and then copy to the...

This used to bug me to no end.  I believe it was fixed in service pack 4.

FIX: DTS Designer may generate an access violation after you install SQL Server 2000...

Can you post the network error?

I've seen "The network name is no longer available" error sometimes.  This is pretty vague and unhelpful.  Lately I've seen it when I've tried to...