Viewing 15 posts - 3,301 through 3,315 (of 6,679 total)
WayneS (4/8/2011)
One thing to keep in mind - if you create scheduled maintenance plans, the jobs it creates are owned by the person creating the MP.
I handle this by updating...
April 8, 2011 at 3:06 pm
Tara, it looks like you are missing a few things in the code. It is hard to tell if there is any way to optimize this without seeing all...
April 7, 2011 at 3:40 pm
rabisco (4/7/2011)
Ken McKelvey (4/7/2011)
Something like the following:
DELETE docBodyVersion
WHERE EXISTS
(
SELECT *
FROM...
April 7, 2011 at 3:28 pm
annasql (4/6/2011)
I hope there is a microsoft article explains this in detail. Because we are planning upgrade all our sql 2005 to 2008 on windows...
April 6, 2011 at 10:11 pm
CirquedeSQLeil (4/6/2011)
Jeffrey Williams-493691 (4/6/2011)
The job_id is stored in the table: sysmaintplan_subplans and can...
April 6, 2011 at 6:10 pm
In addition to what Perry has asked - are the services on each node set to manual startup or automatic?
And - what is the version of the OS you are...
April 6, 2011 at 6:05 pm
I found a way to relate maintenance plans to their associated agent jobs. It is quite simple...
The job_id is stored in the table: sysmaintplan_subplans and can be used directly...
April 6, 2011 at 3:55 pm
Okay, when I first saw this message and thread - I started wondering about this myself. So, I looked around and figured out what is going on.
To explain, I...
April 6, 2011 at 3:48 pm
One of the things to be aware of is how the maintenance plan history viewer works. It works based upon the maintenance plan - and not the sub-plans.
If you...
April 6, 2011 at 2:49 pm
Not that I am aware of, you can check to see if there is an identifier in the sysdtspackages90 table that would relate to the identifiers in the sysjobs tables.
I...
April 5, 2011 at 8:05 pm
I don't see any issues with using 'sa' as the owner of agent jobs.
As for a query, it is included in my previous post.
April 5, 2011 at 7:36 pm
Grant Fritchey (4/5/2011)
True, but I prefer to not let anyone have privileged access to the server except other DBAs.
Of course, I would prefer that also - but I have various...
April 5, 2011 at 7:35 pm
When a maintenance plan is created, it will be owned by the user logged into the system when it is created.
The owner will not be changed after the fact. ...
April 5, 2011 at 2:26 pm
Grant Fritchey (4/5/2011)
Can you try using restricted user instead of single user? I've seen applications that constantly refresh their connection so they can squeek in before you start the restore.
If...
April 5, 2011 at 2:17 pm
Lookup substring in books online. If you really need the answer as February and not '02', then you are going to need to convert the period into a data...
April 1, 2011 at 4:50 pm
Viewing 15 posts - 3,301 through 3,315 (of 6,679 total)