March 20, 2008 at 2:10 am
hello,
you can see what the analyser said to me :
Database Name ANSI_NULLS ANSI_PADDING_ENABLED ANSI_WARNINGS ARITHABORT CONCAT_NULL_YIELDS_NULL QUOTED_IDENTIFIERS NUMERIC_ROUNDABORT Result
[Recommended Settings] ON ON ON ON ON ON OFF -
aloes_dev OFF OFF OFF OFF OFF OFF OFF Failed
i want to know what is the problem ? what is the solution ?
French Geek.
http://blog.developpez.com/ylarvor
I work my english 🙂
March 21, 2008 at 2:39 pm
What query did you execute to get these results? Are you expecting different results? What are you trying to accomplish with this output?
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
March 21, 2008 at 3:31 pm
for obtain this result, i use the best practice analyser 2000 who said what problems have your database.
my database aloes setting isn't good. why ? what this parameter can do wrong ? how change my parameter ? is it possible to change the parameter now with data in the database ?
French Geek.
http://blog.developpez.com/ylarvor
I work my english 🙂
March 24, 2008 at 8:18 am
Yann,
Can you send the output of the entire Best Practices Analyzer Report?
To do this:
Open the Best Practices Analyzer.
On the left column, go to "Compliance Reports".
Open your Report.
On the bottom of the screen there should be a icon labeled "Copy Report".
Click the "Copy Report" Icon.
Go to the "Start" button in Windows, choose "Run", Type in: Notepad.exe .
Once Notepad is open, go to the Edit Menu, choose "Paste". The information from the Report should write into Notepad.
Save the file with a .txt extension.
Post the file to this forum.
We should be able to review the output and give some advice, based on the findings within the file.
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
March 24, 2008 at 8:22 am
thanks for your answer. I do that tomorow at work.
French Geek.
http://blog.developpez.com/ylarvor
I work my english 🙂
March 25, 2008 at 4:24 am
(-)Database SQL Options Database Administration Rule Information
Score Result Friendly Name Description
Non Compliance (local)\Aloes_dev One or more databases failed the scan. Database SQL Options should be configured as recommended to remove deprecated behaviors, be ANSI compliant, and be able to leverage the full feature set.
Scan Details
French Geek.
http://blog.developpez.com/ylarvor
I work my english 🙂
March 25, 2008 at 7:36 am
Yann,
We are getting closer. Open your Compliance Report and scroll down to the "(-)Database SQL Options" entry. Under the column "Description" there will be a blue link for "Scan Details" Click the link and it will open a new window. On my system, the window is wider than my screen. I had to resize the window so that I could see all of the information. I have attached a screen shot of that screen on a test database server, within a Word document for comparison.
The top row of data is the recommended setting, rows of data below the first show the options for your databases. The right most column displays whether or not the current database option passed the scan.
Keep me posted on your progress.
Best Regards,
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
March 25, 2008 at 11:49 am
hello,
the screen said this
[Recommended Settings] ON ON ON ON ON ON OFF -
aloes_dev OFF OFF OFF OFF OFF OFF OFF Failed
ok, i change the settings.
French Geek.
http://blog.developpez.com/ylarvor
I work my english 🙂
March 25, 2008 at 11:52 am
Yann,
I believe that answers your original question. Is there anything else you need assistance with in your Report?
Regards,
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
March 25, 2008 at 12:05 pm
i change the settings tomorrow on the test database and i will look if any problems appear.
Thanks for your time spend...
Yann.
French Geek.
http://blog.developpez.com/ylarvor
I work my english 🙂
March 25, 2008 at 12:13 pm
Yann,
Ne rien.
(My wife translated for me.)
Regards,
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
March 26, 2008 at 5:03 am
i do that :
ALTER DATABASE Aloes_dev SET ANSI_NULLS ON,
ANSI_PADDING ON,
ANSI_WARNINGS ON,
ARITHABORT ON,
CONCAT_NULL_YIELDS_NULL ON,
QUOTED_IDENTIFIER ON,
NUMERIC_ROUNDABORT OFF;
now, i hope their is no problems on the dev database.
bye.
French Geek.
http://blog.developpez.com/ylarvor
I work my english 🙂
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply