Latest activity

What's new New posts New resources New profile posts Latest activity

K

kumkumsharma posted the thread How can we set maximum MSSQL database size limit? in MS SQL.

You can follow below steps to set the database size limit using SQL Management Studio. Login to your SQL Management Studio. Right click...

Today at 7:30 AM
K

kumkumsharma posted the thread Resolved Error “Upgrade Error - Valid Database compatibility level and successful connection rule” in MS SQL.

When we try to upgrade your SQL server then sometimes it throws below error. "The report server database is not a supported...

Today at 7:29 AM
K

kumkumsharma posted the thread Enable MS SQL server access in php in MS SQL.

To access MSSQL server data from PHP scripts you will need to enable two php extensions SQLSRV extension and PDO_SQLSRV extension. You...

Today at 7:27 AM
K

kumkumsharma posted the thread Steps to change MSSQL server 2008 port in MS SQL.

AS we know Windows VPS default port number is 1533but if we want to change the default port then we have to follow below steps: Login...

Today at 7:25 AM
K

kumkumsharma posted the thread Steps to change MS SQL admin user password in MS SQL.

Here we are assuming that we have hoststud user and we need to change the password of hoststud user with below steps: First login to MS...

Today at 7:24 AM
K

kumkumsharma posted the thread Steps to change Database User's schema in MSSQL in MS SQL.

You can follow below steps: Login to SQL server database. Now right click on particular database and select “New Query” option. After...

Today at 7:23 AM
K

kumkumsharma posted the thread How to disable PHP scripts for sending emails? in MS SQL.

You can easily disable PHP scripts from sending emails to, for that it is must to have root access of your server. You can check below...

Today at 7:21 AM
K

kumkumsharma posted the thread Configure user permission to SQL database user in SQL Server Management Studio in MS SQL.

Database user won’t have enough permission to access all the queries so here we can check how to assign permission to MSSQL database...

Today at 7:20 AM
K

kumkumsharma created the resource Here’s How You can Easily Set Featured Image (Post Thumbnails) in WordPress in WordPress.

WordPress is an excellent platform to run a blog and share information and your thoughts with the world. Most WordPress themes allow you...

Saturday at 4:06 PM
K

kumkumsharma posted the thread Steps to change Database Collation in MSSQL Server in MS SQL.

Collation indicates that how character data will be handled. Collation is a configuration level setting. You can follow below steps to...

Saturday at 4:03 PM
K

kumkumsharma posted the thread Steps to add db_owner role to users in MS SQL.

You can follow below steps to provide db_owner permission to user: Login to server via RDP. Click on Run and then enter...

Saturday at 4:01 PM
K

kumkumsharma posted the thread Steps to Verify MSSQL Server Edition in MS SQL.

You can follow below steps to verify MSSQL edition. Login to Windows VPS server. Open “SQL 2019 Configuration Manager” and here click...

Saturday at 4:00 PM
K

kumkumsharma posted the thread Steps to close active MSSQL connections on server in MS SQL.

You can follow below steps to close active MSSQL connections. Login to your server. Go to SQL server management studio. Here you will...

Friday at 4:28 PM
K

kumkumsharma posted the thread Steps to connect MSSQL server 2012 via SQL Server Management Studio in MS SQL.

Here are the steps to make connection with MS SQL Server 2012: Navigate to Run >> Type SSMS and click on Enter. Now SQL Server...

Friday at 4:26 PM
K

kumkumsharma posted the thread Change Recovery Model of MSSQL database in MS SQL.

In this article we are going to describe the details of changing recovery model on MS SQL database. You can easily change it through SQL...

Friday at 4:23 PM

Show older items