The Curious Engineer

All blogs / Databases

Microsoft SQL Server Tips & Tricks

learn.microsoft.com/en-us/archive/blogs/sqlserverfaq

Tips and Tricks for the SQL Server Enthusiast

DatabasesMicrosoft blogsMSDN archive

’10’15’20’25
Posts
325 from 27 Apr 2008 to 22 Jan 2017
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sqlserverfaq/feed.xml

2017 2

  1. Automate SQL server backup file removal/deletion from Azure blob storage
  2. Automated backups configuration fails when configured from Azure portal

2016 4

  1. Error: Could not deploy package. Unable to connect to target server.
  2. Troubleshooting SSL on SQL Server Issue - AT_KEYEXCHANGE is not set
  3. Creating and Registering SSL Certificates
  4. SQL Server Service fails to start after applying patch. Error: CREATE SCHEMA failed due to previous errors.

2015 4

  1. Setting up Service Broker where the initiator database is part of the AG
  2. Error configuring distribution- "Publishing and distribution are supported only in SQL Server version 7.0 or later"
  3. How to find which user deleted the user database in SQL Server
  4. Snapshot agent fails with Error: 241, Severity: 16, State: 1 (Conversion failed when converting date and/or time from character string)

2014 8

  1. Common issues faced while configuring AlwaysOn listener on Azure VM cluster
  2. Capture successful logins: You may see many entries(high volume) when you create Audit for SUCCESSFUL_LOGIN_GROUP action group
  3. Script level upgrade for master database failed
  4. Merge Replication: Expired Subscription Clean Up Job / sp_expired_subscription_cleanup / sp_MScleanup_conflict fails with error Msg 1934, Level 16, State 1 AND Msg 20709, Level 16, State 1, Procedure sp_MScleanup_conflict…??
  5. SQL Server 2014 Setup Error: 'BIDS' is not a valid value for setting 'FEATURES'
  6. Troubleshooting : Error: 8624, Severity: 16, State: 21. Internal Query Processor Error: The query processor could not produce a query plan.
  7. Can I decrypt TDE enabled database if I have access to the master database’s mdf and ldf files or the master database backup?
  8. How to move databases configured for SQL Server AlwaysOn

2013 8

  1. How to configure Always On for a TDE database
  2. How to compare the rows of two tables and fetch the differential data.
  3. Upgrade from SQL 2005 to SQL 2012 fails with error “Service 'SQLSERVERAGENT' start request failed.”
  4. How do I map a differential/transaction log backup to its full backup without using MSDB?
  5. Change Data Capture gets disabled when you break mirroring and bring the database online
  6. Do NOT delete files from the Windows Installer folder
  7. How to monitor deadlock using extended events in SQL Server 2008 and later
  8. Ventured into BULK INSERTS

2012 25

  1. How to Login to SQL Server with NT AUTHORITYSYSTEM using PSExec Tool
  2. How to limit connections to SQL Server until all databases are ONLINE!
  3. Why to look at "Wait Statistics" to troubleshoot SQL Performance
  4. SQL server 2008 Filestream
  5. Troubleshooting SQL server High CPU : Part 2
  6. Troubleshooting SQL server High CPU : Part 1
  7. Product Update Feature in SQL Server 2012
  8. Introduction to Sparse Columns
  9. High Availability for SQL Server Replication using Database Mirroring
  10. Missing MSI's/MSP's error during SQL Server Patching
  11. Bulk insert command fails to insert the correct characters?
  12. Can TLS certificate be used for SQL Server encryption on the wire???
  13. Failure of SQL Server 2008 Installation due to MSI error
  14. SQL Server Replication
  15. INF: SQL Server Compressed backup may work fine if disk space is less and may fail if disk space is more
  16. An interesting find about Temp tables in SQL Server
  17. INF: AlwaysOn – The secondary database doesn't come automatically when the primary instance of SQL Server goes down
  18. INF: Limitations for SQL Agent when you have many Jobs running in SQL simultaneously
  19. Table partitioning concepts with sliding window example
  20. SSL Encryption for SQL Server
  21. What's Data Collector
  22. INF: You may not be able to change the Design of a Table (Insert or Delete a Column) using GUI.
  23. Policy Based Management
  24. Hey Mr. SSMS! Why I am unable to open .sql files using by double click
  25. NORECOMPUTE : Can lead to SQL server performance degradation!!

2011 46

  1. Procedure Cache-Part II
  2. Procedure cache - Part I
  3. Troubleshooting Kerberos Delegation Using DelegConfig
  4. What's execution log in Reporting services?
  5. Transparent Data Encryption (TDE)
  6. Demystifying SQL server memory concepts video
  7. SQL server service pack installation may fail if your instance name is a Windows reserved word
  8. Multiserver administration
  9. SQL Server could not create a subscription for Subscriber 'ServernameInstanceName'.The value for the @sync_method parameter is not valid
  10. DDL Triggers
  11. The mystery of incorrect filegroup size
  12. Creating stoplist on database of compatibility 80/90 in SQL server 2008
  13. Another reason of Index logical fragmentation!
  14. Implementing SSL encryption for SQL Server in a DNS forwarding environment
  15. SQL Server Deadlocks Due to Character Data Type Conversion When Using SQL Server JDBC drivers
  16. Moving data from the mdf file to the ndf file(s)
  17. How to Convert UTC Time to Local Time in SQL
  18. What's Performance Dashboard and how it can help in troublehsooting SQL issues.
  19. What are SQL server audits - a new feature in SQL server 2008
  20. What are plan guides and how it could help in managing performance of the queries
  21. Managing SQL resources using resource governer
  22. Whats the backup compression in SQL server 2008 and how it can help to optimize the speed/size of the backup
  23. Problems may occur when you try to install SQL Server 2008 R2 Shared Features if the %TEMP% folder is Encrypted.
  24. What are Virtual log files - VLF in SQL server - video
  25. Implicit conversions and their implications on the SQL query execution
  26. INF : Restore Database UI fails with error: "Length cannot be less than zero. Parameter name: length"
  27. INF : How does Logical Record Feature Works in Merge Replication
  28. INF: SQL Server Extended Stored Procedures & behaviour change starting with Windows 2008
  29. INF: Hey, my SQL Server Service is not starting – what do I do?
  30. Errors Raised with Severity/Level 16 May Cause Transactions into Doomed State
  31. Presentation Material for Webcast on Performance Dashboard
  32. Presentation Material for Webcast on SQL Server Full Text Search
  33. Presentation Material for Webcast on SQL Server Resource Governor
  34. Service broker concepts and troubleshooting
  35. How to configure and monitor log shipping in sql server
  36. SQLDIAG: There are no instances of version 10 on this computer
  37. INF: How to retrieve data from a large XML string
  38. SQL server 2008:Declarative Management Framework-DMF
  39. SQL server 2008: Change Data Capture
  40. SQL server 2008: Extended events
  41. SQL server 2008 clustering using Hyper-V-Video
  42. PRB: SQL Backups to a UNC path fail with OS Error 1 (Incorrect Function)
  43. SQL Nexus and RML Utilities: A primer on the issues that I have dealt with last year
  44. Unable to read trace definition file Microsoft SQL Server TraceDefinition n.n1.n2.xml
  45. Case Study: Troubleshooting a Slow Log Shipping Restore job
  46. Using Bulk Logged recovery model for Bulk Operations will reduce the size of Transaction log backups – Myths and Truths

2010 80

  1. Microsoft SQL Server 2005 Service Pack 4 Released!
  2. SQL Server Denali - AlwaysON (HADR): Step-by-Setup setup guide
  3. SQL Server 7.0 support to end on 11 Jan 2011
  4. SQL Server 2008 Best Practices Analyzer (SQL BPA) - Video
  5. Unable to connect to SQL , “Error executing extended stored procedure: Invalid Parameter (Microsoft SQL Server, Error: 22001”
  6. RESTORE DATABASE fails while trying to restore password protected backup set from SSMS
  7. SQL Server Backup Simulator
  8. Troubleshooting specific Login Failed error messages
  9. SQL Server 2008 service fails to start, after applying Service Pack 1
  10. Troubleshooting tempdb growth due to Version Store usage
  11. Scan Count meaning in SET STATISTICS IO output: Part 2
  12. Sometimes Replication Monitor shows number of Undistributed Transactions as a very high number, but replication itself works properly.
  13. Upgrade to SQL 2008 from 2005 (cluster) fails with The cluster group 'SQL GROUP' could not be moved from node 'NODENAME1' to node 'null' , 0x8007139F
  14. Upgrade from SQL Server 2008 to SQL Server 2008 R2 might fail with the error “Wait on the Database Engine Recovery Handle Failed”
  15. We would like your feedback !
  16. SCAN COUNT meaning in SET STATISTICS IO output
  17. Troubleshooting Error 511 using XEvents
  18. OPEN SYMMETRIC KEY command prevents query plan caching
  19. HOW TO IDENTIFY COMPRESSED TABLES BEFORE RESTORING/MIGRATING DATABASE to any edition other than Enterprise Edition of SQL Server 2008
  20. PRB: SQL Server Browser service does not start due to Winsock Monitoring Software
  21. INF: SQL Security - Restricting access to public on server/database objects, its implications and ownership chains
  22. TRANSACTION LOG BACKUP and RESTORE SEQUENCE: Myths & Truths
  23. The hidden gems among DMVs: sys.dm_os_sys_memory
  24. While Installing SQL 2005 Express Edition we hit the error -- The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <Computer Name> Error:2147749896 (0x80041008)
  25. How to set Soft-NUMA for SQL Server 2008 R2
  26. Can I listen to you Mr. MSDTC?
  27. SQL Server 2008 R2 setup fails on Windows 7 with the error: Version's parameters must be greater than or equal to zero
  28. The bcp utility fails to export the data:
  29. INF: Permissions required for SQL Server Service account to use SSL certificate
  30. Installing Client tools for SQL 2008 doesn’t populate the SMO in the SQL Assemblies folder
  31. Backup Software fails to take System State backup if SQL server VSS writer Service is running
  32. Unable to see the properties of DTC in the Component Services
  33. A query in SQL Server Management studio could fail with Error: "An error occurred while executing batch. Error message is: The file exists
  34. Monotonically increasing clustered index keys can cause LATCH contention
  35. GUID vs INT Debate
  36. SQL Server Performance Dashboard Reports in SSMS – Introduction, Install, DateDiff error & Modified for SQL 2008
  37. SQL Express 2005 Setup Failure
  38. INF: New SQL Server features in SQL Server 2008 R2 –Part 2
  39. INF: New SQL Server features in SQL Server 2008 R2 – Part 1
  40. SQL 2008 R2 CTP3 Upgrade directly to RTM.
  41. Incorrect BufferCount data transfer option can lead to OOM condition
  42. How to “REGENERATE DEK” with a different certificate on Encrypted Mirrored database
  43. SQL Server Agent cannot start because the instance of the Server Instance is not the expected Instance
  44. SQL Server 2008 & SQL Server 2008 R2 clustering FAQ’s:
  45. Unable to install Service Pack 1 for SQL Server 2008.
  46. Unable to open excel files using a cscript in SQL Server Jobs
  47. Unable to configure Logshipping
  48. How to install Clustered SQL Server 2008 on Windows 2008 Cluster using Hyper-V (Guest Clustering) Part – 2
  49. How to move Publication database and Distribution database to a different location
  50. How to restore database backup (Full and Transaction logs) after regenerating Database Encryption Key (KEY) with a new certificate having no impact on Log sequence number (LSN) chain.
  51. Network Binding Order Rule Warning in SQL Server 2008 Cluster Setup Explained
  52. SQL Server 2005 setup fails on windows 2008 due to corrupt VC++ component
  53. sp_help_log_shipping_monitor may return the following error after role reversal in SQL 2000/2005 : Violation of PRIMARY KEY constraint <constraint name>. Cannot insert duplicate key in object 'dbo.#log_shipping_monitor'
  54. How to un-cluster SQL Server 2005 Cluster
  55. DB Maintenance: Rebuild Index Task always fails on OperationsManagerDW [SCOM database]
  56. Unable to connect to SQL Server immediately after applying Service Pack /Cumulative updates.
  57. SQL Server 2005 Setup Failure on Cluster Due to Corrupted User Profile
  58. Unable to create a login in SQL Server 2005 and we get the following error The server principal '[<Domain><Machine account>$]' already exists.
  59. Step by Step Guide to Setup a Dedicated SQL Database Mirroring(DBM on dedicated Nic card)
  60. Unable to connect to SQL Server 2008 instance after applying SP1
  61. SSAS Profiler Scheduler
  62. SQL Server 2008 Setup fails to Install with Error 1402
  63. How to install Clustered SQL Server 2008 on Windows 2008 Cluster using Hyper-V (Guest Clustering) Part – 1
  64. Unable to connect to Enterprise Manager in SQL Server 2000
  65. Unable to connect to SQL Server 2005 from Backupexec application
  66. SQL Server encounters memory pressure and generate 701 Error due to incorrect configuration of Service Broker
  67. Installation for SQL Server 2008 Management studio fails with the MSI error code: 0x5EBE5729
  68. SQL Server 2008 Slipstream Setup on Windows Cluster May Fail With “The system cannot find the path specified”
  69. Configuring Database Mail failing with error - @no_credential_change is not a parameter for procedure sysmail_update_account_sp. (Microsoft SQL Server, Error: 8145)
  70. Slipstreaming SP1 with SQL Server 2008 Express edition advanced services is not possible
  71. Database Mail failing with “The service queue "ExternalMailQueue" is currently disabled.” message
  72. SQL Server 2008 Configuration Manager on a 64 bit machine does not display Network configuration & Native Client configuration options
  73. How to use -UseInProcLoader in Distribution agent and get it working
  74. BCP in SQL server 2005 does not truncate a column
  75. SQL Server 2005 Management Studio setup - An error occurred during the installation of assembly Microsoft.MSXML (HRESULT: 0x80070003)
  76. How to find who is using / eating up the Virtual Address Space on your SQL Server
  77. EVENTDATA function behavior for DLL Triggers related to Logins
  78. SQL FTS IFilters, its security implications and troubleshooting PDF Filter issues
  79. Installation/Upgrading of SP4 on MSDE fails with 'Error: 0x800401F0'
  80. Drop failed for Login since it has granted one or more permission(s)

2009 111

  1. Error messages and the solutions related to “distributor_admin” login
  2. Unable to install SQL Server 2005 on a Windows XP machine
  3. Unable to view Error logs in SQL Server Management Studio on a cluster
  4. Data Capturing and Analysis using SQL Server 2008 Activity Monitor and SQL DMV’s
  5. Why do we need SPN for File Server (NAS / RAS / File Share System) DNS Alias (Cname)
  6. SQL 2005 (SQL 2008) Analysis Services Server Side Tracing
  7. Connectivity fails while executing queries against SQL through VBA code
  8. Installation of Service Pack 3 for Reporting Services 2005 fails on a cluster with an error code 2228
  9. Installation of Non-MS Fonts cause .NET errors during SQL server 2005 setup
  10. Issues with SQL Server Login Failures and dependency on Windows Password Policy Check
  11. On a Clustered SQL Server 2005 running on Windows 2003 machine the maintenance plan MIGHT fail with: “The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired)”
  12. Executing BCP fails with SQLState = 37000, NativeError = 4891. Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Insert bulk failed due to a schema change of the target table
  13. You encounter report server connection failure with below error message. Below is one of the instance which I witnessed while connecting through SSMS, it fails while using the server name (SERVERNAMEABC)
  14. SP_COLUMNS take longer in SQL Server 2005 SP3 compared to SQL Server 2000
  15. Unable to open the configuration manager in SQL server 2005
  16. Sql Server 2005 Resource Taking long time to come online on Windows Cluster with Resource Manager Creation Failed reported in Errorlog
  17. Script to find the Objects Owned by Orphaned Users
  18. Receive a warning about the network binding order on the Setup Support Rules page when install SQL Server 2008 in a failover cluster
  19. How to identify Orphaned Logins and Objects owned by Oraphaned Logins
  20. How to change the Service account and restart the Service using WMI.
  21. Performance Benefits of using Expression over User Defined Functions
  22. Cannot Alter Schema of Replicated Article
  23. Behavior of WITH NOWAIT option with RAISERROR in SQL Server
  24. SQL Server 2005 Integration service upgrade fails from RTM to SP3 however Database service succeeds
  25. Stemming Functionality in Full Text Search using CONTAINS
  26. BCP command fails with ERROR:"User name not provided…", when both SQL Server 2000 and SQL Server 2005 Tools are installed on machine
  27. SQL browser service is not running on server.
  28. OOM error when we access Schema changes report from SSMS
  29. SQL Server Analysis Services Port (SQL 2005 / 2008)
  30. A delete statement in SQL Server 2000 takes around 1.5 GB of Transaction Log Space, Where as in SQL 2008 it can take around 3.2 GB!
  31. Installation of SQL 2005 on Windows 2003 Cluster fails with error "The drive specified cannot be used for program location. Program files must be installed on a valid local disk available on all cluster nodes"
  32. Sometimes you do not see the proper event description of SQL Server events in the application log
  33. Query to the SYSTEMINDEX to read the Microsoft search results fails when using Search.CollatorDSO provider
  34. Unable to failover a Named instance of SQL server 2005 in cluster or unable to bring a Named Instance of SQL server 2005 Online
  35. Unable to install SQL Server 2008 Standard Edition on a Windows VISTA machine
  36. INFORMATIONAL: Understanding and Troubleshooting MSP Error: 29512 SQL Server Setup was unable add user <DomainUsername>, when you try to install SQL Server 2005
  37. DTS PACKAGE FAILS TO OPEN WITH ERROR [Dbnetlib][ConnectionRead (WrapperRead()).] General network error
  38. Analysis Services Preallocate Memory Setting – Insight
  39. SQL Server 2008 Profiler pads the datetime datatype with 0s when tracing for a ADO.Net application
  40. How to change the IP ALL TCP Port to a static port from a Dynamic Port using WMI
  41. Unable to run a job in SQL server 2000 service pack 4
  42. How to impersonate the privileges to create a login using the Stored procedures using “EXECUTE AS” clause
  43. Upgrade advisor returns error while upgrading an instance of SQL Server 2000 to SQL Server 2005.
  44. Error: SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)SSMS
  45. Tampering master.vmp file may result in losing all Analysis Services Databases:
  46. Installing Hotfix on SQL Server may throw error 29538 and fail
  47. BCP command calling Stored procedure with dynamic SQL and not having the first statement as a Select fails with the following Error "Error = [Microsoft][SQL Native Client]BCP host-files must contain at least one column"
  48. Exception when selecting from SYSINDEXES in SQL Server 2005
  49. How to uninstall HOTFIXES manually when the base SQL 2000 is not there in the box
  50. Upgrade from SQL 2005 to SQL 2008 might fail with MsiGetProductInfo error
  51. Unable to start SQL Server Agent
  52. Owner of the job will not be able to modify/edit the job In SQL SERVER
  53. Attempt to take Differential or Transaction Log backups using SQL DMO in a job goes for full database backup always
  54. Merge Agent fails with The Merge failed to retrieve the snapshot schema script - Merge Replication with Web Synchronization using FTP Over Internet
  55. BCP Command using code page 65001 fails, if both SQL Server 2000 and SQL Server 2005 tools are installed
  56. The "Instance to upgrade" option does not appear when we upgrade the SQL server from 2005 to 2008
  57. SQL Express setup : No user input screen appears .. The setup advances to last screen and then Hangs
  58. Unable to debug Stored Procedure on a Server from the Client Machine
  59. SP_SHOWPENDINGCHANGES WON’T SHOW OUTPUT IF SUBSCRIBER DATABASE NAME IS SAME AS PUBLISHER DATABASE NAME
  60. Size of the Transaction Log Increasing and cannot be truncated or Shrinked due to Snapshot Replication.
  61. SQL SERVER 2000 INSTALLATION/UNINSTALLATION ISSUES ON STANDALONE/CLUSTERED ENVIRONMENT
  62. INFO: SQL 2000 MSDE installation will fail if you have number of CPUs on a box which is not in power of 2.
  63. Data type precedence while using UNION statement differs in behavior between SQL Server 2000 and SQL Server 2005
  64. How to determine the space used by the system and user objects in Microsoft Sql Server 2005
  65. SQL Server Management studio issues
  66. The installation of client tools in sql 2005 fails with error 1722
  67. UPDATE Statements May Fail To Replicate If Not Executed As Singleton Updates
  68. Reporting Services 2005 installation option is grayed out
  69. Is SQLVDI.DLL functioning properly?
  70. INFORMATIONAL: SHEDDING LIGHT on VSS & VDI Backups in SQL Server
  71. configure distribution wizard does not appear while trying to configure Distribution in SQL 2005
  72. SQL server2000 IA64 Setup on a cluster may fail with an unexpected error
  73. Unable to upgrade from SQL Server 2000 to SQL Server 2005
  74. Performance of a Query on Computed Column can degrade in Sql 2005 with the increase in complexity of function in computed column
  75. Orphaned Users with Database Mirroring and Log Shipping
  76. How to find out which database was backed up by which maintenance plan
  77. SETTING THE APPLICATION ROLE CAN CAUSE IS_MEMBER TO return NULL
  78. Changing the schema of an article from DBO to UserDefinedSchema will be reverted back to DBO
  79. SQL Server 2005 SP2 setup might fail with the error Error 29528: The setup has encountered an unexpected error while Updating security settings on HTTP services
  80. Setting up Database mirroring in SQL Server 2008 using T-SQL when the database is encrypted using Transparent Data Encryption.
  81. How do we implement encryption and hashing in SQL server?
  82. Can’t understand the difference between hashing and encryption?
  83. Transaction Log Shipping Status Report for monitor server will not pull up information if alias is used for monitor server
  84. INFORMATIONAL: FULL TEXT SEARCH ENGINE & FULL TEXT INDEX POPULATION INTERNALS
  85. How to list all the installed SQL Server on the Server using TSQL
  86. SQL Server 2005 Setup Failing to Install on Cluster when we use an underscore in the virtual cluster name
  87. What should we do when the sql server performance counters are missing
  88. Unable to create Maintenance Plans or DBMail Fails after service pack/Hotfix is applied on SQL Server 2005 fail over cluster instance running on Windows 2008 cluster
  89. BCP Field terminator character changing automatically
  90. HOW TO DETECT SQL SERVER INSTANCES / FEATURES INSTALLED ON A MACHINE
  91. HOW TO MANAGE SQL SERVER 2000 Services USING WMI
  92. Default database role members are not scripted when we use the "Generate Script Wizard"
  93. SQL SERVER 2000 CLUSTER FAILS TO COME ONLINE ON CLUSTER AFTER APPLYING SECURITY PATCH oN WINDOWS SERVER
  94. Error:The connection does not support enlisting in distributed transaction.
  95. Part – 2 : SQL Server 2005 Patch Fails to install with an error "Unable to install Windows Installer MSP file"
  96. How to backup SQL Server databases to a mapped drive
  97. Sql Server Resource Fails to come online on Cluster with Error Error Locating Server/Instance Specified [xFFFFFFFF]
  98. HOW TO CREATE A BASIC CLR FUNCTION TO EXECUTE AS A SP IN SQL SERVER
  99. How to change the collation of all the existing objects at once inside a database after upgrading to SQL 2005?
  100. FAILED TO DROP Full TEXT Catalog ON A DATABASE after upgrading to sql server 2005
  101. Cumulative update 10 fails to install on sql server 2005 sp2 WITH operating system error 3
  102. SQL SERVER 2005 INSTANCE FAILING TO INSTALL AFTER TRYING TO REINSTALL WITH ERROR 1603
  103. How to reapply SQL 2000 SP4 to update all the 13 scripts
  104. Part – 1 : SQL Server 2005 Patch Fails to install with an error "Unable to install Windows Installer MSP file"
  105. Queries May Appear to Run Slow on SQL SERVER COMPACT EDITION v3.1 Database
  106. SQL SERVER 2005 RESOURCE FAILS TO COME ONLINE ON CLUSTER AFTER CHANGING THE SAN DRIVE TO ADD MORE DISK SPACE
  107. DTS PACKAGE THAT EXPORTS RESULTS TO EXISTING EXCEL WORKBOOK APPENDS THE DATA INSTEAD OF OVERWRITING
  108. SQL SERVER 2000 CLuster FAILS TO COME ONLINE ON OTHER NODE
  109. SQL SERVER 2005 SP3 Install Fails with Error 1612: Unable to install Windows Installer MSP file
  110. Issue with constraints on the subscriber in Merge Replication
  111. Why Do I see more threads per SPID in sysprocesses than MAXDOP?

2008 37

  1. Log Reader Agent Fails with the Error “The Log Reader Agent failed to construct a replicated command from log sequence number (LSN)”
  2. Did you know... Merge Replication Fails with Error 'Unable to synchronize the row because the row because the row was updated by a different process outside of replication.'
  3. SQL Server 2005 Setup Failing to Install on Cluster with Unexpected Failure while Performing the SCC checks
  4. Did you know... Auditing using DDL Trigger in SQL Server 2005
  5. DID YOU KNOW…. When we create a database using “Create Database <database-name>” Database properties are not inherited from Model Database.
  6. Did you know... Error: 29565 SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete
  7. Log Reader Agent Fails when the Sql server instance is failed over to Node 2
  8. Did you know… You will receive “Cannot open the PST because it is in use.” error when you configure SQLMail to use an internet mail server by using Outlook 2003
  9. How to setup a SQL Server Replication between three servers in a typical scenario..
  10. Did you know... Because of Collation settings for the database in SQL Server, you may not be able to navigate through the Database objects in Enterprise Manager
  11. Did you know... The stats can degrade the performance if outdated but how to check when stats gets updated
  12. Did you know… When we rename a domain group in Active Directory, we can have some issues related to the login in SQL Server
  13. Did you know... SQL Server 2000 cluster Resource Fails to come online with error SuperSocket Info: Bind failed on TCP port 5184 reported in errorlog!
  14. Step by Step Procedure to Implement SQL Server Transactional Replication with Oracle as Publisher
  15. SQL Server can perform slow after changing the Cost Threshold for Parallelism
  16. Did you know… The applications like Infopath may fail to submit data into table in SQL Server if the table is included in Merge replication
  17. The subscription fails to Sync with the Publisher and marked inactive even though the settings have been configured to “never expire”
  18. Did you know... Accessing Linked server using Synonym can fail with an error 7359
  19. Facts about How SQL Server 2008 setup works... #3
  20. Some useful tips when working with the Service Broker in SQL Server 2005
  21. Facts about How SQL Server 2008 setup works... #2
  22. Facts about how SQL Server 2008 setup works...
  23. Error 11032 Unable to install Windows Installer MSP while installing security patch KB 948109 on SQL 2005 instance
  24. How to change the keys for the Encryption for an already encrypted database
  25. Upgrade of SQL Server 2000 instance to SQL Server 2005 fails with error similar to "Enforce password policy"
  26. Maintenance Plans with “Backup Database Task” fails when the “Create a sub-directory for each database” option is checked
  27. Error 29527 while installing security patch 948109 on SQL Server 2005
  28. Regeneration of the Master Key fails when we try to take the backup of the Original Database and Restore on other instance of SQL server on other Machine
  29. Unable to Install Security Patch 948109 to SQL Server 2005 Express Edition which is Installed along with ACT7 software
  30. Which Vulnerability security patches needs to be installed for SQL Server 2000 and SQL Server 2005
  31. Security considerations for SQL Server installation on Windows Server 2008
  32. Useful Documents while Troubleshootig Performance issues in the SQL Server 2005
  33. Installation of SQL Server Express Edition on Windows Vista while Installing Microsoft Office Accounting 2008
  34. ERROR 29506 while installing the SP2 on the sql server 2005
  35. How to Change the Dynamic Port of the SQL Server Named Instance to an Static Port in a SQL Server 2005 Cluster
  36. Use of Kerberos Authentication in SQL Server 2005
  37. How to convert a standalone Instance of SQL Server into an Clustered Instance