Just Besides the "Cancel Executing Query" (stop sign) you can find "Display Estimated Execution Plan"

Hope you can find it

A clustered index *is* the data itself so when you specify the fill factor for it you *ARE* specifying the the *table* fill factor.

Fill factor is a completely optional thing,...

There is also the "time" constraint. I have been involved in very complex processes that eventhough a rewrite was the *right* thing it was not the fastest to provide the...

just look at the Toolbar buttons in SSMS when you open a "new query" window.

Ok back to square one.

If your table is a HEAP you CAN'T specify fill factor at table level.

If your table is CLUSTERED you CAN!!

The Fill factor you specify in how...

>>>So, since 2005 allows me to disable unique indexes as you state, I see absolutely no difference between a unique index and a unique key. There must be some...

Fill factor refers to PAGE level.

An index is a structure (BTREE) made up of PAGES, A heap is a table with no clustered index made up of PAGES and a...

- why would I EVER use a unique key rather than a unique index ?

Not sure what you mean by "unique key" if what you are trying to refer to...

Oh, and you are welcome

don't get me wrong Alrets work fairly well. The reason I said "fairly" is that ususallly you would tie a job that records the alert content somewhere and if the...

Use triggers on the Subscriber and join the inserted/deleted tables with the Local_*

tables as needed

The other posiblility is that you restored a database comming from a different server and the login that owned the DB on the source server does not exists or is...

Well I answered like that because this forum is for "2005".

For 2000 the best you can do is use an Alert!

I guess the the Error Numbers were 18453 and...

There are Logon triggers in SQL Server 2005!

http://msdn2.microsoft.com/en-us/library/bb326598.aspx

Never clean metadata is only related to the tables:

MSmerge_contents

MSmerge_tombstone

MSmerge_genhistory

MSmerge_current_partition_mappings

MSmerge_past_partition_mappings

MSmerge_generation_partition_mappings

On the other hand,

MSmerge_history

is cleaned up by the Agent History Clean Up in the Distribution database!...