Feeds:
Posts
Comments

Archive for April, 2009

SQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on April 12, 2009 | 22 Comments »

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 WMI configuration on the machine [...]

Read Full Post »

SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions

Posted in Pinal Dave, SQL, SQL Authority, SQL DMV, SQL Query, SQL Scripts, SQL Server, SQL System Table, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged on April 11, 2009 | 2 Comments »

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 state information of the transaction [...]

Read Full Post »

SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 10, 2009 | 6 Comments »

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 highly availability, which instigated me [...]

Read Full Post »

SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007

Posted in Database, SQL, SQL Add-On, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, SQLAuthority News, SQLServer, T SQL, Technology on April 10, 2009 | Leave a Comment »

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 and performance monitoring is done [...]

Read Full Post »

SQLAuthority News – Download SQL Server 2005 Report Packs – SQL Server Sample Reports – Report Templates

Posted in Database, SQL, SQL Add-On, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology, tagged , on April 10, 2009 | 1 Comment »

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 readme file, and an End [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers