Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: Need knowledge about patch

    Hello, everyone:

    Are ther any basic information about patch on SQL Server? How to develop patch, and run it? Thanks a lot

    ZYT

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I don't understand exactly what you are asking. Do you want to know about the application of SQL Service Packs?

    It sounds to me like you are trying to figure out how to create a patch for SQL Server, which is something that Microsoft frowns on because it makes the patched server practically impossible for them to support.

    -PatP

  3. #3
    Join Date
    Mar 2003
    Posts
    223
    Pat:

    Thanks for reply. I don't need MS SQL Server Pack. What I need is a .exe file that can modify database and tables. As you said, I want to know how to create a patch.

    ZYT

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Can you describe in a little more detail what you want to do? I'm still confused trying to figure out what you want, so I'm no help explaining how you could do it!

    -PatP

  5. #5
    Join Date
    Mar 2003
    Posts
    223
    Pat:

    Tell you truth, I don't have experience on SQL Server patch. I was asked to develop a .exe file that can insert, delete and trunc tables. This file will be put in network disk. Someone copy it to local machine and run it to modify database. Thanks.

    ZYT

  6. #6
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    Sounds like he's looking for a mini Enterprise Manager. Also sounds dangerous.

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Dangerous would be a HUGE understatement! There are ways that this could be done that weren't as bad as others, but this just sounds like a disaster in the making to me.

    The fundamental process of creating a list of tables, and allowing the user to truncate or drop them isn't complex. I'd guess that a rather smallish VB program could do that. The problem is that it is very dangerous!

    Creating tables would be a very slightly more complex process. Nothing earth-shattering, just a bit more complex than manipulating the existing tables. This is also a relatively safe operation compared to the other two.

    I'd have a long, heart-to-heart talk with whoever wants you to build this little beastie. I'd treat this project kind of like building a gallows, since it is pretty sure to hang the dba once it gets put to use!

    -PatP

  8. #8
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    Agreed! I have little VB apps I wrote to do this kind of thing when I don't want to wait for EM to load but since it's MY neck on the line I am VERY careful who has access to these things. Me. Only Me. Nothing but ME. So help Me Me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •