3,047 reputation
11225
bio website adsi.mvps.org
location Bern, Switzerland
age 47
visits member for 2 years, 3 months
seen 44 mins ago
stats profile views 207

Note to all SO beginner:

Please read (and embrace!) Jon Skeet's helpful hints on how to write a good question (or at least his short version here ) - one that has a chance that someone can answer it.


A Pascal/Delphi programmer and database freak at heart, I work as a C# developer on line-of-business applications (mostly ASP.NET).

I'm interested mostly in distributed systems (WCF), database (design and SQL), and Active Directory.


I'm an MCPD .NET 4 Web Developer, MCPD .NET 4 Windows Developer, MCPD Enterprise Application Developer (.NET 3.5), and MCTS for WCF, ADO.NET, Winforms and ASP.NET.


catch me at mscheuner -at- gmail -dot- com if you need to :-)


May
13
awarded  Caucus
May
13
answered Remove collation from all database columns
May
10
revised How should I set up my social network database design?
edited tags
May
9
revised Saving a SQL Server database to a file and opening it on another server under any database name
deleted 3 characters in body; edited title
May
9
revised mdw_purge_data_ long runtime
added 2 characters in body; edited title
May
9
revised Startup procedure for availability replica becoming primary
Product is officially called "SQL Server" - neither MSSQL, nor MS SQL, nor MS-SQL or anything like that....
May
8
reviewed Approve suggested edit on Retrieve 5th highest salary in table
May
6
revised SQL Server database schema (and likely, some data changes) - how to auto-distribute over many database instances
Product is officially called "SQL Server" - neither MSSQL, nor MS SQL, nor MS-SQL or anything like that....
May
6
revised How to connect a SQL Server 2012 to the internet
added 17 characters in body; edited title
May
6
comment Is it there anyway to restore updated records in Microsoft SQL Server 2008 R2?
The method is called backups .....
May
6
revised Is it there anyway to restore updated records in Microsoft SQL Server 2008 R2?
added 14 characters in body; edited title
May
4
revised How to create table set from several XSD in SQL Server 2012 or with VS 2012
deleted 9 characters in body; edited title
May
4
revised Calling a MySQL stored procedure with parameters in SSRS reporting through ODBC
edited tags
May
2
revised Trying to write a function that doesn't require dbo. prefix
added 13 characters in body; edited title
May
2
revised The multi-part identifier “xxx” could not be bound
Product is officially called "SQL Server" - neither MSSQL, nor MS SQL, nor MS-SQL or anything like that....
May
2
revised Restoring differential backup from SQL Server 2005 to SQL Server 2012
added 2 characters in body; edited title
May
1
revised Is there a better way than the ones listed within to join data in an excel spreadsheet to a table in a SQL Server database?
Product is officially called "SQL Server" - neither MSSQL, nor MS SQL, nor MS-SQL or anything like that....
May
1
comment Restoring SQL Server 2012 database onto 2008
You CANNOT under any circumstance restore a newer backup to an older instance. Just CANNOT be done. No tool, no trick, no hack - it just isn't technically doable. No way. Period. The database compatibility level doesn't help here. Your only viable option is using database scripts - or a database diff tool like Red-Gate SQL Compare to achieve this.
Apr
30
revised Difference between accessing SQL Server by instance name and cluster name
Fixed quite a few typos
Apr
29
revised Upgrade SQL Server 2005 Enterprise to SQL Server 2008 R2 Standard
deleted 3 characters in body; edited title