Viewing 15 posts - 331 through 345 (of 457 total)
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
June 14, 2008 at 7:27 am
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
June 11, 2008 at 3:11 am
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
June 6, 2008 at 4:08 pm
If you have the source SSIS package you re-deploy to your new instance.
Gethyn Elliswww.gethynellis.com
June 6, 2008 at 2:11 pm
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
June 6, 2008 at 8:41 am
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
June 6, 2008 at 8:28 am
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
June 6, 2008 at 7:37 am
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
June 6, 2008 at 6:46 am
Do you mean the number of rows returned?
Gethyn Elliswww.gethynellis.com
June 6, 2008 at 6:16 am
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
June 6, 2008 at 6:10 am
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
June 6, 2008 at 4:42 am
I think if its anything other than 1 it would not be a RAID 5 solution.
Gethyn Elliswww.gethynellis.com
June 6, 2008 at 3:00 am
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
June 1, 2008 at 12:34 pm
I don't get that when run a full load
Gethyn Elliswww.gethynellis.com
May 29, 2008 at 5:42 am
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
May 29, 2008 at 5:29 am
Viewing 15 posts - 331 through 345 (of 457 total)