209 reputation
14
bio website idealcode.net
location San Francisco, CA
age 30
visits member for 2 years, 3 months
seen Jun 18 '12 at 20:55
stats profile views 21

Sep
10
awarded  Popular Question
Jun
18
accepted Copy Database wizard fails but leaves no text file log
Jun
18
awarded  Yearling
Jun
18
accepted The database principal owns a schema in the database, and cannot be dropped message
Jun
18
asked Copy Database wizard fails but leaves no text file log
Jun
18
awarded  Supporter
Jun
18
comment The database principal owns a schema in the database, and cannot be dropped message
Okay, so this worked. I'm a little confused as to why, however. Why do I need to authorize the schema to another schema? Maybe I need to review schemas...
Jun
18
asked The database principal owns a schema in the database, and cannot be dropped message
Apr
14
asked In trying to setup back up device, net use command throws operating system error 53 when passing in a unc
Dec
16
asked Can you set up mirroring for sql server reporting services?
Dec
15
comment SQL Server Backup Sizes Differential, Compressed Backup Sizes
Thanks for the link. I ran it and the SP database has changed 27%.
Dec
15
asked SQL Server Backup Sizes Differential, Compressed Backup Sizes
Sep
29
accepted SQL Server 2008 Mirroring Pauses without warning
Sep
20
asked SQL Server 2008 Mirroring Pauses without warning
Feb
17
awarded  Student
Feb
17
asked What is the best way to find out how many records do not have a proper phone number in SQL Server?
Feb
7
awarded  Scholar
Feb
7
accepted Best way to sync a table between two sql server databases with an identity key
Feb
7
comment Best way to sync a table between two sql server databases with an identity key
No, because in the SSIS package, I can't control the order of the data insertion. Because the destination table manages the identity key and auto increments, it assigns the wrong numbers.
Feb
3
asked Best way to sync a table between two sql server databases with an identity key