Post reply

Object tampering within SQL Server 2008

  • March 22, 2010 at 10:24 am

    #218434

    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:52 am

    #1137686

    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!

Viewing 2 posts - 1 through 1 (of 1 total)

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