Viewing 15 posts - 18,091 through 18,105 (of 19,564 total)
rspskumar-704119 (1/17/2010)
Also disable local security policy on your machine.
Typically not. But you will need to explain what you mean here. Disabling the local security policy could leave your...
January 17, 2010 at 7:08 pm
Please post table scripts, index definitions, and sample data. Also, please provide a sample of the output you are seeing, and the desired output.
January 16, 2010 at 10:36 pm
Thanks. That is what I thought.
January 16, 2010 at 1:08 pm
Jeff Moden (1/16/2010)
January 16, 2010 at 12:37 pm
GilaMonster (1/16/2010)
It's not a problem with 10...
January 16, 2010 at 12:35 pm
Thanks Gail for finishing this one up and explaining in great detail.
January 16, 2010 at 12:31 pm
GilaMonster (1/16/2010)
CirquedeSQLeil (1/15/2010)
Potentially lost. Data may be lost - it depends on how bad the corruption is.
Will be lost.
If the minimum level to repair is repair_allow_data_loss,...
January 16, 2010 at 12:26 pm
crainlee2 (1/15/2010)
And thanks for your indisputable reply, Gail. It will end all debate on the subject. In answer to your "Why?" question, it's because this particular...
January 15, 2010 at 9:31 pm
Jeff Moden (1/15/2010)
CirquedeSQLeil (1/15/2010)
January 15, 2010 at 9:28 pm
This article may be of use. That, and this article[/url]. Gail delves into comparing the differences of an inner join v. in and in v. exists. Though...
January 15, 2010 at 6:06 pm
Go for the combination. A nightly sp_updatestats followed up by a weekly or monthly fullscan.
January 15, 2010 at 5:55 pm
Is the Browser service running?
Can you connect to it by IpAddress/Port?
Any additional error info from the Application Event log?
January 15, 2010 at 5:52 pm
Winston,
Try doing it as Jeff has just explained. Create multiple procs, from one of which you will call the other. I think that will probably satisfy the issue...
January 15, 2010 at 5:32 pm
Viewing 15 posts - 18,091 through 18,105 (of 19,564 total)