Yeah, it's different in 2005 and 2008. That number's too large to be an object ID. It's actally a partitionID. To get the objectID back -

select object_id from sys.partitions...

I've seen it a couple times, but I have no idea what causes it. It doesn't happen every time a database is detached.

Yeah, that works. Sorry, I misread your question, thought you were adding a default to an existing column.

The WITH VALUES is only valid if you're adding a new column...

Be careful with DTA. It has a habit of over-recommending things. Take its recomendations with a large pinch of salt and test carefully before putting the indexes it suggests in.

I've...

onlo (8/26/2008)

---

(2)The default instance name of SQL 2005 Standard or Enterprise Editions are the server's machine name, but in my newly installed SQL 2005 Express, the default instance name is...

Firstly, don't delete your log. You are asking for a suspect database doing that. It will grow when you do index rebuilds.

It could be a number of things. If you...

Are the instances all enterprise edition? Standard edition ignores locked pages.

What's the max memory set to on each of the instances?

Defaults only apply to new rows inserted. If you want the existing rows with null to change to that value, you'll have to run an update statement.

If you're working with 2005, take the 2005 exams. They're not redundant with SQL 2008 out and I believe there will be an upgrade path.

I wrote one of the betas...

Are you getting an error message? If so, what? How are you trying to set the primary key?

Colmn order doesn't really have a meaning in SQL. It just determines how the columns appear when the create table is scripted and how they are returned if SELECT *...

Duplicate post.

Direct replies to http://www.sqlservercentral.com/Forums/Topic558592-149-1.aspx please

Not the backup.

You said the database had being detached. Can you reattach the database files to the SQL instance?

Correct. There are a number of scripts...

In addition it causes internal log fragmentation...