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.
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.
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!
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.