Home » Posts tagged 'SQL Server 2012' (Page 9)
Tag Archives: SQL Server 2012
Microsoft SQL Server License Helpline
Microsoft SQL Server license has lots of flavors in terms of user based \ CAL or processor based license, license based on versions or license based on environment (physical or virtual). Although, Microsoft release license guidelines for each & every SQL server version. But there are more complex scenarios for licensing then we think. Best … Continue reading
How to find/modify SQLServer Agent logfile location?
1. To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out DECLARE @AGENT_ERRORLOG NVARCHAR(255) EXECUTE MASTER.DBO.XP_INSTANCE_REGREAD N’HKEY_LOCAL_MACHINE’, N’SOFTWAREMICROSOFTMSSQLSERVERSQLSERVERAGENT’, N’ERRORLOGFILE’, @AGENT_ERRORLOG OUTPUT, N’NO_OUTPUT’ SELECT @@SERVERNAME SERVERNAME, @AGENT_ERRORLOG AGENTERRORLOGLOCATION This command will work for both default & named instance. 2. To modify location and name of SQLServer Agent log file USE [MSDB] … Continue reading
SQL Server Silent unattended installation using configuration file
1) Open Installation Wizard 2) Select Feature You want to install 3) Provide installation configuration 4) Now that you have the configuration file, copy it to your own folder or network share where you want to start the unattended installation. 5) Cancel setup as we are interested in the unattended silent mode of installation; not … Continue reading
Cumulative Update – 2 for SQL Server 2012 Service Pack 1 Is Now Available !
The 2nd cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 2 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are facing severe issues with their environment, they can plan to test CU2 in test environment & then move to Production … Continue reading
Text information from RPC trace events not displayed in Profiler
In SQL Server 2005 and later, the information in the TextData column captured for the RPC:Starting and RPC:Completed events is also available in the BinaryData column. For performance reasons, it is more efficient to include the BinaryData column and omit the TextData column, when adding these events to the trace. If the BinaryData column is … Continue reading