DR for Crystal Enterprise and Business Objects

Have to build DR solution and subj is a part of it.

Maybe some one has done it already… share the experience please.

Dr in my case will between 2 different data centers, replication is san 2 san so on other side I have a warm standby that does not see san disks and will become active if and only if the primary data center is down, windows domain is the same, ip addresses, names of the servers are different. How a cluster will behave is interesting as well (I mean CE is on cluster, not geo distributed cluster).

I have CE90. I’m talking to their tech support that seems to be outsourced, they didn’t really produce in 5 days anything more then a part of their own documentation in pdf format for CE version I do not use J…

So I’m wondering maybe somebody had to walk similar path already…

I see you were already involved on the previous thread that discussed some of the general considerations for such SAN replication (it was titled SAN Replication and is at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=465113&SiteID=1). Unfortunately I'm not aware of any specific considerations for CE.

Downloading data into a txt file

Dear All,

I have an application running on my mobile device and the data is stored in the mobile database. So now i am trying to build any application on my pc which upon click should download the data from my mobile database into a local text file. Is there any idea or reference where I can stary working on this ?

DataSet ds = new DataSet();

...

DataAdapter da = new DataAdapter(...);

da.Fill(ds, "table1");

...

da.Fill(ds, "tableN");

ds.WriteXml("LocalTextFile.xml");

If XML is not what you want then write data row by row in the format you want using System.IO namespace.

|||

Dear Ilya,

I would prefer it to be in text file format. The problem what project shall I develop I mean in the visual studio 2005. Should it be windows form or device application ? Because if it is device application it cant run in my desktop rite ? So it should be windows form rite ? Thanks.

|||

Dear Ilya,

I have now build a new console application. So then I add a reference to

System.Data.SqlServerCe; to enable me to connect to the mobile database found in the pda. So when I try to run I get an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". The problem is that on the same machine I can compile my device application which is also using the same reference'System.Data.SqlServerCe. Please correct me if I am doing something wrong here. Another thing is that how must I reference the path to my mobile database in the pda ? I am trying like this I dont know if this is right

Mobile Device/MiniSD Card/MiniSD Card/test1/db1.sdf. Thanks.

|||

Dear All,

I have a problem here. What i exactly want to do it that build a console application where when I connect my pda to my desktop and run the exe file it should be able to transfer the .sdf data into a text file of my local desktop ? Is there any code or reference where can guide me ?

|||Some of the components from www.primeworks-mobile.com should be able to help you.|||

Dear ErikEJ,

I would prefer to write on my own as I cant afford third party software. Hope you can show me some light into it. Thanks.

|||What you are going to want to probably do is copy the database from the device to your desktop, then use the sql ce for the desktop libs (remember you can use sql ce on devices and full blown windows) to read through the database and output . You can accomplish copying the database over through code using the Windows CE RAPI. The full framework as far as I know does not have built-in support for it. So what you would need to do is P/Invoke some functions in the rapi.dll. Luckily somebody has essentially done this, look for the opennetcf's (www.opennetcf.org) desktop communication library. So once you use this to get a copy of the database over to your desktop you can use the sql ce for windows (not wm or ce) libs to connect to your now local copy of the database. Then using a SqlCeDataReader you can just iterate through every record in the database, while reading a record in you can format it however you like then push that into a file using a StreamWriter object.
|||

Dear Steve,

Thank you very much for your kind information. So now I have downloaded the OpenNETCF.Desktop.Communication Library . Now how shall I start ? Shall I start by building a console application ? So must I first manually download the database or the system can do it for me ? I am really at lost can your pls guide me further on this. Thanks once again.

|||If you want to do it as a console application then start there. Then my next step would be to use the Desktop Communication library to programmatically get the database from your device to local computer. The communication library should have came with an example application that you can probably look at to find out how they copy files back and forth. You can look their and do the same thing.
|||

Dear Steve,

Ok I have followed and done accordingly and sucessfully download the sdf file into my desktop. My next problem is that i am not able to connect to downloaded .sdf in the desktop. I am using the same code as I build the windows device application. Can your please tell me wat can be my mistake ? For example I use this

SqlCeConnection conn1 = new SqlCeConnection("Data Source = c:/test1.sdf");

First I got an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". Then I manage to solve "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)". So wat is the possible error on my side ?

So what can be possible error on my side ? Thanks.

|||

Dear Steve,

I am ok with Desktop Communication library. I have already managed to download the database from the device to my local computer. My next step is that how can I from my console application link to the database which I have already downloaded using the said library. Thanks once again.

|||Once you have the sdf file over to you desktop you can use the desktop version of the sqlce data object. I think you need to download the Microsoft SQL Server Mobile 2005 Mobile Edition SDK. Once you have that downloaded and installed it you should be able to add the proper references to the desktop x86 version of the libraries that you need. Then you should be able to connect to the database and use it just like you did on the handheld with the .NET CF. You should be able to just use a SqlCeDataReader object to query the database then read through the returned records and output them using a StreamWriter object to put them into a text file which you can then control the format of.
|||

Dear Steve,

I have already downloaded the microsoft sql server mobile 2005 mobile edition sdk. So I tried to use the SqlCeDataReader and below is the errors I got. Can you please guide me on this ?

SqlCeConnection conn1 = new SqlCeConnection("Data Source = c:/test1.sdf");

First I got an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". Then I manage to solve that problem but got another one "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)". So wat is the possible error on my side ?Thanks.

Downloading data into a txt file

Dear All,

I have an application running on my mobile device and the data is stored in the mobile database. So now i am trying to build any application on my pc which upon click should download the data from my mobile database into a local text file. Is there any idea or reference where I can stary working on this ?

DataSet ds = new DataSet();

...

DataAdapter da = new DataAdapter(...);

da.Fill(ds, "table1");

...

da.Fill(ds, "tableN");

ds.WriteXml("LocalTextFile.xml");

If XML is not what you want then write data row by row in the format you want using System.IO namespace.

|||

Dear Ilya,

I would prefer it to be in text file format. The problem what project shall I develop I mean in the visual studio 2005. Should it be windows form or device application ? Because if it is device application it cant run in my desktop rite ? So it should be windows form rite ? Thanks.

|||

Dear Ilya,

I have now build a new console application. So then I add a reference to

System.Data.SqlServerCe; to enable me to connect to the mobile database found in the pda. So when I try to run I get an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". The problem is that on the same machine I can compile my device application which is also using the same reference'System.Data.SqlServerCe. Please correct me if I am doing something wrong here. Another thing is that how must I reference the path to my mobile database in the pda ? I am trying like this I dont know if this is right

Mobile Device/MiniSD Card/MiniSD Card/test1/db1.sdf. Thanks.

|||

Dear All,

I have a problem here. What i exactly want to do it that build a console application where when I connect my pda to my desktop and run the exe file it should be able to transfer the .sdf data into a text file of my local desktop ? Is there any code or reference where can guide me ?

|||Some of the components from www.primeworks-mobile.com should be able to help you.|||

Dear ErikEJ,

I would prefer to write on my own as I cant afford third party software. Hope you can show me some light into it. Thanks.

|||What you are going to want to probably do is copy the database from the device to your desktop, then use the sql ce for the desktop libs (remember you can use sql ce on devices and full blown windows) to read through the database and output . You can accomplish copying the database over through code using the Windows CE RAPI. The full framework as far as I know does not have built-in support for it. So what you would need to do is P/Invoke some functions in the rapi.dll. Luckily somebody has essentially done this, look for the opennetcf's (www.opennetcf.org) desktop communication library. So once you use this to get a copy of the database over to your desktop you can use the sql ce for windows (not wm or ce) libs to connect to your now local copy of the database. Then using a SqlCeDataReader you can just iterate through every record in the database, while reading a record in you can format it however you like then push that into a file using a StreamWriter object.
|||

Dear Steve,

Thank you very much for your kind information. So now I have downloaded the OpenNETCF.Desktop.Communication Library . Now how shall I start ? Shall I start by building a console application ? So must I first manually download the database or the system can do it for me ? I am really at lost can your pls guide me further on this. Thanks once again.

|||If you want to do it as a console application then start there. Then my next step would be to use the Desktop Communication library to programmatically get the database from your device to local computer. The communication library should have came with an example application that you can probably look at to find out how they copy files back and forth. You can look their and do the same thing.
|||

Dear Steve,

Ok I have followed and done accordingly and sucessfully download the sdf file into my desktop. My next problem is that i am not able to connect to downloaded .sdf in the desktop. I am using the same code as I build the windows device application. Can your please tell me wat can be my mistake ? For example I use this

SqlCeConnection conn1 = new SqlCeConnection("Data Source = c:/test1.sdf");

First I got an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". Then I manage to solve "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)". So wat is the possible error on my side ?

So what can be possible error on my side ? Thanks.

|||

Dear Steve,

I am ok with Desktop Communication library. I have already managed to download the database from the device to my local computer. My next step is that how can I from my console application link to the database which I have already downloaded using the said library. Thanks once again.

|||Once you have the sdf file over to you desktop you can use the desktop version of the sqlce data object. I think you need to download the Microsoft SQL Server Mobile 2005 Mobile Edition SDK. Once you have that downloaded and installed it you should be able to add the proper references to the desktop x86 version of the libraries that you need. Then you should be able to connect to the database and use it just like you did on the handheld with the .NET CF. You should be able to just use a SqlCeDataReader object to query the database then read through the returned records and output them using a StreamWriter object to put them into a text file which you can then control the format of.
|||

Dear Steve,

I have already downloaded the microsoft sql server mobile 2005 mobile edition sdk. So I tried to use the SqlCeDataReader and below is the errors I got. Can you please guide me on this ?

SqlCeConnection conn1 = new SqlCeConnection("Data Source = c:/test1.sdf");

First I got an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". Then I manage to solve that problem but got another one "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)". So wat is the possible error on my side ?Thanks.

download link of Yukon

Hi ,
need a download link of latest build of YUKON
Thanks
ARRExpress edition can be downloaded from
http://www.microsoft.com/downloads/details.aspx?FamilyID=62b348bb-0458-4203-bb03-8be49e16e6cd&displaylang=en.
Developer edition is available for MSDN subscribers.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23KkDrzPBFHA.2640@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> need a download link of latest build of YUKON
> Thanks
> ARR
>

download link of Yukon

Hi ,
need a download link of latest build of YUKON
Thanks
ARR
Express edition can be downloaded from
http://www.microsoft.com/downloads/d...isplaylang=en.
Developer edition is available for MSDN subscribers.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23KkDrzPBFHA.2640@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> need a download link of latest build of YUKON
> Thanks
> ARR
>

download link of Yukon

Hi ,
need a download link of latest build of YUKON
Thanks
ARRExpress edition can be downloaded from
http://www.microsoft.com/downloads/...displaylang=en.
Developer edition is available for MSDN subscribers.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23KkDrzPBFHA.2640@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> need a download link of latest build of YUKON
> Thanks
> ARR
>

Dowload for 8.00.2162?

I've been trying to download the cumulative hotfix in article 904660 (patches
to build 8.00.2162). However, the link on the page is not fiding the file to
download:
http://www.microsoft.com/downloads/d...displaylang=en
Does anyone know where I can download the 904660 cumulative patch? Thanks!
Hotfix 2162 has been removed.
A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
build 2162
http://support.microsoft.com/kb/904660/en-us
CSS (formerly PSS) is working on the replacement hotfix.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> I've been trying to download the cumulative hotfix in article 904660
> (patches
> to build 8.00.2162). However, the link on the page is not fiding the file
> to
> download:
> http://www.microsoft.com/downloads/d...displaylang=en
> Does anyone know where I can download the 904660 cumulative patch? Thanks!
|||Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
trying to use. It leads to a page with the following message: "The download
you requested is unavailable. If you continue to see this message when trying
to access this download, go to the "Search for a Download" area on the
Download Center home page." I can't find it anywhere else. I guess I simply
need to stop pursuing it.
"Geoff N. Hiten" wrote:

> Hotfix 2162 has been removed.
> A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
> build 2162
> http://support.microsoft.com/kb/904660/en-us
> CSS (formerly PSS) is working on the replacement hotfix.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
>
>
|||Read the actual article before clicking on the download link. The page
tells you the hotfix has been removed.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...[vbcol=seagreen]
> Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
> trying to use. It leads to a page with the following message: "The
> download
> you requested is unavailable. If you continue to see this message when
> trying
> to access this download, go to the "Search for a Download" area on the
> Download Center home page." I can't find it anywhere else. I guess I
> simply
> need to stop pursuing it.
> "Geoff N. Hiten" wrote:
|||Aha! I see what you mean now. I usually skip that very first section, becuase
usually it doesn't contain much meat. Sorry for the confusion. Thanks for
your help!
"Geoff N. Hiten" wrote:

> Read the actual article before clicking on the download link. The page
> tells you the hotfix has been removed.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...
>
>

Dowload for 8.00.2162?

I've been trying to download the cumulative hotfix in article 904660 (patches
to build 8.00.2162). However, the link on the page is not fiding the file to
download:
http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
Does anyone know where I can download the 904660 cumulative patch? Thanks!Hotfix 2162 has been removed.
A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
build 2162
http://support.microsoft.com/kb/904660/en-us
CSS (formerly PSS) is working on the replacement hotfix.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> I've been trying to download the cumulative hotfix in article 904660
> (patches
> to build 8.00.2162). However, the link on the page is not fiding the file
> to
> download:
> http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
> Does anyone know where I can download the 904660 cumulative patch? Thanks!|||Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
trying to use. It leads to a page with the following message: "The download
you requested is unavailable. If you continue to see this message when trying
to access this download, go to the "Search for a Download" area on the
Download Center home page." I can't find it anywhere else. I guess I simply
need to stop pursuing it.
"Geoff N. Hiten" wrote:
> Hotfix 2162 has been removed.
> A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
> build 2162
> http://support.microsoft.com/kb/904660/en-us
> CSS (formerly PSS) is working on the replacement hotfix.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> > I've been trying to download the cumulative hotfix in article 904660
> > (patches
> > to build 8.00.2162). However, the link on the page is not fiding the file
> > to
> > download:
> > http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
> >
> > Does anyone know where I can download the 904660 cumulative patch? Thanks!
>
>|||Read the actual article before clicking on the download link. The page
tells you the hotfix has been removed.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...
> Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
> trying to use. It leads to a page with the following message: "The
> download
> you requested is unavailable. If you continue to see this message when
> trying
> to access this download, go to the "Search for a Download" area on the
> Download Center home page." I can't find it anywhere else. I guess I
> simply
> need to stop pursuing it.
> "Geoff N. Hiten" wrote:
>> Hotfix 2162 has been removed.
>> A cumulative hotfix package is available for SQL Server 2000 Service Pack
>> 4
>> build 2162
>> http://support.microsoft.com/kb/904660/en-us
>> CSS (formerly PSS) is working on the replacement hotfix.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
>> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
>> > I've been trying to download the cumulative hotfix in article 904660
>> > (patches
>> > to build 8.00.2162). However, the link on the page is not fiding the
>> > file
>> > to
>> > download:
>> > http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
>> >
>> > Does anyone know where I can download the 904660 cumulative patch?
>> > Thanks!
>>|||Aha! I see what you mean now. I usually skip that very first section, becuase
usually it doesn't contain much meat. Sorry for the confusion. Thanks for
your help!
"Geoff N. Hiten" wrote:
> Read the actual article before clicking on the download link. The page
> tells you the hotfix has been removed.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...
> > Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
> > trying to use. It leads to a page with the following message: "The
> > download
> > you requested is unavailable. If you continue to see this message when
> > trying
> > to access this download, go to the "Search for a Download" area on the
> > Download Center home page." I can't find it anywhere else. I guess I
> > simply
> > need to stop pursuing it.
> >
> > "Geoff N. Hiten" wrote:
> >
> >> Hotfix 2162 has been removed.
> >>
> >> A cumulative hotfix package is available for SQL Server 2000 Service Pack
> >> 4
> >> build 2162
> >> http://support.microsoft.com/kb/904660/en-us
> >>
> >> CSS (formerly PSS) is working on the replacement hotfix.
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior Database Administrator
> >> Microsoft SQL Server MVP
> >>
> >>
> >>
> >> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> >> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> >> > I've been trying to download the cumulative hotfix in article 904660
> >> > (patches
> >> > to build 8.00.2162). However, the link on the page is not fiding the
> >> > file
> >> > to
> >> > download:
> >> > http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
> >> >
> >> > Does anyone know where I can download the 904660 cumulative patch?
> >> > Thanks!
> >>
> >>
> >>
>
>

Dowload for 8.00.2162?

I've been trying to download the cumulative hotfix in article 904660 (patche
s
to build 8.00.2162). However, the link on the page is not fiding the file to
download:
http://www.microsoft.com/downloads/...&displaylang=en
Does anyone know where I can download the 904660 cumulative patch? Thanks!Hotfix 2162 has been removed.
A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
build 2162
http://support.microsoft.com/kb/904660/en-us
CSS (formerly PSS) is working on the replacement hotfix.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> I've been trying to download the cumulative hotfix in article 904660
> (patches
> to build 8.00.2162). However, the link on the page is not fiding the file
> to
> download:
> http://www.microsoft.com/downloads/...&displaylang=en
> Does anyone know where I can download the 904660 cumulative patch? Thanks!|||Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
trying to use. It leads to a page with the following message: "The download
you requested is unavailable. If you continue to see this message when tryin
g
to access this download, go to the "Search for a Download" area on the
Download Center home page." I can't find it anywhere else. I guess I simply
need to stop pursuing it.
"Geoff N. Hiten" wrote:

> Hotfix 2162 has been removed.
> A cumulative hotfix package is available for SQL Server 2000 Service Pack
4
> build 2162
> http://support.microsoft.com/kb/904660/en-us
> CSS (formerly PSS) is working on the replacement hotfix.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
>
>|||Read the actual article before clicking on the download link. The page
tells you the hotfix has been removed.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...[vbcol=seagreen]
> Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
> trying to use. It leads to a page with the following message: "The
> download
> you requested is unavailable. If you continue to see this message when
> trying
> to access this download, go to the "Search for a Download" area on the
> Download Center home page." I can't find it anywhere else. I guess I
> simply
> need to stop pursuing it.
> "Geoff N. Hiten" wrote:
>|||Aha! I see what you mean now. I usually skip that very first section, becuas
e
usually it doesn't contain much meat. Sorry for the confusion. Thanks for
your help!
"Geoff N. Hiten" wrote:

> Read the actual article before clicking on the download link. The page
> tells you the hotfix has been removed.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...
>
>

Does truncate and API Load invalidate statistics

As part of my data warehouse nightly build, I truncate my tables in my
target database.
As example, I find it is much quicker to do a bulk API load of 13M
records and to do an update/insert of 100K rows. I also drop the
indexes before the builds and reindex after. Thats an aside.
What I am wondering is how is this impacting the statistics? Do I need
to update them?
Not well versed on statistics and any data is welcomed.
Thanks
Robrcamarda (robc390@.hotmail.com) writes:

Quote:

Originally Posted by

As part of my data warehouse nightly build, I truncate my tables in my
target database.
As example, I find it is much quicker to do a bulk API load of 13M
records and to do an update/insert of 100K rows. I also drop the
indexes before the builds and reindex after. Thats an aside.
What I am wondering is how is this impacting the statistics? Do I need
to update them?

When an indexes added, statistics based a full scan is added for that
index, so you are fairly safe.

Would could matter is statistics of non-indexed columns. These you lose
when you truncate the tables. These statistics are less essential than
index on indexed columns, but there are queries where they may be useful.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Does the Report Manager use the RS WebService?

If the Report Manager uses the SOAP API to build the website, is there a way to find the code for this? This is a great working sample and I would like to see that code to help in my understanding and building of a proprietary site. There are a lot of snippets of code to show how to do things individually, but when you put them all together, it is very slow (Item Properties, Methods, etc.). //Report Mangaer does use the SOAP API to the Report Server web service, but we don't make the Report Manager source code publicly available.|||

Thanks for the response. If that is the case, I've been looking for good examples for retrieving the Report Name, Description and Parameters. When I piece together from other resources I can get it to work great! HOWEVER, it is very slow, especially the GetProperties Method!

Thanks.