Viewing 15 posts - 8,656 through 8,670 (of 49,571 total)
It accesses the mirror DB.
June 20, 2014 at 2:19 am
patrickmcginnis59 10839 (6/19/2014)
GilaMonster (6/19/2014)
jasona.work (6/19/2014)
The only way to "break" the TLog backup chain would be to switch the DB to Simple recovery and back to Full.
Or delete a log...
June 20, 2014 at 1:04 am
SQL Express is a free, limited version of SQL Server.
June 20, 2014 at 1:02 am
Finally...
Restore from clean backup, not repairable.
June 20, 2014 at 1:01 am
jasona.work (6/19/2014)
The only way to "break" the TLog backup chain would be to switch the DB to Simple recovery and back to Full.
Or delete a log backup. Or delete...
June 19, 2014 at 1:48 pm
david.tyler (6/18/2014)
My current employer is trying to convince our DB group SQL Server is a dying technology and open source is the way to go.
So what's his motivation here, I...
June 19, 2014 at 11:11 am
david.gugg (6/19/2014)
GilaMonster (6/19/2014)
OCTom (6/19/2014)
What gives? I thought all of us developers got admin rights!?!? :laugh:
On dev servers, I'm very happy to give developers db_owner of the DB they're working in,...
June 19, 2014 at 11:02 am
Post the table defs, post the stored proc, post some sample data and describe exactly what you want to be inserted into the other table
June 19, 2014 at 7:55 am
Ok, 6 steps back...
What is the actual problem you are trying to solve here, what are you trying to do?
June 19, 2014 at 7:44 am
OCTom (6/19/2014)
What gives? I thought all of us developers got admin rights!?!? :laugh:
On dev servers, I'm very happy to give developers db_owner of the DB they're working in, alter trace,...
June 19, 2014 at 7:34 am
It copies everything that is in the database. Table types and permissions are in the database.
June 19, 2014 at 5:14 am
PRR.DB (6/19/2014)
If possible; i will place witness in mirror server so automatically mirror become principal. In this case it very useful, without manual interaction !.
No, because it can cause false...
June 19, 2014 at 5:12 am
Test both options, see which is best.
Bear in mind that to enable an index you need to rebuild it, so it'll only be a good idea when the time...
June 19, 2014 at 4:38 am
If this query returns multiple Cat_IDs, which one do you want to be assigned to the variable?
SET @CaseID = (121)
-- SELECT
--bl.CASE_ID
-- FROM
--Patricia.dbo.BUDGET_LINE bl
-- JOIN cat_transaction ct ON bl.EXT_REFERENCE = ct.id
--...
June 19, 2014 at 4:34 am
Viewing 15 posts - 8,656 through 8,670 (of 49,571 total)