"Michel" <Michel@discussions.microsoft.com> wrote in message
news:0BD0F388-ABF7-4EC2-954F-C6DC63EF9BD8@microsoft.com...
> Dear Mr. Vaughn,
>
> Thank you very much for your help.
> I tried the whole day to access the Hitchhiker's Guide support site.
> Unfortunately, I only got a "HTTP error 550" or a "Server Error in '/'
> Application" with the following comment:
>
> Runtime Error
> Description: An application error occurred on the server. The current
> custom
> error settings for this application prevent the details of the application
> error from being viewed remotely (for security reasons). It could,
> however,
> be viewed by browsers running on the local server machine.
>
> Details: To enable the details of this specific error message to be
> viewable
> on remote machines, please create a <customErrors> tag within a
> "web.config"
> configuration file located in the root directory of the current web
> application. This <customErrors> tag should then have its "mode" attribute
> set to "Off".
>
>
> <!-- Web.Config Configuration File -->
>
> <configuration>
> <system.web>
> <customErrors mode="Off"/>
> </system.web>
> </configuration>
>
>
> Notes: The current error page you are seeing can be replaced by a custom
> error page by modifying the "defaultRedirect" attribute of the
> application's
> <customErrors> configuration tag to point to a custom error page URL.
>
>
> <!-- Web.Config Configuration File -->
>
> <configuration>
> <system.web>
> <customErrors mode="RemoteOnly"
> defaultRedirect="mycustompage.htm"/>
> </system.web>
> </configuration>
>
> I use Microsoft Internet Explorer 7.0.5730.11.
>
> I wll have to wait until these matters are fixed.
>
> Many thanks and greetings from Brugge (Bruges - Belgium),
>
> Michel
>
>
>
> "William (Bill) Vaughn" wrote:
>
>> I have posted an updated example on the Hitchhiker's Guide support site.
>> As
>> a registered user you should have full access to the project.
>> Let me know if you have other issues. I'll be writing a more in-depth
>> discussion of the method (to supplement what's already in the book) and
>> post
>> that in the next couple of days. I also expect to publish this whitepaper
>> and part of the code in my regular "First Tuesday" Developer.Com article.
>> Note that the example posted to the readers' side also includes the
>> source
>> code for my SqlCmd class that's designed to parse a text file containing
>> an
>> SQL script and execute it against a selected SqlConnection. This will
>> appear
>> in a future Developer.Com article published at a later date.
>>
>> hth
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> -----------------------------------------------------------------------------------------------------------------------
>> "Michel" <Michel@discussions.microsoft.com> wrote in message
>> news:8519C4F0-F70C-449F-8223-0A6BC6FB853E@microsoft.com...
>> > Dear Mr. Vaughn,
>> >
>> > I bought your extensive book and the only reference to the SqlBulkCopy
>> > method I find in the index refers to pages 527 - 528.
>> > There is a small chapter on the matter, but I do not find any examples
>> > or
>> > code to demonstrate its use.
>> >
>> > On the DVD are some examples but none refer to the SqlBulkCopy method,
>> > as
>> > far as I could see.
>> >
>> > As I am new to all matters regarding SQL Server, can you please point
>> > me
>> > in
>> > the direction where I can find sample code and further information on
>> > how
>> > to
>> > achieve the tasks I described earlier?
>> >
>> > Many thanks and greetings from Brugge (Bruges - Belgium),
>> >
>> > Michel
>> >
>> > "William Vaughn" wrote:
>> >
>> >> Michel,
>> >> Check out the SqlBulkCopy method in ADO.NET 2.0. It can copy an
>> >> entire
>> >> table in a single (high-speed) operation. I have an example of its use
>> >> in
>> >> my
>> >> book.
>> >>
>> >> --
>> >> ____________________________________
>> >> William (Bill) Vaughn
>> >> Author, Mentor, Consultant, Dad, Grandpa
>> >> Microsoft MVP
>> >> INETA Speaker
>> >> www.betav.com
>> >> www.betav.com/blog/billva
>> >> Please reply only to the newsgroup so that others can benefit.
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >> __________________________________
>> >> Visit www.hitchhikerguides.net to get more information on my latest
>> >> book:
>> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> >> -----------------------------------------------------------------------------------------------------------------------
>> >>
>> >> "Michel" <Michel@discussions.microsoft.com> wrote in message
>> >> news:84F967B5-08BF-4E23-9C73-A19AFE8A978B@microsoft.com...
>> >> > Hello,
>> >> >
>> >> > Can someone please set me on the way on how to replace certain
>> >> > tables
>> >> > in a
>> >> > (new) SQL EXPRESS database file by tables of the same name in
>> >> > another
>> >> > (target) SQL EXPRESS database file?
>> >> > I would like to do this through code in VB.NET 2005. I presume I
>> >> > have
>> >> > to
>> >> > use ADO.NET 2.0 code.
>> >> > Is it correct I first have to delete the original table in the
>> >> > target
>> >> > database by a DROP statement and the copy the new table into the
>> >> > target
>> >> > database? Or do I use a DELETE statement and the fill the empty
>> >> > database
>> >> > by
>> >> > the new data?