990 reputation
46
bio website
location
age
visits member for 2 years, 8 months
seen Sep 26 at 12:46

Sep
8
comment Restore master database from SQL Server 2008 R2 on SQL Server 2012
I've encountered the same problem attaching .mdf from SQL 2008 R2 onto SQL 2014. In my case it's because my dev box died, I still have the disc, and I want to extract data from the master database. Anyone know if it should be possible to do this?
Feb
8
awarded  Yearling
Dec
17
comment sp_dboption is not available in SQL Server 2012
What's the replacement for getting options? Just query sys.databases?
Feb
8
awarded  Yearling
Mar
13
answered If i issue a rollback when recovery mode is bulk logged, will my bulk operations be rolled back?
Mar
13
asked If i issue a rollback when recovery mode is bulk logged, will my bulk operations be rolled back?
Mar
5
awarded  Scholar
Mar
5
accepted When you back up a database and scripts are running at the same time, at what point in time does the backup reflect?
Mar
5
awarded  Student
Mar
5
asked When you back up a database and scripts are running at the same time, at what point in time does the backup reflect?
Feb
8
awarded  Supporter
Feb
8
awarded  Editor
Feb
8
revised Login to SQL Server using Windows Authentication
spelling & grammar
Feb
8
suggested suggested edit on Login to SQL Server using Windows Authentication
Feb
8
comment How much space is one row taking up
See [this question][1] on SO for some suggestions. [1]: stackoverflow.com/questions/227438/sql-server-row-length
Feb
8
awarded  Guru
Feb
8
awarded  Teacher
Feb
8
awarded  Good Answer
Feb
8
awarded  Nice Answer