Viewing 15 posts - 6,226 through 6,240 (of 18,926 total)
arun.sirpal (5/11/2011)
May 11, 2011 at 8:39 am
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.
May 11, 2011 at 8:35 am
JoeS 3024 (5/11/2011)
May 11, 2011 at 8:34 am
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...
May 11, 2011 at 8:26 am
ilker.cikrikcili (5/11/2011)
Ninja's_RGR'us (5/11/2011)
May 11, 2011 at 8:15 am
The size of the code of the view in bytes in the system table of the db.
So NO :-).
May 11, 2011 at 8:11 am
GilaMonster (5/11/2011)
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...
May 11, 2011 at 8:10 am
If it works with exec it will work with execute_sql.
You still have mystery to solve here!
May 11, 2011 at 8:08 am
kr.nithin (5/11/2011)
All the Indexes are non-unique & non-clustered.
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...
May 11, 2011 at 8:02 am
stevefromOZ (5/11/2011)
ROTFL you just couldn't leave it alone.... LOL
Immortality :alien:
May 11, 2011 at 8:01 am
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).
May 11, 2011 at 7:56 am
GilaMonster (5/11/2011)
Ninja's_RGR'us (5/11/2011)
DBCC CHECKDB('db-name') WITH TABLERESULTS, NO_INFOMSGS, ALL_ERRORMSGSSeconded, though personally I prefer the output without TableResults.
No backup? Someone's not doing their job...
Ha sorry, I just copied that from my daily...
May 11, 2011 at 7:55 am
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...
May 11, 2011 at 7:53 am
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.
May 11, 2011 at 7:50 am
Viewing 15 posts - 6,226 through 6,240 (of 18,926 total)