How to browse the history login detail of sqlserver?

Hi all,
I want to ask how to browse the history login detail of
sqlserver.eg:login user name , client ip and login time
thx.Hi
SQL server does not store it, unless you log it specifically though code
into a table.
If you have full auditing on, you can see the date and time of a specific
login (success or failure).
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"zlf" <zlfcn@.hotmail.com> wrote in message
news:Oj$X$xOLFHA.1916@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> I want to ask how to browse the history login detail of
> sqlserver.eg:login user name , client ip and login time
> thx.
>|||Thank you for your help
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> д?:uGD9k3OLFHA.1176@.TK2MSFTNGP12.phx
.gbl...
> Hi
> SQL server does not store it, unless you log it specifically though code
> into a table.
> If you have full auditing on, you can see the date and time of a specific
> login (success or failure).
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "zlf" <zlfcn@.hotmail.com> wrote in message
> news:Oj$X$xOLFHA.1916@.TK2MSFTNGP12.phx.gbl...
>

HOW to browse KPI's Result Data through ADOMD.NET?

Hi,

My question is how to browse KPI's Result through ADOMD.NET? I mean to get a KPI's Result Data, not get the metadata of KPI, not get the KPI's Value Property(String) either.

I see the MSDN said about AdomdDataReader, but it doesnt tell how to get a KPI's Value.

I guess, I need to get KPI's metadata first, and get a KPI's Value Property, that's a MDX, you know. Then I bring the MDX to the AS server, and get the result. Is it right?

But, if so, when i want to slice on a dimension when I check the KPI's result, how could I do? I have got a KPI's Value Property MDX, then I need to modify the MDX to add the dimension slice to it manually?

Thanks.

Via an MDX query, you can retrieve the various values associated with a KPI using the KPIValue(), KPIGoal(), KPIStatus(), and KPITrend() functions. Here's the link in Books Online for hte KPIValue() function, for example:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/mdxref9/html/c4f8532c-4c24-4ad5-8847-4522511e0039.htm

If you wanted to slice the KPI values by a given dimension value, you'd just add that to your MDX statement. For example, the following MDX query returns various KPI values for each of the quarters in 2004:

SELECT

{ KPIValue("Internet Revenue"),

KPIGoal("Internet Revenue"),

KPIStatus("Internet Revenue"),

KPITrend("Internet Revenue")

} ON Columns,

Descendants

( { [Date].[Fiscal].[Fiscal Year].&[2004]

}, [Date].[Fiscal].[Fiscal Quarter]

) ON Rows

FROM [Adventure Works]

If you wanted to slice that so that you only get the KPI values filtered by the product category "Bikes", then you could do this:

SELECT

{ KPIValue("Internet Revenue"),

KPIGoal("Internet Revenue"),

KPIStatus("Internet Revenue"),

KPITrend("Internet Revenue")

} ON Columns,

Descendants

( { [Date].[Fiscal].[Fiscal Year].&[2004]

}, [Date].[Fiscal].[Fiscal Quarter]

) ON Rows

FROM [Adventure Works]

WHERE

([Product].[Category].[Bikes])

HTH,

Dave F.

|||Thank you very much! This is what I just want.

How to browse INFORMATION_SCHEMA in Enterprise Manager

Dear all,
I try to (select * from information_schema.columns). It
works ok in query analyzer. But how can I access the information_schema
tables in Enterprise Manager? I try to browse all database, but I
cannot located where is information_schema located in? i.e. Which
database the information_schema is located in that I can browse in
Enterprise Manager?
ThanksI assume you are on 2000? These views only physically exists in the master d
atabase, so unless it is
master you want to look at, EM won't work. Use Query Analyzer and type your
queries instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"hon123456" <peterhon321@.yahoo.com.hk> wrote in message
news:1145342246.110319.286500@.u72g2000cwu.googlegroups.com...
> Dear all,
> I try to (select * from information_schema.columns). It
> works ok in query analyzer. But how can I access the information_schema
> tables in Enterprise Manager? I try to browse all database, but I
> cannot located where is information_schema located in? i.e. Which
> database the information_schema is located in that I can browse in
> Enterprise Manager?
> Thanks
>

How to browse for folder on SQL Server's machine?

Hi!
I know there is xp_dirtree, xp_subdirs, xp_fixeddrives procedures which
allows me to write a folder select dialog. But i have seen such dialog
somewhere in one of installers. Unfortunately I dont remember in what
installer.
I dont want to reinvent a wheel. So my question is: may be there is method
somewhere in SQL Server or in SQL-DMO or in DTS which implements a folder
selection dialog based on these stored procedures?T-SQL, DMO and DTS do not present the user with GUI objects. They provide
information, and your application must present that information is a dailog.
"Igor Solodovnikov" <IgorSolodovnikov@.discussions.microsoft.com> wrote in
message news:op.suvw7dy0n8ihmu@.iw2k.helpmicro.local...
> Hi!
> I know there is xp_dirtree, xp_subdirs, xp_fixeddrives procedures which
> allows me to write a folder select dialog. But i have seen such dialog
> somewhere in one of installers. Unfortunately I dont remember in what
> installer.
> I dont want to reinvent a wheel. So my question is: may be there is method
> somewhere in SQL Server or in SQL-DMO or in DTS which implements a folder
> selection dialog based on these stored procedures?|||Ok, thank you for information. I must ask my question another way: Do you
know any library implementing such a dialog?

> T-SQL, DMO and DTS do not present the user with GUI objects. They provide
> information, and your application must present that information is a
> dailog.
> "Igor Solodovnikov" <IgorSolodovnikov@.discussions.microsoft.com> wrote in
> message news:op.suvw7dy0n8ihmu@.iw2k.helpmicro.local...
>|||You have several options depending on what application development tool you
are using. This perhaps more a C# or Visual Basic question than SQL Server.
There is the Win32 API call SHBrowseForFolder
http://support.microsoft.com/defaul...kb;en-us;179497
How to write a managed C# wrapper for the API dialog call:
http://support.microsoft.com/defaul...kb;en-us;306285
Here is a Visual Basic sample:
http://www.vbexplorer.com/VBExplore...file_dialog.asp
I also think there is a method of the File System Object called
GetFolderName
http://msdn.microsoft.com/library/d...objectmodel.asp
"Igor Solodovnikov" <IgorSolodovnikov@.discussions.microsoft.com> wrote in
message news:op.suv0e6u4n8ihmu@.iw2k.helpmicro.local...
> Ok, thank you for information. I must ask my question another way: Do you
> know any library implementing such a dialog?
>
>|||As I mentioned in my original posting I can implement such dialog using
xp_dirtree, xp_subdirs, xp_fixeddrives procedures. But SQL Server's
Enterprise Manager already has such dialog. For example if you open
"Attach Database" dialog and then press browse [...] button Enterprise
Manager will show you "Browse For Existing File" dialog. And as you can
see all the path information in that dialog is local to SQL Server's
machine. This is what SHBrowseForFolder cannot do for you because
SHBrowseForFolder always shows paths relative to local machine.
My question is: Is there any way to reuse that Enterprise Manager's
"Browse For Existing File" dialog? Or I am obliged to reinvent it?
On Tue, 02 Aug 2005 19:30:46 +0300, JT <someone@.microsoft.com> wrote:

> You have several options depending on what application development tool
> you
> are using. This perhaps more a C# or Visual Basic question than SQL
> Server.
> There is the Win32 API call SHBrowseForFolder
> http://support.microsoft.com/defaul...kb;en-us;179497
> How to write a managed C# wrapper for the API dialog call:
> http://support.microsoft.com/defaul...kb;en-us;306285
> Here is a Visual Basic sample:
> http://www.vbexplorer.com/VBExplore...file_dialog.asp
> I also think there is a method of the File System Object called
> GetFolderName
> http://msdn.microsoft.com/library/d...objectmodel.asp
>
> "Igor Solodovnikov" <IgorSolodovnikov@.discussions.microsoft.com> wrote in
> message news:op.suv0e6u4n8ihmu@.iw2k.helpmicro.local...
>

How to browse cube in Excel?

Hi, all here,

Could anyone tell me how can I browse cube data in Excel?

Thanks a lot in advance for any guidance and help.

There are two options I know of.

One is Microsofts Free giveaway Data Access Tool. Only works with Excel 2002 onwards I think, get it at http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en home page for product is at http://www.microsoft.com/office/solutions/accelerators/exceladdin/default.mspx

Another is XLCubed www.xlcubed.com which is similar but far more powerful and friendly. This works with Excel 2000 SP2 onwards

Most of the Big front end tools like Cognos and proclarity have Excel plugins but they tend to be fairly expensive. XL3 is about ￡300 a seat and they do 30 day trial versions. We had four or five trials in a row before we settled on it as a final solution.

The MS tool is useable but not for anything too complicated. Both are really easy to pick up if your Excel users know anything about pivot tables.

regards

Steve

|||Hi, Steve, thanks a lot.|||

Hi,

I have downloaded and installed the add-in. When I try to connect to the database I get an error with Initialization of the data source failed.

Can one one help me on this?

cheers

Josh

How to browse cube in Excel?

Hi, all here,

Could anyone tell me how can I browse cube data in Excel?

Thanks a lot in advance for any guidance and help.

There are two options I know of.

One is Microsofts Free giveaway Data Access Tool. Only works with Excel 2002 onwards I think, get it at http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en home page for product is at http://www.microsoft.com/office/solutions/accelerators/exceladdin/default.mspx

Another is XLCubed www.xlcubed.com which is similar but far more powerful and friendly. This works with Excel 2000 SP2 onwards

Most of the Big front end tools like Cognos and proclarity have Excel plugins but they tend to be fairly expensive. XL3 is about ￡300 a seat and they do 30 day trial versions. We had four or five trials in a row before we settled on it as a final solution.

The MS tool is useable but not for anything too complicated. Both are really easy to pick up if your Excel users know anything about pivot tables.

regards

Steve

|||Hi, Steve, thanks a lot.|||

Hi,

I have downloaded and installed the add-in. When I try to connect to the database I get an error with Initialization of the data source failed.

Can one one help me on this?

cheers

Josh

How to browse a cube from another project?

Hi, all here,

I have question about how can I browse cube from another project in my current project then?

You can use SQL Server Management Studio to broswe any cube on your server.

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

How to browse *.data file?

We know that when we execute RS report,
it would be generated a *.data file.
Can we browse *.data file?
Using Notepad? Office?
Thanks for any advice!
AngiI haven't looked on the server but I am pretty sure that this .data file is
a cache of data used for when you are developing. It is just the latest data
so while developing. You can delete it at any time and it will be recreated
the next time you are previewing the report. What is your reason/concern
about this file?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Angi" <enchiw@.msn.com> wrote in message
news:%232PR2uAEGHA.2300@.TK2MSFTNGP15.phx.gbl...
> We know that when we execute RS report,
> it would be generated a *.data file.
> Can we browse *.data file?
> Using Notepad? Office?
> Thanks for any advice!
> Angi
>|||Thanks Bruce!
The *.data file that I mentioned is on the client generate by Report
Designer.
Your description just as I think.
Cause the customer found her data on report designer and report manager
dosen't synchronize.
Report designer less 1, so she thought can browse the *.data to see what's
going on and why less 1.
I have the same problem on Reporting Service first version or SP1 version, I
forgot.
If I browse the parameter 2005/11 and generate 10 records then continue to
browse the 2005/12 and generate records.
If 2005/12 has 12 records, but cause first browse 2005/11 then 2005/12 just
present 10 records not 12 records!
Did you ever met this situation on earlier reporting services version?
After upgrade to SP1 or SP2 the problem be solved.
So, I think my customer has not upgrade to SP2 and called her to upgrade.
Angi
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:ONPAcuBEGHA.532@.TK2MSFTNGP15.phx.gbl...
>I haven't looked on the server but I am pretty sure that this .data file is
>a cache of data used for when you are developing. It is just the latest
>data so while developing. You can delete it at any time and it will be
>recreated the next time you are previewing the report. What is your
>reason/concern about this file?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Angi" <enchiw@.msn.com> wrote in message
> news:%232PR2uAEGHA.2300@.TK2MSFTNGP15.phx.gbl...
>> We know that when we execute RS report,
>> it would be generated a *.data file.
>> Can we browse *.data file?
>> Using Notepad? Office?
>> Thanks for any advice!
>> Angi
>|||The way it works is if no parameter changes then the designer continues to
use the data file. So if you have a report with no parameters, after the
first time previewing it, it will not hit the database again. You can always
manually delete the .data file which will cause the database to be hit. If
you have a parameter, then just change one of the parameters and a new .data
file will be generated. I am not aware of anything changing in this area
with the service packs.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Angi" <enchiw@.msn.com> wrote in message
news:%23n1f%239DEGHA.3892@.TK2MSFTNGP10.phx.gbl...
> Thanks Bruce!
> The *.data file that I mentioned is on the client generate by Report
> Designer.
> Your description just as I think.
> Cause the customer found her data on report designer and report manager
> dosen't synchronize.
> Report designer less 1, so she thought can browse the *.data to see what's
> going on and why less 1.
> I have the same problem on Reporting Service first version or SP1 version,
> I forgot.
> If I browse the parameter 2005/11 and generate 10 records then continue to
> browse the 2005/12 and generate records.
> If 2005/12 has 12 records, but cause first browse 2005/11 then 2005/12
> just present 10 records not 12 records!
> Did you ever met this situation on earlier reporting services version?
> After upgrade to SP1 or SP2 the problem be solved.
> So, I think my customer has not upgrade to SP2 and called her to upgrade.
> Angi
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com>
> ¼¶¼g©ó¶l¥ó·s»D:ONPAcuBEGHA.532@.TK2MSFTNGP15.phx.gbl...
>>I haven't looked on the server but I am pretty sure that this .data file
>>is a cache of data used for when you are developing. It is just the latest
>>data so while developing. You can delete it at any time and it will be
>>recreated the next time you are previewing the report. What is your
>>reason/concern about this file?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Angi" <enchiw@.msn.com> wrote in message
>> news:%232PR2uAEGHA.2300@.TK2MSFTNGP15.phx.gbl...
>> We know that when we execute RS report,
>> it would be generated a *.data file.
>> Can we browse *.data file?
>> Using Notepad? Office?
>> Thanks for any advice!
>> Angi
>>
>