Home » SQL Tips & Tricks (Page 5)
Category Archives: SQL Tips & Tricks
Move or Relocate the files of Resoruce Database in SQL Server 2005
The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not contain user data or user metadata. … Continue reading
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
SQL Server Reserve 1 user connection for DAC (Dedicated Administrator Connection)……want to confirm ?
Sometime before, I was giving training on basics of SQL Server. One of attendee is having doubt & want to confirm that SQL Server really Reserve 1 user connection for DAC (Dedicated Administrator Connection). So I decide to show a demo for the same. I have changed the no. of User Connections to 1 & … Continue reading