Forum Replies Created

Viewing 15 posts - 331 through 345 (of 457 total)

  • RE: is there a way to decrypt the StoredProcedure after Encryption in SQL server 2005

    I don't think you can...You can encrypt the code but can't decrypt, so if you need to make changes to the sp you will need the orginal create script.

    Gethyn Elliswww.gethynellis.com

  • RE: Transaction Log Retores with FG Backups

    Taken from BOL...

    To restore a damaged file or files from file backups and file differential backups

    Create a tail-log backup of the active transaction log.

    If you cannot do this...

    Gethyn Elliswww.gethynellis.com

  • RE: Raid situation

    definition of RAID 5 from wiki:

    Striped set with distributed parity. Distributed parity requires all drives but one to be present to operate; drive failure requires replacement, but the array is...

    Gethyn Elliswww.gethynellis.com

  • RE: Consolidate Servers

    If you have the source SSIS package you re-deploy to your new instance.

    Gethyn Elliswww.gethynellis.com

  • RE: A SAN solution I can't resist

    Firstly as a DBA hardware is very much your concern. Poor performing hardware can lead to poor DB performance so it is very important that you at least have...

    Gethyn Elliswww.gethynellis.com

  • RE: Is it better to use servers and storage from the same vendor in a cluster?

    To be honset i don't think it matters aslong as your hardware is on the Micorosft HCL list for clustering then you'll be fine. obviously if you need support...

    Gethyn Elliswww.gethynellis.com

  • RE: Consolidate Servers

    If you are using two instances then you can restore the msdb that contains ssis package to one of the instances, this will bring accross the package and all other...

    Gethyn Elliswww.gethynellis.com

  • RE: Resultset Size

    don't know if there is an easy way of doing that other than summing the size of the data types of all rows returned and then multiplying that by the...

    Gethyn Elliswww.gethynellis.com

  • RE: Resultset Size

    Do you mean the number of rows returned?

    Gethyn Elliswww.gethynellis.com

  • RE: Confirming certifications

    Not sure about MVP but the for the others the candidate will have an online transcript supplied by micorosft, which they can give you access too. They will suply with...

    Gethyn Elliswww.gethynellis.com

  • RE: Log Backup restoration

    As ken said you need to keep all log backups from thelast full/diff backup. If your T/Log backup overwrites the previous the T/Log backup then you will not be able...

    Gethyn Elliswww.gethynellis.com

  • RE: Raid situation

    I think if its anything other than 1 it would not be a RAID 5 solution.

    Gethyn Elliswww.gethynellis.com

  • RE: How do you keep up your technical skill if your company does not have the latest technology?

    I tend to dis-agree with this letter. I believe that although there enhancements and changes to the 2005 and 2008 version of the product the underlying core skills for a...

    Gethyn Elliswww.gethynellis.com

  • RE: SSAS Error - Could not find the requested trace

    I don't get that when run a full load

    Gethyn Elliswww.gethynellis.com

  • RE: Database Connectivity Problem

    As everything is working and you can connet to the db from the backend and it only the one web server that cannot coect i would suggest the credentials it...

    Gethyn Elliswww.gethynellis.com

Viewing 15 posts - 331 through 345 (of 457 total)