Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft...

 Steps to fix access denied files

1. Right-click the file or folder, and then click Properties.
2. Click the Security tab.
3. Under Group or user names, click your name to see the...

Steps to DOWNLOAD SQL Server 2017 Developer Edition-

• One Way to Install SQL Server 2017 Developer Edition
• Open setup .exe
• Pay attention on the Product Key page.
• Accept the license...

To install Microsoft SQL Server 2000 Client Tools, do the following steps:

• Insert the Microsoft SQL Server 2000 Enterprise Edition CD and click SQL Server 2000 Components.
• Click Install Database...

To Fix SQL Server Deadlock follow this process-

1. The only way to resolve a SQL Server deadlock is to terminate one of the processes and free up the locked resource...

Follow this steps to stop Transaction log from growing -

• Create Sample Database in FULL RECOVERY Model.
• Take Full Backup (full backup is must for taking subsequent backup)
• Repeat Following...

The first procedure that can be used is sp_delete_backuphistory. This system stored procedure takes a single parameter - a cutoff date. The 2nd system stored procedure allows you to delete...

The number 50000 is the default value when no error message number is supplied. You said you deleted some databases, it may be an application or service is still trying...

If you have difficulty connecting to an ODBC data source, determine whether the cause of the problem is related to ODBC or to your DTS file:

1. Try to connect to...

Oauth is an authentication protocol and is not relevant for having SSIS talk to SharePoint (SP). .NET ships with both HttpClient and WebClient to talk to HTTP services like SharePoint....

Using SQL Server as a backup for critical business data provides an essential safety net against loss. In addition, backing up data to SQL Server enables business users to more...

Using SQL Server as a backup for critical business data provides an essential safety net against loss. In addition, backing up data to SQL Server enables business users to more...

You can follow the steps to create a linked server for QuickBooks in SQL Server Management Studio by using Object Explorer:

1. Start your Management Studio and choose your SQL Server...