Just change it. Database settings aren't replicated and recovery model has no effect at all on replication.

No idea. Look up UidcreateSequential in your development language's documentation and see what it is and how it behaves.

If you're inserting NEWID() explicitly, it doesn't matter in the slightest whether there's a default defined on the column or what the default is, the values inserted are the same....

When the OS is under memory pressure.

There are two different scenarios....

I assume you mean Count...

select COUNT(*) as [type], [group]

from tblname

where group in ('a','b')

Group by [group]

Wait.

Recovering means that SQL is running restart-recovery on the database. When it finishes the DB will come online.

What error is the backup failing with?

Why do you think you need to rebuild master?

No. I said:

The page...

No, the fragmentation will be the same, both are having NEWID() specified as the value so the default is being overridden.

Then when 2008 was installed, a new instance wasn't created. Possibly just the client tools were installed. You'll need to reinstall and install a new SQL instance.

Check the SQL configuration manager, it'll show you all the services installed.

If you have a SQL 2008 R2 instance, connect to that and you'll be able to restore a DB and set it's compat mode to 100.

You're connected to the SQL 2005 instance. See if there's a 2008 instance installed (check services), if there is, connect to that. If not, install a SQL 2008 instance.

If there is a SQL 2008 database engine, connect to that and you can set a database's compat level to 100. If there's only a SQL 2005 database engine, then...

Grant Fritchey (5/19/2014)

---

jcrawf02 (5/19/2014)

---

As for el Potter, what irked you so much Grant? Was it the fact they were lost in the woods (and whiny, oh so very whiny) for...