Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Excel to SQL Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 8:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 07, 2014 3:45 AM
Points: 32, Visits: 280
Hello there,

I have a standby mode database result of log shipping what i have at the moment is users are accessing this database by using an excel sheet and making select statements to filter data and so on. The problem is that restoring cant happen since the excel sheet is creating an exclusive lock to those tables.

Is there any way that I can make the log shipping to continue without having to kill the users every time ? can I use another isolation level in the beginning of the select statement in excel will that help?

Thank you in advance

Riri
Post #1429867
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse