Reputation
423
Top tag
Next privilege 500 Rep.
Access review queues
Badges
7 21
Impact
~16k people reached

Nov
18
awarded  Popular Question
Oct
12
awarded  Yearling
Aug
11
awarded  Constituent
Jul
28
awarded  Caucus
May
22
awarded  Self-Learner
Nov
28
revised Discrepancy between system catalog view and sp_change_users_login?
added info on deprecated system tables
Nov
28
accepted Discrepancy between system catalog view and sp_change_users_login?
Nov
28
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).
Nov
28
revised Discrepancy between system catalog view and sp_change_users_login?
adapted the query to use a not-deprecated system view
Nov
28
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.
Nov
28
asked Discrepancy between system catalog view and sp_change_users_login?
Nov
27
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?