Showing posts with label experts. Show all posts
Showing posts with label experts. Show all posts

Monday, March 26, 2012

how to change password?

Dear experts,
i'm getting problem with sql server 2000. actually i changed the service from automatic to manual, right from that day,sql server is not working on my machine.when i checkd in the properties of sql server registration, it is showing some around 8 letter password. actually i will connect with sa and password sa.

where should i change the password? is there any other solution?

or is it better to uninstall and install again? if so what about my databases?

please help me in this regardHello vinod,

Go to the folder security;
Double click on the user;
Change the password (don't forget it!!!)
Pressing on the Ok button;
Repeat the password.

In principle, if you press as password of only one character, for security reasons sqlserver 2000 will show you as password 10 stars.

For testing create a new user and change the password.

Good luck,
Michelle.|||on 'edit sql registration properties' window, use windows authentication first. after u've logon, change the password on Security->Logins section.

Sunday, February 19, 2012

How to build a 10 best topcount...?

I'm beginer. I want to build a 10 best brands unit sales in (Foodmart database). where do I start?(From sales cube or shared dimension), pls experts told how to do it?

Use Topcount MDX function.

For example

SELECT TopCount
({[Geography].[Geography].[City].Members
*[Date].[Fiscal].[Fiscal Year].[FY 2003]}
, 5
, [Measures].[Reseller Sales Amount]
) ON 0,
[Product].[Product Categories].Bikes ON 1
FROM [Adventure Works]

See some more

http://msdn2.microsoft.com/en-us/library/ms144792.aspx

http://cwebbbi.spaces.live.com/PersonalSpace.aspx?_c11_blogpart_blogpart=blogview&_c=blogpart&partqs=amonth%3D5%26ayear%3D2005

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

How to build a 10 best topcount...?

I'm beginer. I want to build a 10 best brands unit sales in (Foodmart database). where do I start?(From sales cube or shared dimension), pls experts told how to do it?

Use Topcount MDX function.

For example

SELECT TopCount
({[Geography].[Geography].[City].Members
*[Date].[Fiscal].[Fiscal Year].[FY 2003]}
, 5
, [Measures].[Reseller Sales Amount]
) ON 0,
[Product].[Product Categories].Bikes ON 1
FROM [Adventure Works]

See some more

http://msdn2.microsoft.com/en-us/library/ms144792.aspx

http://cwebbbi.spaces.live.com/PersonalSpace.aspx?_c11_blogpart_blogpart=blogview&_c=blogpart&partqs=amonth%3D5%26ayear%3D2005

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.