Forum Replies Created

Viewing 15 posts - 331 through 345 (of 484 total)

  • RE: Server Registration via SQL DMO

    Try this.  Instead of:

        dmoServerGroup.RegisteredServers.Add(dmoRegServer)

    try:

        dmoServerGroups("TAMPA").RegisteredServers.Add(dmoRegServer)
    

    Picked this up in an old thread on microsoft.public.windows.server.migration.  I copied your script and got it to fail on my machine, but it worked making this...

  • RE: Server Registration via SQL DMO

    Just to be safe, I would add to Glenn's code, just before the end of the loop, to clear out the dmoRegServer variable with "Set dmoRegServer = Nothing".

     

  • RE: Frontpage & MS SQL Connection Error-Please Help

    I beleive that in older versions of Windows server systems, you could authenticate using the same-name user on two different servers as local users. (Definitely in NT4 and Windows 2000) ...

  • RE: Comparable storage resource?

    Have you checked with Experts-Exchange.com?  They have helped me quite a bit in that area.

  • RE: Licensing Question

    You can install SQL Server Client tools as often and on as many machines as you would like or need.  Client tools do not need SQL Server licenses to manage the...

  • RE: Storing PDF and JPEG file in SQL Server

    SQL Server not good for document storage?

    Don't tell that to the SharePoint development team, Visual Studio Team System team, or the WinFS team.  All those MS projects/products use SQL Server...

  • RE: MS ACCESS Runtime: How many instances are installed?

    1)  Depending on the installation method for the Access 97 application, it should not have installed Access 97 runtime if Access 2000 runtime was already installed.  Proper installation programs (MS,...

  • RE: ADO.NET corrupting SQL parameters

    Gregory;

    I assume when you say "..printed from dataset.InsertCommand..." you mean "...printed from dataAdapter.InsertCommand...".  That is the SQL that will get run.

    Also, check that Parameters collection for the DataAdapter, that the...

  • RE: Database Design and Reference Tables

    I have to agree with the majority of the poster's here that GenericLookup tables are usually bad idea.  I have used them on a rare occasion to fix a particular...

  • RE: SQL 2000 and dot.NET

    This would depend on how the application is architected.  In systems I design, I almost always build multiple tiers in the system, and I will want (if possible) to put...

  • RE: How does everyone backup?

    I have set up this plan for several clients.  It's easy, simple, and works for 1 to multiple servers:

    1. Added additional network adapter to each SQL Server box.
    2. Added old server with...
  • RE: OS Authentified Id''''s

    Your SQL Server installation is installed with Mixed Mode Authentication.  The IDs that you are creating in SQL Server exist in SQL Server only, and do not have any relation or...

  • RE: MSDE Default Port Number

    To answer your question directly: No, I am not sure how to change the port without using Server Network Utility.

    But, will you need any ports open?  If I understand you...

  • RE: storing PDF as blob/image and retrieving.

    Having done this in several projects, I always seem to forget to give it a file name.  Did you remember to do so?

            Response.Buffer = True
            Response.Clear()
            Response.AddHeader("content-disposition", "attachment; filename="...
  • RE: Left Outer Join

    PK;

    In your nested functions line in your join, is that a typo only in this posting, or do you have the same in your query?  I am looking at the...

Viewing 15 posts - 331 through 345 (of 484 total)