SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use.

Hi This post describes how to delete a user-defined database in SQL Server Management Studio in SQL Server  by using SQL Server Management Studio or Transact-SQL.

Using SQL Server Management Studio

To delete a database

1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
   
2. Expand Databases, right-click the database to delete, and then click Delete.
   
3. Confirm the correct database is selected, and then click OK.

Using Transact-SQL 

To delete a database

1. Connect to the Database Engine.
   
2. From the Standard bar, click New Query.
   
3. Copy and paste the following example into the query window and click Execute. The example removes the Sales and NewSales databases.
   
   

   USE master ;
   GO
   DROP DATABASE Sales, NewSales ;
   GO

If you are Receive Below Error Message   

Msg 3702, Level 16, State 3, Line 2
Cannot drop database “DataBaseName” because it is currently in use. 

Fix/Workaround/Solution:

Close SQL Server Management Studio completely. Open it again and connect as normal. Now you will be able to drop the database with
 

Conclusion
If you want to drop the database use master database first and then drop the database.

Thanks

R.karthikeyan

Get a second shot at your Microsoft Certification for free

Thinking about starting or upgrading your Microsoft certification? Still undecided about scheduling that exam? It’s no secret that it takes time, preparation, and commitment to pass all the required exams to achieve a certification milestone, and Microsoft want to help you. That's why Microsoft so excited to bring back Second Shot!

For those who are newer to our community: the return of Second Shot is great news for MCPs (and aspiring ones) because it means being able to retake an exam for free. Just knowing there's a chance to do-over at no cost can make a big difference on exam day.

This round of Second Shot applies to individual technical (070 and 071 beta) and commercial MTA (098) exams. Here are two ways to get your Second Shot voucher:

• Directly from us at http://aka.ms/SecondShot
• Purchase vouchers after you complete a technical training program from a Microsoft Learning Partner or IT Academy

Both the initial exam and the retake have to be done no later than May 31, 2014, so find yourcertification path and get started soon!

Thanks

R.karthikeyan

FTP Server Interview Questions Answers in windows

How much data can be send in a Single FTP session?
The amount of data which can be send is infinite. FTP uses TCP. The TCP channel can be used until the complete data is transferred. Multiple TCP segments can be used within the same TCP channel.

How does Active FTP communication Work?
When a FTP client initiates a connection with FTP server in Active FTP mode, initially the FTP client initiates tcp 3 way handshake with the FTP server. This is initiated to port 21 on the server and is referred to as the control connection. Once the control connection is successful, the client responds with the port command to the server, which contains the port number to which the server needs to initiate the second TCP connection. The server initiates the connection ( 2ND tcp 3 way handshake) from port 20 on it to the port number provided by the client. This is known as data connection. Once the data connection is successful, the data transmission can commence.

How many TCP connections are used by Active and Passive FTP Respectively?
Both Active and Passive FTP uses two TCP connections

Why does Active FTP not work when a firewall is involved between the client and the server?
In Active FTP, once the FTP client establishes the connectivity with the server, the server initiates the data connection to the client. This is a TCP connection which is initiated from a system (FTP Server) which resides outside the network. All traffic initiated from outside is considered as untrusted, and the firewall would drop it by default.

How does Passive FTP resolve the issue with firewalls?
In Passive FTP, the FTP client initiates the connection with the server and not the FTP server with the client. Since the client is residing within the network, the connection is considered as trusted by the firewall.

In Active FTP, which TCP port is used for initiating the control channel?
Port 21

If you want to know about FTP  like how it's working? or different connection mode you can refer my previous post  

Difference between Active and Passive Connection Mode in FTP

Conclusion About FTP -


FTP uses one connection for commands and the other for sending and receiving data.  FTP has a standard port number on which the FTP server "listens" for connections.  A port is a "logical connection point" for communicating using the Internet Protocol (IP).  The standard port number used by FTP servers is 21 and is used only for sending commands.  Since port 21 is used exclusively for sending commands, this port is referred to as a command port. For example, to get a list of folders and files present on the FTP server, the FTP Client issues a "LIST" command.  The FTP server then sends a list of all folders and files back to the FTP Client.  So what about the internet connection used to send and receive data?  The port that is used for transferring data is referred to as a data port. The number of the data port will vary depending on the "mode" of the connection.  (See below for Active and Passive modes.)

Difference between Active and Passive Connection Mode

The FTP server may support Active or Passive connections, or both.  In an Active FTP connection, the client opens a port and listens and the server actively connects to it.  In a Passive FTP connection, the server opens a port and listens (passively) and the client connects to it.  You must grant Auto FTP Manager access to the Internet and to choose the right type of FTP Connection Mode.

Most FTP client programs select passive connection mode by default because server administrators prefer it as a safety measure.  Firewalls generally block connections that are "initiated" from the outside.  Using passive mode, the FTP client (like Auto FTP Manager) is "reaching out" to the server to make the connection.  The firewall will allow these outgoing connections, meaning that no special adjustments to firewall settings are required.

If you are connecting to the FTP server using Active mode of connection you must set your firewall to accept connections to the port that your FTP client will open.  However, many Internet service providers block incoming connections to all ports above 1024.  Active FTP servers generally use port 20 as their data port.

 It's a good idea to use Passive mode to connect to an FTP server.  Most FTP servers support the Passive mode.  For Passive FTP connection to succeed, the FTP server administrator must set his / her firewall to accept all connections to any ports that the FTP server may open.  However, this is the server administrator's problem (and standard practice for servers).  You can go ahead, make and use FTP connections.

                      

Once the FTP Client manages to open the internet connections, one for command and one for data, it starts communicating with the FTP server.  You are now ready to transfer your files and folders between the two connected computers with Auto FTP Manager.

Below image is Example  of both Active and passive connection mode how it is works.
                                  




                                   


Thanks
R.karthikeyan