Post reply

Object tampering within SQL Server 2008

  • March 22, 2010 at 10:21 am

    #230992

    Does anyone known a method of object tampering within SQL Server 2008?

    The goal is to use an attached copy of mssqlsystemresource db and alter some system stored procedures, and then replace this database with the original one. This operation was possible in SQL 2005 (sample link: http://www.docstoc.com/docs/22658935/SQL-Server-Security)... and saved me many hours of work.

    I usually install on SQL Server systems Transactional Replication on databases. This is not for hack SQL Server!

    Sample: there is a system stored stored procedure in mssqlsystemresource db that is called when gererating code for triggers and sps for the publisher side, named [sys].[sp_execresultset].

    Altering this sp, i can modify the standard code that is generated by default.

    Could anyone help me to find a way to do this in SQL Server 2008?

  • March 22, 2010 at 10:54 am

    #1137687

    duplicate post.

    continue reading here:

    http://www.sqlservercentral.com/Forums/Topic887248-391-1.aspx#bm887384

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 22, 2010 at 3:35 pm

    #1137887

    Interesting Duplicate Post. This post was created several hours after the initial post in Lowell's link.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 22, 2010 at 3:38 pm

    #1137891

    Probably didn't like the answers in the first post.

  • March 22, 2010 at 3:39 pm

    #1137893

    Lynn Pettis (3/22/2010)

    Probably didn't like the answers in the first post.

    That was the perception I got.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply