Viewing 15 posts - 2,671 through 2,685 (of 6,679 total)
You can also find the next scheduled run from the Job Activity Monitor. Open that - and you will see a column for 'Last Run' and 'Next Run'.
January 2, 2014 at 2:54 pm
Edit the schedule on the job - you should see a section for Duration. In that section, you will have a Start date - for this job, that start...
January 2, 2014 at 2:52 pm
You also have to specify the full path and name of the file.
January 2, 2014 at 2:38 pm
How often are you updating statistics?
How often are you rebuilding your indexes?
Have you reviewed the 'slow' queries to see if they can be improved?
Just a few thoughts...
December 31, 2013 at 2:19 pm
You should not set min and max memory to the same value - that can cause additional problems, as in the instance not being able to start at all.
December 30, 2013 at 3:34 pm
There is a way to 'script' maintenance plans - but it takes a bit of effort.
Step1: build your maintenance plans
Step2: Import the maintenance plans to an SSIS package
Step3: Modify the...
December 26, 2013 at 1:05 pm
This error: Exclusive access could not be obtained because the database is in use.
Tells you that those services had open connections to the database being restored. When performing a...
December 24, 2013 at 12:05 pm
If you don't specify one of the options to fix corruption - CHKDSK runs in read only mode. As far as I know, this would not cause any issues...
November 26, 2013 at 12:49 pm
Please correct me if I am wrong - but setting AWE won't have any affect on this system because it only has 4GB of memory. To be able to...
November 11, 2013 at 1:03 pm
I believe you can also use BACKUP DATABASE ... WITH NORECOVERY; and it does the same thing. Very good for taking a last backup when migrating to a new...
November 7, 2013 at 12:13 pm
a20213 (11/5/2013)
can you try ?
update table set field=REPLACE(field, '@', '\')...
Won't work - as the OP is looking to change it from username@domain to domain\username.
You can do something like this:
UPDATE yourtable
...
November 5, 2013 at 12:10 pm
You cannot upgrade from 32-bit to 64-bit. It will be an uninstall/reinstall - unless you have a named instance or can use a named instance. In which case,...
November 5, 2013 at 11:59 am
Too bad you don't have access to the box itself...
If you did have access, and this is a one-time operation you could download and install a trial edition of Litespeed...
October 31, 2013 at 11:23 am
You cannot just execute sp_start_job - because all that does is starts the job and doesn't wait for the job to actually complete.
I would create a job on the 2012...
October 24, 2013 at 12:15 pm
Are you - by chance - running on an x86 platform?
October 22, 2013 at 1:31 pm
Viewing 15 posts - 2,671 through 2,685 (of 6,679 total)