No, what is happening is when I run setup I get the main installation screen along with the three setup programs starting) and when I click the installation link on...

Has there never been a solution to this? I just did a new install of 2005 EE SP2 with Advanced services (i.e. Full-Text Indexing) and it is having this...

I test every scenario and it never changed the recovery model to bulk logged. It may have something to do with the fact that I can't set "select...

ok, that's what I read it to say so my misunderstanding. However, another interesting thing is that I ran this statement:

sp_dboption 'MyDatabase', 'select into/bulkcopy', 'TRUE'

and it didn't change to...

I don't think this procedure would have help in my situation. I had a database server crash (while doing backups) and the log was corrupted. Tried to do...

This would have been good information to know two months ago. I love undocumented commands, especially when they have been documented.

If the files were not detached (using sp_detach_db) succesfully then you cannot not use sp_attach_db. The key here is detached "successfully".

I don't order the select from teh temp table that way since I'm using the temp table to select a page.

EX:

SELECT *

...

The select statement that is used for the insert has an order by on it. Here's the temp table definition and the insert-select statement:

CREATE TABLE #tmp (rownum int identity(1,1) not...

I was refereing to the size of the table as reported by sp_spaceused (i.e sp_spaceused 'tablename').

You guessed it, I forgot to make it a UNION ALL.

It looks something like this:

            Dim sqlCmd As New sqlCommand()

                .CommandText = "dbo.myProc"

                .Parameters.Add(new...

The people that answered NO did so because they know that the only source of this information is from the sysprocesses table and creating a sp as a proxy to...

It must be done in the same QA window in which you executed the SET IDENTITY_INSERT statement. 

So, to test your theory did you create default on the subscriber with the same name as on the publisher then try and drop the column?