Viewing 15 posts - 556 through 570 (of 619 total)
NicDX (10/28/2008)
verified that you are authenticating using the correct username and password?
You must ensure that the username you are connecting with ie service account on one server has sufficient rights...
October 28, 2008 at 6:25 am
Verify that the user/service/account which is running the job/agent has enough rights to delete files from the location. Modify does not allow delete. So the account must have full access.
October 23, 2008 at 8:01 am
What is the point of having a point in time policy if the log is backed up once daily before the database. That would only be helpful if the database...
October 23, 2008 at 4:25 am
If you create a user with the server role 'process_admin', this user will be able to use the activity monitor. HOWEVER...
It will also be able to kill of processe.
Hope this...
October 22, 2008 at 8:09 am
Hi there and welcome to SSC. Didnt really understand your request but assuming you talking about how to script new windows logins in SQL 2005, please see below:
USE [master]
CREATE LOGIN...
October 22, 2008 at 7:46 am
Or, if you have done a full db backup and want to just squish your t-log, ensure db backup and set recovery mode to 'simple'.
Manually shrink the t-log (should...
October 22, 2008 at 7:29 am
Correct. There is no need to over complicate the plan (as long as its not to complex ie TSQL and other bespoke tasks).
I keep most of my plans to one...
October 17, 2008 at 3:13 am
Hi there,
Just re-read your original question and realised my response ignored your question.
Rather then scheduling the different steps/parts to run at different time, use the progression/inheritance lines.
In that way...
October 16, 2008 at 9:55 am
E'oh 🙁
Just seen everyones response, that'll teach me for not hitting F5.
Sorry guys, didn't mean to go repeating everyone else's point.
Let me know what you decide on Jackal as we...
October 16, 2008 at 9:48 am
So weird... I was looking into this on Monday and since then there have been several posts to the same subject.
Does see strange the ways it’s labelled. You would assume...
October 16, 2008 at 9:44 am
Steve Hindle (10/16/2008)
October 16, 2008 at 9:36 am
magennis.weate (10/13/2008)
you could try using xp_cmdshell (if it is enabled)
That certainly works for me. xp_cmdshell is useful for passing commands to the OS but a word of warning, it...
October 14, 2008 at 5:01 am
That was my assumption as well. I just needed someone with more experience to sanity-check it for me.
Thank you for your quick reply and i'll let you know what they...
October 13, 2008 at 9:11 am
Hey Michael,
The management are taking lead drom the consultants who have specifyed a two-node cluster (seperate). The IT department have suggested too extend our current cluster.
We are one of the...
October 13, 2008 at 8:55 am
Viewing 15 posts - 556 through 570 (of 619 total)