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.
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...
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...
June 6, 2008 at 4:08 pm
If you have the source SSIS package you re-deploy to your new instance.
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...
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...
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...
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...
June 6, 2008 at 6:46 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...
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...
June 6, 2008 at 4:42 am
I think if its anything other than 1 it would not be a RAID 5 solution.
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...
June 1, 2008 at 12:34 pm
I don't get that when run a full load
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...
May 29, 2008 at 5:29 am
Viewing 15 posts - 331 through 345 (of 457 total)