Forum Replies Created

Viewing 15 posts - 12,271 through 12,285 (of 39,963 total)

  • RE: TDE DR

    hany.helmy (7/14/2013)


    In the explanation it was mentioned the following: "The DEK is inside the backup", to be honest I am not an expert of (Transparent Data Encryption), but I am...

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (7/12/2013)


    Personally I find it very hard to understand why, some years ago, the USA government/administration decided to instill into operatives in its federal services an attitude to...

  • RE: TDE DR

    I'm not sure what you mean about insecure if you have the cert without the password. You could have a blank password, but in that case you'd technically have the...

  • RE: Are the posted questions getting worse?

    Sean Lange (7/12/2013)


    Greg Edwards-268690 (7/12/2013)


    Sean Lange (7/12/2013)


    Steve Jones - SSC Editor (7/11/2013)


    I renewed my passport last year. There still was expedited service, but I didn't choose it. Got mine in...

  • RE: SSIS to the rescue, Replication, or overkill?

    Use the import wizard to get you started.

    Or look through the Stairway here. It does an incremental load that might help

    http://www.sqlservercentral.com/stairway/72494/

  • RE: TDE DR

    It's worded poorly in BOL.

    Essentially on the source you:

    - create master key (protected by SMK) in master.

    - create cert, protected by DMK (master key).

    - you backup the cert, decrypting it...

  • RE: Upgrade SQL Server 2000 to SQL Server 2008

    no need to apologize and glad you got it figured out.

    you've got the right solution. Move backups, restore.

    Also, script out logins (sp_helprevlogin) and move those. Watch out for linked servers,...

  • RE: REPLICATION

    I believe you need to drop and reconfigure replication with a new distributor. You should have scripted out replication as soon as it's set up since problems can result in...

  • RE: Splitting a Full Name

    the thing to do, IMHO, is have a series of passes in the data, with a few procs/functions, that handle different items. This one posted looks good, but I bet...

  • RE: SQL Database Name Change - How to handle this in SSIS on SQL Tasks

    Good for you.

    you might think about scanning a folder in the package for .bak files, working out the latest one, and then grabbing the name for use in the...

  • RE: Contained database

    The case is that you don't have any instance logins, only contained ones in your database. You can migrate all your users (windows are easy) to contained, and then you...

  • RE: SQL 2008 R2 setup.exe does nothing

    You should get an error.

    AFAIK, Windows 7 is not an acceptable OS for SQL 2008 R2 enterprise, or any version.

    http://msdn.microsoft.com/en-us/library/ms143506(v=SQL.105).aspx

    This is only supposed to run on Server OSes.

  • RE: SQL Server Memory Usage

    +1.

    Set a max memory, but SQL will take all it can get if you let it.

  • RE: SSIS to the rescue, Replication, or overkill?

    I like derived (staging) tables as an intermediary, and I'd probably use SSIS to move the data regularly. No reason a stored proc can't work, but I tend to stick...

  • RE: I need some clarification on mirroring

    Is it way behind? Have you looked in BOL for the "Monitoring Mirroring Status"?

    It could be always slightly behind, depending on how your system is setup and your network.

    In a...

Viewing 15 posts - 12,271 through 12,285 (of 39,963 total)