121 reputation
4
bio website
location
age
visits member for 2 years, 10 months
seen Apr 26 '13 at 17:46

Oct
1
awarded  Popular Question
Apr
26
awarded  Scholar
Apr
26
awarded  Supporter
Apr
26
accepted Composite field in SQL Server, does it exist?
Apr
26
comment Composite field in SQL Server, does it exist?
Cool stuff, thank you.
Apr
26
comment Composite field in SQL Server, does it exist?
I'm building a DB against a legacy system and OrderNumbers are NOT unique and they roll over, so I will make them unique in my DB using the dates. I need them unique because of some queries that require the OrderNumbers to be unique. And I also NEED a surrogate key because of the ORM framework I use (this is Id).
Apr
26
asked Composite field in SQL Server, does it exist?
Feb
10
comment How to re-create the ##MS_PolicyEventProcessingLogin## principal
Mmh, ok so I did what you said, I rebuilt the system databases, following the MS guides you posted. Unfortunately it screwed up the system big time, basically it lost all logins, databases, etc... Fortunately I had a backup of the master db from this morning so I could restore everything. Is there something special I can do to avoid losing everything when I rebuild the system dbs? I looked at the MS guides and nowhere do they mention that all data will be lost...
Feb
10
comment How to re-create the ##MS_PolicyEventProcessingLogin## principal
I don't have a backup of master unfortunately, how can I rebuild it without reinstalling the entire product? Thank you...
Feb
10
comment How to re-create the ##MS_PolicyEventProcessingLogin## principal
That did not work either, it just created a new regular user in master, called ##MS_PolicyEventProcessingLogin##. When running the report it still returns nothing.
Feb
10
awarded  Student
Feb
9
comment How to re-create the ##MS_PolicyEventProcessingLogin## principal
This is the first thing I tried. Nothing comes up after running the report.
Feb
9
asked How to re-create the ##MS_PolicyEventProcessingLogin## principal