Viewing 15 posts - 46 through 60 (of 1,348 total)
there was an app roll back right before to a previous version but the trigger is only supposed to fire for SSMS and MS Office Apps along with Aqua Data...
March 6, 2017 at 8:45 am
it's been working for years except for 20 minutes last week when it fired off for users and applications not in the trigger
March 6, 2017 at 8:25 am
we have some read only sql logins going back many many years where people have given out the passwords and so on. about a decade ago we started to move...
March 6, 2017 at 7:52 am
that's the most important code. didn't include the start and the end from when you script it out. we rarely see it triggered and the applications don't start with SQL....
March 2, 2017 at 12:34 pm
IF ORIGINAL_LOGIN()in ( 'user1', 'user2','user3', 'user4') AND (program_name() like '%SQL %'
or program_name() like 'Microsoft® Access' or program_name() like '%Microsoft Office %' or program_name()...
March 2, 2017 at 12:08 pm
Steve Jones - SSC Editor (5/18/2016)
Not that I've heard of. However this is the 2012 forum. Do you mean you have a 2012 SP3 distributor taking replication from (or...
May 21, 2016 at 9:50 am
did SP3 bread replication to SQL 2005 servers for anyone else? we set up a new distributor with SP3 and when we tried to migrate replication to/from SQL 2005 didn't...
May 18, 2016 at 9:03 am
Not the logs but full backups
August 14, 2015 at 2:58 pm
yes, the SAN vendors will do SQL DR but it's based on scanning their disk volumes for changes. at least it seems that way from the documentation.
for backup you can...
August 14, 2015 at 1:32 pm
Indianrock (8/14/2015)
August 14, 2015 at 1:01 pm
maddy192 (8/14/2015)
Oh! and of course what happens to poor old Log Shipping? Do you have a solid DR in your stupid expensive 3rd party?
you can do log shipping, third party...
August 14, 2015 at 8:53 am
maddy192 (8/14/2015)
August 14, 2015 at 8:47 am
do people really write code where they insert data like that with the status and the code not part of the insert operation and you have to update it as...
March 17, 2015 at 9:28 am
will this work on SQL 2005?
June 6, 2014 at 7:56 am
i've never done log shipping, but with mirroring all you have to do is leave the database in a restoring state and then start mirroring. can you do the same...
June 7, 2013 at 7:49 am
Viewing 15 posts - 46 through 60 (of 1,348 total)