378 reputation
518
bio website josienbraas.nl
location Netherlands
age
visits member for 2 years, 11 months
seen 1 hour ago

Enthusiast programmer!


4h
revised Discrepancy between system catalog view and sp_change_users_login?
added info on deprecated system tables
4h
accepted Discrepancy between system catalog view and sp_change_users_login?
4h
comment Discrepancy between system catalog view and sp_change_users_login?
Great answer, thanks! I had not thought that this was due to sp_change_users_login - that one floats all over the internet when the talk is about orphaned users (see here for example).
5h
revised Discrepancy between system catalog view and sp_change_users_login?
adapted the query to use a not-deprecated system view
5h
comment Discrepancy between system catalog view and sp_change_users_login?
Excellent catch, thanks! I adapted the query to use database_principals instead of sysusers, but unfortunately this still shows the exact same discrepancies.
7h
asked Discrepancy between system catalog view and sp_change_users_login?
1d
awarded  Good Question
Nov
12
accepted How large will the Transaction Log backup be?
Sep
29
awarded  Notable Question
Jul
23
awarded  Notable Question
Jul
15
awarded  Popular Question
Jul
2
awarded  Curious
Jul
12
comment SQL Server 2008 - performing nightly full backups & transaction log shipping, but log file keeps growing
Is the Recovery Model set to FULL? Transaction log backups do not automatically shrink or truncate the transaction log, so it might keep growing. Check out this article.
May
31
revised How large will the Transaction Log backup be?
added some info
May
31
comment How large will the Transaction Log backup be?
@TomTom: so when I do a full backup, the transaction log will be truncated automatically?? Or do you mean that we don't need a transaction log backup after doing a full backup anymore?
May
31
comment How large will the Transaction Log backup be?
Alas, it's Standard Edition. It might be fine to start a new log chain as you describe, because we have third-party full and differential backups. Thanks for the suggestion!
May
31
asked How large will the Transaction Log backup be?
May
30
awarded  Informed
May
22
awarded  Constituent
May
14
awarded  Popular Question