Excellent. Thank you very much.

SELECT result = @dt + @txt

INTO t;

EXEC sp_help t

Using sp_help to see the metadata. Brilliant tip. I'll gonna use...

No. But you can have both installed at the same time.

The one you need is SQL 2012 with VS 2012. The other version is for SQL Server 2014.

I remembered incorrectly. It wasn't a patch that solved the problem. For a while our domain controllers was a mix of Windows 2003 and 2008 (or 2012). As soon as...

Did you set the type to WMI event alert? I don't know much about WMI namespaces. I use the type SQL Server Performance Condition Alert instead, which uses performance counters.

One way is to create an alert in the SQL Server Agent with the type SQL Server Performance Condition Alert. Set the Object, Counter, Instance and type of alert condition....

I've had this problem. The "quick fix" was to reboot the server but it didn't solve the problem. It kept on coming back. Here's a link to Microsoft on how...

Nothing is easy when it comes to licensing, but the simple answer should be:

Price of licensing the number of cores (4 is minimum) / price of 1 user license =...

If you just want to show the date and time with hour, minute and second you can use:

SELECT FORMAT(GETDATE(), 'yyyy-MM-dd hh:mm:ss')

MM = month

mm = minute

If it's a large number of users, it can be cheaper (and easier) to license the number of cores in the SQL Server machine. A minimum of 4 core licenses...

Starting SQL Server in single-user mode enables any member of the computer's local Administrators group to connect to the instance of SQL Server as a member of the sysadmin fixed...

ALTER TABLE

Books Online -> https://msdn.microsoft.com/en-us/library/ms190273.aspx

Yes, SSMS 2014 will connect to 2012 Express.

Have you tried connecting with the servers' IP-addresses?

If you have a 64-bit installation of SSRS on your workstation you should deploy and view it there. Otherwise to the server and then view the report.