Viewing 15 posts - 16 through 30 (of 50 total)
This is good stuff, info I couldn't find in any of the BOL.
So, here's what I have:
JobA is owned by sa. SQL Agent and SQL Server are both run...
June 6, 2012 at 1:20 pm
opc.three (6/1/2012)
pveilleux (5/31/2012)
In digging around on one of our servers, I found what appears to be someone logging in as the SQL Server/Agent service account and running jobs. ...
June 6, 2012 at 9:47 am
SQLKnowItAll (5/31/2012)In that case, I would make sure to have a separate agent account from the database engine. That 15 minutes will give you time to switch that and keep...
May 31, 2012 at 1:41 pm
SQLKnowItAll (5/31/2012)
http://beyondrelational.com/modules/2/blogs/77/posts/11360/changing-sql-server-service-account-or-password-avoid-restarting-sql-server.aspx
Good point. I have always done a reboot to be on the safe side. This client has many, many, many processes that move data among multiple servers,...
May 31, 2012 at 1:32 pm
SQLKnowItAll (5/31/2012)
Since it is a domain account, why not just change the password and see who comes complaining to you? Who all needs to know that password? Hopefully only you...
It's...
May 31, 2012 at 1:13 pm
SQLKnowItAll (5/31/2012)
Scheduled jobs run under the service account for SQL Server Agent.
True, but these jobs are not scheduled. If they are scheduled, you will see the following in the...
May 31, 2012 at 12:40 pm
AlexSQLForums (5/31/2012)
that's probably sharepoint service.
No SharePoint installations at this site.
Apologies - I did not mention that all of the jobs I saw this for are created by the developers. ...
May 31, 2012 at 12:24 pm
Sweet - thanks for sharing....
One thing I found was for the step "Split FileList", the SQL statement being executed has a variable name in it. I had to remove...
February 27, 2012 at 1:44 pm
Thanks for the responses, folks....
Based on what you've said, it sounds like an appropriate index should be considered in the case I described. I think what I may be...
November 17, 2011 at 6:57 am
GSquared (10/13/2011)
October 13, 2011 at 8:54 am
@lowell, @Hardy,
Thanks for your ideas and explanations. I was able to find another way around it, but the split function is something I should probably create just...
October 13, 2011 at 7:26 am
Wow......I never thought I'd be attacked for asking what I thought was a simple question. Allow me to address your points one by one here, just so there is...
October 13, 2011 at 7:24 am
Michael Valentine Jones (9/13/2011)
September 13, 2011 at 7:59 am
steveb. (7/7/2011)
you could always install IIS on the box as well and do the redirect there
Since IIS is already installed for Master Data Services, this looks like...
July 8, 2011 at 7:48 am
GilaMonster (3/21/2011)
If you copy the backup locally and then try and restore do you get the same errors?
pveilleux (3/21/2011)
Yes, we do. I forgot to mention that.
Quick update:
In the past,...
March 22, 2011 at 8:46 am
Viewing 15 posts - 16 through 30 (of 50 total)