Moving Temp DB to Different Folder / Location

---Determine the logical file names of the tempdb database and their current location on the disk.

SELECT name, physical_name AS CurrentLocation
FROM sys.master_files
WHERE database_id = DB_ID(N'tempdb');
GO

----Change the location of each file by using ALTER DATABASE.

USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = 'F:\TEMPDB\tempdb.mdf');
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = templog, FILENAME = 'F:\TEMPLOG\templog.ldf');
GO

--Stop and restart the instance of SQL Server.
--Verify the file change.

SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'tempdb');


--Delete the tempdb.mdf and templog.ldf files from the original location.

How to identify what features has been installed in your SQL Server

How to view the list of features installed in the SQL Server easily without going through “Programs and Features” or “Services”.


Yes, there is an easy way.

Method 1: 

we can navigate to the Following Path and see the summary file.

SQL server 2012 Features Installation Discovery.

C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\Summary.txt

SQL Server 2008 Features Installation Discovery.

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\Summary.txt

Method 2:

Second method is you can go to the Startup and choose the SQL Server Installation Center.

Select Tools on the Left side  and choose Installed SQL Server Features Discovery Report

you will get the Report in internet explorer.

Regards

R.Karthikeyan

Ports for windows file sharing

Sharing a folder or file creates a Windows Firewall exception for File and Printer Sharing. The exception opens the ports listed in the following table.

"If the server has NBT enabled, it listens on UDP ports 137, 138, and on TCP ports 139, 445. If it has NBT disabled, it listens on TCP port 445 only."

Connection	Ports
TCP	139, 445
UDP	137, 138

The default scope is to allow access from any computer on the network, including computers on the Internet. Unless you block incoming connections on these ports using a hardware firewall, firewall server, or other Internet-sharing device, your computer will be vulnerable to attack from the Internet as long as your Internet connection is active.

Regards 
கார்த்திகேயன் 
Karthikeyan