Viewing 15 posts - 41,551 through 41,565 (of 49,562 total)
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
Is the database you're running it from in compat mode 90? If, say, you're running it from master and using 3-part names to refer to the proc, then it will...
January 20, 2009 at 1:23 pm
homebrew01 (1/20/2009)
But, if they were critical, what would be the best method to recover ?
Restore the backup. The preferred solution to any such form of disaster is to...
January 20, 2009 at 1:19 pm
Andrew Gothard (1/20/2009)
Well, that depends largely on the attitude of the OP, Gail.
What does? The solution to exact specs or the advice about driving off a cliff? Or something else?
January 20, 2009 at 1:16 pm
Can you please load up management studio or query analyser and test the query out there.
January 20, 2009 at 1:12 pm
Chris Harshman (1/20/2009)
January 20, 2009 at 1:10 pm
S Hodkinson (1/20/2009)
I shall leave the developer to the attentions of senior management.
😀
January 20, 2009 at 6:56 am
pat (1/19/2009)
it is only numbers and integer it does not contains text!!numbers from 1 to atleast 55000
Thanks
Jeff's not asking about the col1 column. Are there any other columns in the...
January 20, 2009 at 6:30 am
Check the permissions on the file. Sometimes when you detach a database file, it looses all permissions. No idea why. Take ownership and then add permissions for the administrators back.
If...
January 20, 2009 at 6:25 am
You forgot one. http://www.sqlskills.com/blogs/paul/
January 20, 2009 at 6:12 am
Viewing 15 posts - 41,551 through 41,565 (of 49,562 total)