How to manage cube by program

Can we used codes Visual.dot to manage cube?
yes, you can use the DSO interfaces to manage your cubes.
Look at the DSOXml program (on the MS we bsite) to see a sample.
"ad" <ad@.wfes.tcc.edu.tw> a crit dans le message de news:
OI6EO9uvEHA.3080@.TK2MSFTNGP12.phx.gbl...
> Can we used codes Visual.dot to manage cube?
>
|||http://www.microsoft.com/downloads/d...DisplayLang=en
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:uZ$K2R1vEHA.2600@.TK2MSFTNGP09.phx.gbl...
> yes, you can use the DSO interfaces to manage your cubes.
> Look at the DSOXml program (on the MS we bsite) to see a sample.
> "ad" <ad@.wfes.tcc.edu.tw> a crit dans le message de news:
> OI6EO9uvEHA.3080@.TK2MSFTNGP12.phx.gbl...
>

How to manage cube by program

Can we used codes Visual.dot to manage cube?yes, you can use the DSO interfaces to manage your cubes.
Look at the DSOXml program (on the MS we bsite) to see a sample.
"ad" <ad@.wfes.tcc.edu.tw> a crit dans le message de news:
OI6EO9uvEHA.3080@.TK2MSFTNGP12.phx.gbl...
> Can we used codes Visual.dot to manage cube?
>|||http://www.microsoft.com/downloads/...&DisplayLang=en
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:uZ$K2R1vEHA.2600@.TK2MSFTNGP09.phx.gbl...
> yes, you can use the DSO interfaces to manage your cubes.
> Look at the DSOXml program (on the MS we bsite) to see a sample.
> "ad" <ad@.wfes.tcc.edu.tw> a crit dans le message de news:
> OI6EO9uvEHA.3080@.TK2MSFTNGP12.phx.gbl...
>sql

how to manage concurrency between multiple, disconnected clients

I have a system use MS SQL 2005 & .NET 2.0, my tables don't have rowversion, but I heard SQL 2005 manage a rowversion by itself, can I use this to do a "ConflictDetection".

All I try to do is I want to get a error when I try to update a row which been modified by someone else after I read row.

Thanks.

I have never used SQL Server 2005 timestamp field which is what you are referring to as the row version. This is an autoincrementing field when a change is detected and is useful in preventing dirty writes.

I have used this practice in managing phantom data back with SQL Server 2000 just by adding a column of type INT and incrementing it each time the record is changed. Basically this is how it works, when I retrieve the record, I get a version of 1, at the same time another person gets the same record with version 1 as well. This person then updates the record causing it to increment to 2. In the meantime, I decide to update the record as well, your application or database should compare the version number you have which is 1 with the current version number at the database, if it is the same then allow update as this mean no changes were detected. In this case the version is at 2 which means the copy of the data at version 1 when i retrieved it is stale and you would alert the user that either they cannot save until they do a refresh or inform them if the choose to proceed, data will be lost.

Using row versions is optimistic locking as many people can read the same record.

You can also use pessimistic looking by locking the record once you have it. You can do this by using Transactions in .NET (System.Data.SqlClient.Transaction) and specify the Isolation levels.

How to manage click-through

How will I possibly do click through on this type of chart when basically I'll have to bring in just Grand Total values to do what they want to do here in this mock-up:

SSRS 2005

Expected/Desired Outcome (user drew this using Excel and later wants click-through capability through SSRS 2005 on the bars later on):

http://www.webfound.net/chart3.jpg

I don't see how this is possible, can y ou shed some light? because basically what I'll have to do to get that few of bars is literally bring in just Grand Totals for the series....static Grand Totals from my dataset's stored proc calculation since I cannot perform really a GT by using SUM in the expressions for any fields in the chart or I'll get an error

Hi,

In SSRS 2005 charts you can do the click through. In the chart layout. Just go to "Drop Data fields here" right click on the button for properties and on the Action tab you can select Jump to report.

Before that you need to create a seperate report so that when you click on the value this particular report comes up.

Any doubts let me know.

Amarnath.

|||

thanks much. What about infinite click-through?

Can I even create charts that do this just like inifinte click-through for reports using models?

How to manage all the SqlNK versions at the same time?

Hi everyone,

Nowadays, we've got four sql versions running around: 6.5, 7.0, 2000 and 2005.

If you try attach from Enterprise Manager 2005 servers it doesn't allow you because of 2005 uses SMO instead of DMO.

If you try attach from Management Studio 6.5 or 7.0 servers it doesn't allow you too.

We'd like to have from the same place a tool for all of them. Is it possible?

Thanks in advance,

I have client tools installed for SQL 6.5, 2000 & 2005 in order to manage our environment that is a mixture of SQL 6.5 to 2005 versions, I have no problem in having 3 of them and using at same time.

Could you please explain what you mean by 'if you try to attach....'.

|||

Hi Staya,

I meant, when you do this action: "New Sql Server Registration" from your client.

Yeah, I know, I can open three clients in my own workstation without problems.

I'm talking about that you can't attach from your Management Studio (2005) 7.0 or 6.5 clients.

Beyond of this, from Enterprise Manager (2000) you can attach any Sql Server 2005 because of sql2k uses DMO library instead of SMO (which is native for 2005).

Ok, you could do it from Query Analyzer.

|||I can connect to any of SQL 2k instances at my end using SSMS and check what is the service pack of those SQL instances that are in version 2000. Even the query analyzer in SQL 2005 should be able to connect to SQL 2000 instnaces.|||

Yeah, don't worry.

Idea was that we might have available an unique tool for see all of them.

My idea is maybe something crooked.

|||I believe SSMS is good one to go, but due to the limitations on backward compatibility you might not get what you want. So in this case you need to have 2 or 3 versions of SQL tools to continue the work. I'm sure there is a opportunity for a third party company to develop such tool.

how to manage a DTS Package usin Asp.net

Hi

How i can manage a DTS Package usin Asp.net

Hi,

R u looking for DTS Packages or SSIS Packages. For any SSIS package you can execute it from .Net Code using the given Below Method

1. Name Space to Include

using Microsoft.SqlServer.Dts.Runtime;

2. Create a Package Variable in constructor it takes FileName of the DTSX Package (SSIS Package ). You can explore this class. It has a execute method

Hope this will help

Satya

how to manage 16 digit number

is there any datatye that can accept 16 digit number

bit type is stored in 1 bit,

tinyint in 1byte,

smallint in 2 byte,(16bit ,I guess this is what you want)

int in 4 byte,

bigint in 8 byte

|||

sorry it is not 16 bit number it is 16 digit number like 1234567891234567

|||See the BOL for BIGINT:

bigint

-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)

8 Bytes

HTH, Jens Suessmeyer.

http://www.sqlserver2005.desql