arun.sirpal (5/11/2011)

---

yes that pretty much what i do, dettach the DB , move the MDF, NDF and ldf files, then re-attach to the new location. i tend to script it...

Then it means the query is wrong. Wrong table, wrong schema, wrong PK id.

I'd focus there because you have no other problem at this point.

JoeS 3024 (5/11/2011)

---

That is one of the differences in opinion. It was placed into Full Recovery Mode with no T-log backups being done. And no I can't explain...

What part of the job do you need to edit?

It looks like it's only the gui that throws the error.

Try it again and let the schedule run to see if...

ilker.cikrikcili (5/11/2011)

---

Ninja's_RGR'us (5/11/2011)

---

I tested this on my machine and it works (but I do get syntax error in the next query so I'd focus there if I were you) :...

The size of the code of the view in bytes in the system table of the db.

So NO :-).

GilaMonster (5/11/2011)

---

Take the DB into single user mode and run the following.

DBCC CheckDB('lpb_greatplainsutils', REPAIR_ALLOW_DATA_LOSS)

You will lose one page of data in the table ADB_OPEN_YEAR. Since it's a heap, not a...

If it works with exec it will work with execute_sql.

You still have mystery to solve here!

Like I said, if you don't ask the server to keep then ordered, you can't complain that they are un-ordered

Seriously. Put a...

Immortality :alien:

I'm just happy you're happy. :smooooth:

Without a clustered index, the server doesn't need to maintain any order. So those table will always be fragmented (even if fragment means the order is not respected).

Ha sorry, I just copied that from my daily...

I tested this on my machine and it works (but I do get syntax error in the next query so I'd focus there if I were you) :

DECLARE @sql...

WHERE object_id = OBJECT_ID('boss..dealpending','U')

if boss is another database the query will return nothing, hence null.

I'm testing some code in case the double .. is a typo.