Information

When we try to open a large Sql file in SQl Server, it's gives the error "The operation could not be completed. not enough storage is available to complete this operation The template specified cannot be found. Please check that the full path is correct" Solution: use the  sqlcmd  tool to execute the file. To execute a SQL script: Start the Command Prompt Run the below command   sqlcmd -S DatabaseServer -d Database -i C:\Users\Administrator\Downloads\script.sql -x

Committing inner transactions is ignored by the SQL Server Database Engine. The transaction is either committed or rolled back based on the action taken at the end of the outermost transaction. If the outer transaction is committed, the inner nested transactions are also committed. If the outer transaction is rolled back, then all inner transactions are also rolled back, regardless of whether or not the inner transactions were individually committed.