Forum Replies Created

Viewing 8 posts - 1 through 9 (of 9 total)

  • RE: Partitioned table dropped! HELP!

    As far as I've understood all this, there is no standard easy method to get this data back with what you have.

    You'll have to reverse engineer the data files mdf,...

    _______________________________________________

    Causing trouble since 1980

    blog: http://weblogs.sqlteam.com/mladenp

    SSMS Add-in that does a few things: www.ssmstoolspack.com

  • RE: Partitioned table dropped! HELP!

    One way to get the data back is by stopping all activity on your database and read the datapages directly.

    You'll have to parse the data pages by yourself.

    However because you...

    _______________________________________________

    Causing trouble since 1980

    blog: http://weblogs.sqlteam.com/mladenp

    SSMS Add-in that does a few things: www.ssmstoolspack.com

  • RE: Database visualization tools needed.....

    I exclusively use SchemaSurf by Atlantis Interactive.

    It's free and IMO awesome.

    http://www.atlantis-interactive.co.uk/products/schemasurf/default.aspx

    _______________________________________________

    Causing trouble since 1980

    blog: http://weblogs.sqlteam.com/mladenp

    SSMS Add-in that does a few things: www.ssmstoolspack.com

  • RE: Begin tran/Rollback in SSMS after security update?

    hey everyone!

    i'm the author of the SSMS Tools Pack.

    can anyone please provide me with the updates you have installed, the OS version, SQL and SSMS versions and is it a...

    _______________________________________________

    Causing trouble since 1980

    blog: http://weblogs.sqlteam.com/mladenp

    SSMS Add-in that does a few things: www.ssmstoolspack.com

  • RE: MS DTC problem when promoting transactions

    it seems that you don't have MSDTC enabled on both computers

    _______________________________________________

    Causing trouble since 1980

    blog: http://weblogs.sqlteam.com/mladenp

    SSMS Add-in that does a few things: www.ssmstoolspack.com

  • RE: different execution time

    i'm no expert in jdbc but can't you run the query without the use of sp_prepexec?

    it's it that is adding extra time to exec time.

    _______________________________________________

    Causing trouble since 1980

    blog: http://weblogs.sqlteam.com/mladenp

    SSMS Add-in that does a few things: www.ssmstoolspack.com

  • RE: Whoa! @table variables unaffected by Transaction

    this feature is acctually very usefull in auditing.

    for example if you have a need to rollback the data in a trigger or in a sproc but you have to

    save...

    _______________________________________________

    Causing trouble since 1980

    blog: http://weblogs.sqlteam.com/mladenp

    SSMS Add-in that does a few things: www.ssmstoolspack.com

  • RE: MSDBA Certification

    I've passes 70-431 so far:

    http://weblogs.sqlteam.com/mladenp/archive/2007/05/10/60199.aspx

    I've used this book for it:

    http://weblogs.sqlteam.com/mladenp/archive/2007/05/10/60200.aspx

     

    the test wasn't that hard though. You do have to know SSMS GUI pretty well.

    _______________________________________________

    Causing trouble since 1980

    blog: http://weblogs.sqlteam.com/mladenp

    SSMS Add-in that does a few things: www.ssmstoolspack.com

Viewing 8 posts - 1 through 9 (of 9 total)