The sp_rename stored procedure is used to rename a column name in a table in MSSQL server database. Syntax: Here is the syntax of the sp_rename stored procedure. [crayon-5d3292c4887f7327412317/] Caution: Changing any part of an object name could break scripts and stored procedures. Example: For example, I have a table named Accounts in the...
This can be an important query for your while debugging slowness of SQL server. This will help you find currently running SQL queries on SQL Server. You can find which queries are running from a long time and utilizing CPU. To run this query, start SQL Server Management Studio, Open New Query window and...
Using SQL Query Window: Use WITH REPLACE option with the RESTORE command on MSSQL query window. Change database name and backup file location as per your setup. USE MASTER GO RESTORE DATABASE MyDB FROM DISK = 'C:\Backups\MyDB_15082016.bak' WITH REPLACE GO
Command Syntax: aspnet_regsql.exe -ssadd -sstype p -S {SQL Instance} -U {Username} -P {Password} After installing .Net Framework on your system, open windows command prompt and navigate to framework installation directory as per your installed version of .net framework and system architecture. c:> cd "%windir%Microsoft.NETFramework64v4.0.30319" Directory path may be change as per your installation like...
Amazon SQL Server RDS Instance doesn’t support to restore data from .bak files. So using this article I am writing to how to migrate your SQL server database to Amazon RDS instanace with easy steps. If you looks on AWS migration steps its too complicated, But windows Azure migration wizard tools provide an easier...
Sometimes SQL Server logs files acquire a large space on disk. In that case, we need to reduce the size of the log file to claim some space. But truncating or reducing database log file in SQL Server 2008 can be quite difficult. It also has its own issues. This article contains a set...