Viewing 15 posts - 16 through 30 (of 80 total)
it needs to plug into an in-house pre-existing CRM and we dont have a sharepoint resource at the moment
i will pose the idea and see if they are interested
thanks again...
December 4, 2014 at 6:46 am
thanks guys
they have since added a load of auditing functionality to this project so its getting more complicated than just a checked-out function. I have a feeling this will end...
December 4, 2014 at 4:43 am
thanks gail 🙂
i was just looking for some articles....but i got a lot of time to test this fortunately!
December 2, 2014 at 7:15 am
ah ok....i was hoping a lock could be session based rather than transaction based....but i understand why that could be a bad idea!!
ill create a checked-out column or something similar
thanks...
December 2, 2014 at 7:03 am
i have tried that but it doesnt work....still able to select from another session
i have the following:
--create table tbl_work_list
--(task varchar(10))
--insert into tbl_work_list
--values('task1'), ('task2'), ('task3'), ('task4')
select top 1 * from tbl_work_list...
December 2, 2014 at 6:50 am
yeah tested it with a few DDL statements and all good!!
thank 🙂
=================
mark as closed
October 7, 2014 at 3:13 am
i do now!!
must have been having a 'mare....cant think why i thought turning off ddl changes made sense!!
thanks 🙂
October 6, 2014 at 2:25 am
a couple of specific questions:
- is there any way to see how many transactions have to be rolled back/forward during the restore?
- any way to check the startup...
July 29, 2014 at 4:22 am
thanks guys for all your responses
please mark this post as closed/answered and give any points to perry 🙂
June 30, 2014 at 3:40 am
oohhh.....thanks perry!!
hadnt seen that distinction made anywhere else yet....nice catch 🙂
June 27, 2014 at 3:50 am
hmm....yeah i jumped ahead of myself....will be logged but not stored
and i have resigned myself to restarting the logshipping for this database if i want to get the maintenance done!!
joined...
June 25, 2014 at 10:07 am
aahhhhh....perfect!!
thats what i was hoping for....been trying to develop a restore plan to test the theory but was struggling!!
i have put in the SINGLE_USER command before each log restore for...
April 22, 2014 at 9:06 am
im still wondering if there are any risks with only applying the standby file to the final log restore in the chain....this will also speed up the restores which isnt...
April 22, 2014 at 7:47 am
i am assuming that when using a standby file it sets the database to standby after each restore and the SINGLE_USER may not apply from that point onwards
ill test....thanks
April 22, 2014 at 7:39 am
i cannot....its a "manual" log shipping process controlled by a windows task and using powershell.
during the night when there is a string of log restores we are getting the following...
April 22, 2014 at 6:55 am
Viewing 15 posts - 16 through 30 (of 80 total)