I often work on consulting projects with umpteen clients from across the globe. The nature of the works I usually receive necessitates me to take on the role of a system admin. Now, this role is trailed by come common issues. This article revolves around one such concern. Let us learn about Server Role Member.
SQL SERVER – Introduction to JOINs – Basic of JOINs
The launch of Gandhinagar SQL Server User Group was a tremendous, astonishing success! It was overwhelming to see a large gathering of enthusiasts looking up to me (I was the Key Speaker) eager to enhance their knowledge and participate in some brainstorming discussions. Some members of User Group had requested…
Read MoreSQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)
A couple of days back I had my computer formatted. I reinstalled it with Vista SP1 32bit. Subsequent to installing other indispensable software I tried to install SQL Server 2005 . However, it instantly displayed the following error message. The SQL Server System Configuration Checker cannot be executed due to…
Read MoreSQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions
This post is about a riveting observation I made a few days back. While playing with transactions I came across two DMVs that are associated with Transactions. 1) sys.dm_tran_active_transactions – Returns information about transactions for the instance of SQL Server. 2) sys.dm_tran_current_transaction – Returns a single row that displays the…
Read MoreSQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible
This article revolves around a trivial yet common issue. There might be a set of people for whom the current topic might appear to be insignificant. But I have been asked this question innumerable times, particularly from people who are frequenting using forums or have blog related to storage and…
Read MoreSQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
Note: Download Microsoft SQL Server Management Pack for Operations Manager 2007 by Microsoft The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The availability…
Read MoreSQLAuthority News – Download SQL Server 2005 Report Packs – SQL Server Sample Reports – Report Templates
Note: Download SQL Server 2005 Report Packs by Microsoft SQL Server 2005 Reporting Services is a comprehensive, server-based reporting solution designed to help you author, manage, and deliver both paper-based, ad hoc, and interactive Web-based reports. Each report pack consists of a set of predefined reports, a sample database, a…
Read More
SQL SERVER – Fix Error 9803. Invalid data for type “numeric” – Data Type Mapping
My present article talks about an error that you will encounter when connecting to Oracle database using OPENQUERY. Let us learn about how to fix error 9803.
SQL SERVER – Maximum Columns per Primary Key – Fix : Error : Msg 1904, Level 16, The index on table has column names in index key list. The maximum limit for index or statistics key column list is 16
My present article covers two fundamental questions. 1) What is the maximum number of columns included in Primary Key Index/Constraint? 2) What is fix/solution for the following error: Msg 1904, Level 16, State 1, Line 1 The index ” on table ‘dbo.Table_2’ has 17 column names in index key list.…
Read MoreSQLAuthority News – SQL Server 2008 Service Pack 1 Released – Available for Download
SQL Server 2008 Service Pack 1 (SP1) is now available. You can use these packages to upgrade any SQL Server 2008 edition. Download SQL Server 2008 Service Pack 1 Build of SP1 is SP1 is build 10.00.2531.00. Abstract courtesy : Microsoft Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More