As a general rule (with exceptions), you are able to use the new t-sql functions even for lower compatibility levels.

It's the engine that needs to understand the query, not the...

Lowell (5/9/2011)

---

man that's for sure; i im flubbing up syntax...

Lowell (5/9/2011)

---

the database compatibility is set to 80 instead of 90, or you posted a SQL2000 question in the 2005 forum;

the ROW_NUMBER function was introduced in 2005, so i assumed...

bg.FlagDate as EnteredDate,

Missing the comma at the end of the line.

I think Lowell's having issues with that today :hehe:.

EXEC('USE [DatabaseOne]; DROP STATISTICS [dbo].[TableOne].[StatisticOne]')

Possible. Have you tried closing IE and opening again? That would take care of the session issue.

Michael Valentine Jones (5/9/2011)

---

You might consider defaulting the PK columns with the NEWSEQUENTIALID() function to minimize the page splits as you insert data.

create table myTable

(

ColumnA uniqueidentifier not null DEFAULT...

Awesome advice.

The challenge here is this is a CRM application. And we're building plugins in that CRM (MS dynamics CRM). That means that we both create new tables...

GilaMonster (5/9/2011)

---

No, but...

Ok, so I gather by your complete lack of answer about the FF that I should ignore that option completely even if all the guids are indexed?

Grant as suggested powershell and I assume you can do that there.

I've suggested create job on the fly and start job (always async). Won't matter how many dbs because...

What is > '4ixfea55rytq2nzmekuussm3' ?

That's...

You need to get the real error. We can't help you with that.

The only "obvious" possibility is that you have different permissions between the users in each environement.

Or maybe...

No need, just run the script and setup the job to run daily.

I can send you my "tweaked" parameters if you want but I'm not sure you need them.