Viewing 15 posts - 931 through 945 (of 1,079 total)
And I ask this because we do not "formally" have a DB here
A formal Database or formal Database Administrator?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 23, 2010 at 6:09 am
Results?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 23, 2010 at 6:04 am
Ask yourself the following questions:
1. How many DB's will be hosted
2. How many concurrent connections
3. What is the current average IO statistics?
4. What on average is your data growth?
Since...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 23, 2010 at 5:58 am
primary database coruppeted
primary = master?
-then, do you have a backup?
-- you will have to start sql in single user mode (-m) and restore it.
if master <> primary
do you have...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 23, 2010 at 5:50 am
open attachment
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 23, 2010 at 5:43 am
Upload your current dtsx package for us to see what you need and assist.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 23, 2010 at 2:20 am
You could prevent it by defining the permissions on specific accounts.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 23, 2010 at 2:13 am
Have you checked the job history info on the failing job?
It should give you a clear description of the issue, in which step etc.
If its a permission issue, and...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 22, 2010 at 10:39 pm
Are you using a single generic account to authenticate users from the app to SQL?
You will have to define persmissions on the accounts.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 21, 2010 at 10:16 pm
Try different installation media?
Errors are not very descriptive, except that there is a issue with the msi.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 21, 2010 at 10:15 pm
Read: BOL
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 19, 2010 at 1:07 am
What sort of authentication to your exchange server, did you use in your mail profile?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 19, 2010 at 12:18 am
You will have to have exclusive access to the current DB to modify/overwrite/delete it.
This means you will have to close all current connections to it before changing it.
You could however:
Restore...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 19, 2010 at 12:14 am
sanjsharma (2/18/2010)
I have a math calculation in vba which correctly calculates
(1 - 1.5 * (0.11852 - 0.05478 * Log((3.00/ 10000)))...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 18, 2010 at 4:31 am
terry.payne (2/18/2010)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 18, 2010 at 4:24 am
Viewing 15 posts - 931 through 945 (of 1,079 total)