#sql-server-2012

[sevennet-blog]

Solution: What is SQL Server Core Edition? #answer #computers #fix

Solution: What is SQL Server Core Edition? #answer #computers #fix

What is SQL Server Core Edition?

I was browsing my technet downloads for SQL Server 2012 and I noticed a bunch of products labelled “core” edition:

Is this something to do with their new per-core licensing model, or something else?

Answer [by Ashley Steel]: What is SQL Server Core Edition?

I was confused by this too…

From my researchit seems that Enterprise Core is in fact just the per-core…

View On WordPress

[stackcopybiz]

How to: Move database from SQL Server 2012 to 2008 #solution #it #computers

How to: Move database from SQL Server 2012 to 2008 #solution #it #computers

Move database from SQL Server 2012 to 2008

I have a database on a SQL Sever 2012 instance which I would like to copy to a 2008 server. The 2008 server cannot restore backups created by a 2012 server (I have tried).

I cannot find any options in 2012 to create a 2008 compatible backup. Am I missing something?

Is there an easy way to export the schema and data to a version-agnostic format which I…

View On WordPress

[goodanswerbiz]

Fixed Auto increment primary key in SQL Server Management Studio 2012 #dev #it #asnwer

Fixed Auto increment primary key in SQL Server Management Studio 2012 #dev #it #asnwer

Auto increment primary key in SQL Server Management Studio 2012

How do I auto increment the primary key in a SQL Server database table, I’ve had a look through the forum but can’t see how.

I’ve looked the the properties but can’t see an option, I have seen an answer where you go to the Identity specification property and set it to yes and set the Identity increment to 1, but that section is…

View On WordPress

[goodanswerbiz]

Fixed SQL Server datetime2 vs datetime #dev #it #asnwer

Fixed SQL Server datetime2 vs datetime #dev #it #asnwer

SQL Server datetime2 vs datetime

Which one:

datetime

datetime2

is THE recommended way to store date and time in SQL Server 2008+?

I’m aware of differences in precision (and storage space probably), but ignoring those for now, is there a best practice document on when to use what, or maybe we should just use datetime2 only?

Answer: SQL Server datetime2 vs datetime

I think DATETIME2 is the better…

View On WordPress

[goodanswerbiz]

Fixed Enable remote connections for SQL Server Express 2012 #dev #it #asnwer

Fixed Enable remote connections for SQL Server Express 2012 #dev #it #asnwer

Enable remote connections for SQL Server Express 2012

I just installed SQL Server Express 2012 on my home server. I’m trying to connect to it from Visual Studio 2012 from my desktop PC, and repeatedly getting the well-known error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the…

View On WordPress

[goodanswerbiz]

Fixed Where is SQL Server Management Studio 2012? #dev #it #asnwer

Fixed Where is SQL Server Management Studio 2012? #dev #it #asnwer

Where is SQL Server Management Studio 2012?

I had SQL Server 2008 R2 and Visual Studio 2008 and 2010 on my laptop (we’re a training company – hence the need for multiple versions). I’ve installed SQL Server 2012 and have finally got SQL Server Data Tools to show up, so that I can create SSRS reports in Visual Studio 2010. However…

Although I’ve installed Management tools – many times – on two…

View On WordPress

[sevennet-blog]

How to: Auto increment primary key in SQL Server Management Studio 2012

How to: Auto increment primary key in SQL Server Management Studio 2012

Auto increment primary key in SQL Server Management Studio 2012

How do I auto increment the primary key in a SQL Server database table, I’ve had a look through the forum but can’t see how.

I’ve looked the the properties but can’t see an option, I have seen an answer where you go to the Identity specification property and set it to yes and set the Identity increment to 1, but that section is…

View On WordPress

[sevennet-blog]

How to: SQL Server datetime2 vs datetime

How to: SQL Server datetime2 vs datetime

SQL Server datetime2 vs datetime

Which one:

datetime

datetime2

is THE recommended way to store date and time in SQL Server 2008+?

I’m aware of differences in precision (and storage space probably), but ignoring those for now, is there a best practice document on when to use what, or maybe we should just use datetime2 only?

Answer: SQL Server datetime2 vs datetime

DATETIME2has a date range of…

View On WordPress