Posts

Showing posts with the label make

SQL Make your Database Read Write Only

SQL Make your Database Read Write Only This post help you to make database read/write only,Before make read only be sure that no user is connected to that database.After confirm SP_DBOPTION will successfully set the status of Database. 1) By using ALTER TABLE --SET DATABASE READ/WRITE ONLY If the read-only requirements for the database are temporary, you will need to reset the configuration option following any procedures undertaken. This is achieved with a small modification to the ALTER DATABASE statement to indicate that the database should return to a writeable mode. ALTER DATABASE Database_name SET READ_WRITE The status read-only requirements for the database are temporary, but sometimes we need it for better administrative or Command over multiple user. ALTER DATABASE Test_Manoj set READ_ONLY 2) By using SP_DBOPTION EXEC SP_DBOPTION "Database_name", "READ ONLY", "TRUE" EXEC SP_DBOPTION "Test_Manoj" ,"READ ONLY","TRUE" Th...

SpeedConnect Internet Accelerator 8 0 Full Version How to Make Internet Faster

Image
SpeedConnect Internet Accelerator 8 0 Full Version How to Make Internet Faster SpeedConnect Internet Accelerator 8.0 Full Version is a program that you can use to speed up the Internet connection you use. Your internet connection speed depends not only on hardware and maximum connection speed to the provider you use , but the windows system is also one of the important factors that affect the speed of your internet connection . Perhaps you often experience if you get connection speeds do not match the network you use , when you are using a modem with very good speed and also a laptop with a high spec Benefits FASTER internet connection Browse FASTER Send and receive e-mail FASTER Download and upload files FASTER Play online games FASTER Improve Skype connection NO adware, NO hardware installation NO service subscription, NO monthly fees NO new hardware installation Features Optimizes all internet connection types User friendly Quick Optimiz...

SQL MAKE YOUR DATABASE OFFLINE ONLINE

SQL MAKE YOUR DATABASE OFFLINE ONLINE --SET YOUR DATABASE OFFLINE/ONLINE FOR DISPLAY --THIS COMMAND WILL HIDE --THE DATABASE FROM ALL USER Setting a Database Offline/Online by using 3 way we can do. Way 1.(By using Alter DataBase) ALTER DATABASE download  file  now