Viewing 15 posts - 41,551 through 41,565 (of 49,571 total)
Why would it need permissions in tempDB? Temp table usage doesn't require any permissions in tempDB, so unless there're doing something like creating permanent tables in tempDB (which the permissions...
January 21, 2009 at 6:57 am
And just note there is a 16 column/900 byte limit on index key size.
Edit: 16, not 60.
January 21, 2009 at 6:52 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
January 21, 2009 at 6:50 am
Disclaimer: Do not do this on a production server. Do not do this to any database that you care about. If you want to play, do so on a SQL...
January 21, 2009 at 6:33 am
xanthos (1/21/2009)
Update:I've restored last nights backup of master as a userdatabase and run DBCC CHECKDB ALLOW_DATA_LOSS.
This solves the consistency errors.
Yes, it's fixed the corruption, but do you know...
January 21, 2009 at 6:30 am
Andrew Gothard (1/21/2009)
the advice about driving off a cliff
Depends. On occasion I have given such a warning even though the OP was short of manners. It's got me sworn at...
January 21, 2009 at 6:21 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic640326-149-1.aspx
January 21, 2009 at 12:17 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic640430-147-1.aspx
January 21, 2009 at 12:13 am
ashepard (1/20/2009)
A temp tables are formed for rows fetched
They are?
January 20, 2009 at 11:56 pm
Please post table definitions, index definitions and the execution plan (saved as a .sqlplan file, zipped and attached)
January 20, 2009 at 2:34 pm
Oh, and the value passed to @LocaleID shouldn't have brackets around it. A couple lines below the other one.
The new error is saying the XML is invalid. You'll...
January 20, 2009 at 2:29 pm
mlang (1/20/2009)
EXEC Program_UpdateOptionSetting @OptionID = @optionID,u5@optionTypeID = @optionTypeID,
@ObjectID = null,
@Value = @valueID,
@LocaleID = (31001),
@CallingUserID = null,
@CallingWorkstationName = null,
@Success = null;
I don't think that u5 is supposed to be there.
If you...
January 20, 2009 at 2:18 pm
Is your database case sensitive? What's the DB collation?
I know there are some strange behaviours around hierarchyid in case sensitive databases.
January 20, 2009 at 2:01 pm
It should be in the default trace. I think Audit Server Shutdown is an event (haven't checked though). The function to get trace data into a table is fn_trace_gettable
The other...
January 20, 2009 at 1:36 pm
Do you have a backup of master? repair is not the recommended solution, especially not for a system database.
Can you please run the following, copy the results to a text...
January 20, 2009 at 1:25 pm
Viewing 15 posts - 41,551 through 41,565 (of 49,571 total)