Viewing 15 posts - 1 through 15 (of 620 total)
Ok thanks Steve.
At least we know now and it wasn't just me being crap 😉
Adam Zacks-------------------------------------------Be Nice, Or Leave
July 22, 2019 at 9:28 am
This was removed by the editor as SPAM
June 3, 2019 at 2:13 pm
This was removed by the editor as SPAM
June 3, 2019 at 2:11 pm
Can you explain what it is you are trying to do?
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 3, 2019 at 2:05 pm
Agree with Grant and Beatrix.
The login you have, are you able to get into sql with it? Im assuming yes, based on your question and it also sounds like its...
Adam Zacks-------------------------------------------Be Nice, Or Leave
May 31, 2019 at 3:24 pm
It is doable but must be done through regedit and careful scripting.
Adam Zacks-------------------------------------------Be Nice, Or Leave
May 31, 2019 at 3:00 pm
Agree with Steve, PS can help with this sort of thing but then you have to schedule and run it and what happens if that fails.
You could also look in...
Adam Zacks-------------------------------------------Be Nice, Or Leave
May 31, 2019 at 2:47 pm
What you have done sounds correct to me. But you don't have to be an owner of a schema to affect objects within it. you just need relevant permissions on...
Adam Zacks-------------------------------------------Be Nice, Or Leave
May 31, 2019 at 2:36 pm
Jeff, I am the original poster and wanted to say thank you for your post.
Again I have read all responses that have occurred over the last 3 years! But i...
Adam Zacks-------------------------------------------Be Nice, Or Leave
March 17, 2015 at 7:57 am
so your problem is that when doing a db restore or some other ssms active diag drive task, your get the outofmemory and then what? what happens when you click...
Adam Zacks-------------------------------------------Be Nice, Or Leave
September 10, 2013 at 5:52 am
when you said that tsql works, what did you do?
did the successful run come from ssms, sqlcmd or some other means.
Adam Zacks-------------------------------------------Be Nice, Or Leave
September 10, 2013 at 5:41 am
pradeep.mohan (9/10/2013)
tsql restoration script is working well.
have you restarted ssms? as in made sure the task is ended?
Adam Zacks-------------------------------------------Be Nice, Or Leave
September 10, 2013 at 5:35 am
also, have you run an estimated ex plan?
where is the main load?
it may be your query.
Adam Zacks-------------------------------------------Be Nice, Or Leave
September 10, 2013 at 5:34 am
pradeep.mohan (9/10/2013)
I tried both locally and server also.
tsql?
Adam Zacks-------------------------------------------Be Nice, Or Leave
September 10, 2013 at 5:32 am
Sean Pearce (9/10/2013)
Are you running SSMS locally or on the server?
was just going to say that 🙂
Try running as tsql.
Adam Zacks-------------------------------------------Be Nice, Or Leave
September 10, 2013 at 5:31 am
Viewing 15 posts - 1 through 15 (of 620 total)