Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
"Erase Phantom System Health Records" being failed in job "syspolicy_purge_history""Value cannot be null" error when trying to edit or create Maintenance Plan in SQL Server 2008[SQLSTATE 42000][Error 4834] - SQL Agent Job failingA network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or accessible... (Microsoft SQL Server, Error: 1225)Access Denied when running simple queryALTER LOGIN for SA fails with 15151 error SQL Server 2008 R2An error appearing in attaching a database in the SQL softwareBackup while database is in use?BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'CA_BAB_MSSQL_e85860_10001_2085d987_ERP_DATABASE_ST_1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application requeBCP error SQLState = S1000, NativeError = 0, Error = [Microsoft][SQL Server Native Client 10.0]Unable to open BCP host data-file".Can a large log file impact query performance?can we create pdf from an sql query at run timeCannot drop user who is a Schema ownerCannot execute as the server principalCannot get db mail to work via SMTP Relay for Office 365 in SQL Server 2014 on Windows Server 2012 R2Cannot navigate to some folders when attempting to attach .MDF files to database in Management StudioCannot restore database to new database serverChanging user name in Active Directory still reflects old username in SQL 2008 R2Clear events in file target?Clustered Instance is not connecting in SQL Management Studio on a Passive nodeCorruption in database ID 5, object ID 60 possibly due to schema or catalog inconsistency. Run DBCC CHECKCATALOG.Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file. (System.IO.FileNotFoundException).Database backup file size is too small compare to actual database sizeDatabase Mail sending email problemDatabase mail failure. Exception Message: Cannot send mails to mail server. (A recipient must be specified.)Databases in Recovery Pending stateDB is stuck in Single-user mode- SQL server 2012DBCC CHECKDB Pages is marked with the wrong type in PFS page do DBCC CHECKDB ([MSDB], REPAIR_ALLOW_DATA_LOSS) but appear new SGAM and PFS errorsDBCC SHRINKDATABASE failsdelete a user from all DBsDifferenece between sys.Objects and sysobjects in SQL Server 2005 ?Drawbacks of Partitioning the databaseError message ? - SQL Server Message: TCP Provider: An existing connection was forcibly closed by the remote host.Error Msg 4861 when execute bulk insertException Message: Cannot send mails to mail server. (The remote certificate is invalid according to the validation procedure.).EXEC msdb.dbo.sp_send_dbmail is not sending emailEXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'Failed database back-upFailover cluster not moving on 2nd NodeFatal error during SSMS installation (0x80070463)Forgot 'sa' passwordHigh CPU Usage on full backupHow can I clear results screen in SQL Server Management?How can I use [fn_listextendedproperty] to list extended properties on columns?How to compress DB backup file with sql queryHow to find out SQL server is installed on a VM or Physical machineHow to find what is filling up pagefile.sys?How to grant user rights to Create, Alter and Execute stored procedures only?How to hide a table or mask or hide the rows in sql server 2012/14How to overwrite SQL Backup by ScheduleIdentity will increase even after transaction Rollbackif the Database Mail Status is retrying then what happens in SQL ServerImpact on DB to shrink a 130GB log file?instance names of the SQL Server ?Job History is not appearingLet a user restore databaseLIinked Servers: OPENQUERY and maximum length of the stringLinked server in SSMS return error "Requested conversion is not supported."Loading data from CSV file into Multiple TablesLogin Error Message User PermissionLogin failed for user xxxx Reason: Could not find a login matching the name providedLogin failure for user - error 18456MDF and LDF files not removed after DELETED or DROP databasesmoving tempdb log fileMsg 3234 on RESTORE DATABASERebuild Index does not defragmentRecycle bin in SQL server.Reduce initial size of .mdf file of a databaseRemote connect to Windows Internal Database from another serverReserved(KB) space in particular table .Restricting what databases a user can see in SQL Management StudioRun SSMS as different userScript to find who are assigned to SQLAgentOperator, SQLAgentReader and SQLAgentUser RolesSet primary key grayed outSPN for trusted domainSQL database, shrink transaction log - Is this safe?SQL Query for Trailing Twelve MonthsSQL Server 2008 - Backup Failing with error 1, reason 15105SQL Server 2008 Management Studio - Edit top 200 RowsSQL Server 2008R2 fulltext logfile SQLFT*.log maintenanceSQL Server 2014 - Restart from SSMS failsSQL server 2016 db Restore taking long time, how to catch root cause ?SQL Server 2017 sa default passwordSQL Server Alert System: 'Severity 016' occurred on \\SQL-ServerSql server cache fileSQL Server Configuration Manager - SQL Server 2017SQL Server Database Backup ErrorSQL Server Management Stdio has detected that an operation is blocking user inputSQL Server Management Studio not saving passwordSQL Server MaxTransferSizeSQL Table Space After Large Delete - Space Not Released in tableSqlManagerUI Error on executing an maintenance planSSMS 18 -- how to uninstall?SSMS 18.0 startup error "Failed to Open Connection Dialog. Object reference not set to an instance of an object."SSMS 18.3.1 Column width is not auto sizingSSMS error "cannot find one or more components. Please reinstall the application"SWITCH LAST NAME TO FIRST NAME SQL QUERYSystem.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.TempDB Full – How to ClearThe certificate, asymmetric key, or private key file is not valid or does not exist; or you do not have permissions for it.The fastest way to rebuild indexesTorn Page in sql serverUnable to backup SQL server 2016: VSS Inconsistent shadow copyUnwanted backup initiated by NT AUTHORITY\SYSTEMVarious errors when Maintenance Plan tries to send email but test email worksWait Type PAGEIOLATCH_SH and PAGEIOLATCH_EXWhat data does CEIP service for Sql Server Services collects and how to disable the services in services.mscWhere to download Sqlwriter?xp_delete_file() returned error 2, 'The system cannot find the file specified.'xp_instance_regwrite on SQL Server 2016