Like Joomla is s open source content management system, what are the other type of CMS's... more »

Hi, I have a scenario where there are duplicate records in source itself. In that case SCD (SSIS 2005) inserts all the records in target without updating. Here is the sample scenario: My Source table structure is like ID (Primary Key) , MGR_Id , MGR_NAME , MGR_DOJ Values are : 1 1 XXX .. more »

0x8007000d: The data is invalid. > > Account permissions or security rights are not the issue. > > Cannot View "Hidden Tasks" from the "Advanced" tab of "Control SchedTasks" > "Hidden Tasks" is not available. ..... more »

I am running Vista Ultimate 32 bit and have been unable to check for updates for a few weeks. I get the following message: Windows Update error 80072f8f "If you receive Windows Update error 80072f8f while checking for updates, your computer's date and time might not be the same as the date and time for the online Windows Update service. Your .. more »

This update improves performance, responsiveness, and reliability of Windows Vista in various scenarios. This update resolves the following issues on a Windows Vista-based computer:. You receive a "Stop 0x000000A0" error when you try to ..... more »

All attempts to install update KB943899 results in fail with a error code 800F0816 and forces a repair restart. Anyone else having this problem? Thanks. Mike... more »

how i can make a trigger which is fired before an add of new row in SQL Server 2005... more »

Vista won't Start, Screen Hangs at Flashing Cursor, Hard Drive LED ... By PCDope I have a 10-month old Acer5100Notebook that will no longer start WindowsVista (Home Premium if that matters). A few nights ago I noticed the machine was at ..... more »

Instead, this book offers shortcuts for boosting your productivity, customizations for making Windows Vista work the way you do, workarounds for known Windows Vista problems, and warnings for avoiding Windows Vista pitfalls. ..... more »

submitted by Payton Mann. Having talked about infrastructure and server virtualization quite a bit here, I’m sure you all are familiar with the fact that Nixu Products - DNS, DHCP and IPAM software appliances distributed as ..... more »

MSSQL$SHAREPOINT_; Copy the whole (restored from backup) MSSQL$SHAREPOINT directory to C:\Program Files\Microsoft SQL Server\; Start cmd, and type: net start MSSQL$SHAREPOINT; If you’ve changed name on the server computer, reflect this ..... more »

... how to enable Change Data Capture on a database, and on a table, and how to keep track of Data Definition Language changes on a table. This story continues at http://www.databasejournal.com/features/mssql/article.php/3720361... more »

In the month of February, Microsoft is going to do Hands-On Lab Sessions on Microsoft Windows Vista and Microsoft SQL Server Technologies from 6th-8th and 13th to 15th February 2008 respectively in Delhi. ..... more »

Some updated training material on SQL Server 2008 is now available online. Collection 6187: What's New in Microsoft SQL Server 2008. Clinic 6188: What's New in SQL Server 2008 for Enterprise Data Platform ..... more »

Copy the whole old MSSQL$SHAREPOINT directory to C:\Program Files\Microsoft SQL Server\ 5. net start MSSQL$SHAREPOINT 6. If you’ve changed name on the server, reflect this in the database using Microsoft SQL Management Studio (if you . ..... more »

Error message when you try to remove the System Center Operations Manager 2007 database role: “Error 1324. The folder path ‘Microsoft SQL Server’ contains an invalid character”. 945946 … Event ID 2115 is logged, and a management server ..... more »

The new SQL Server 2008 Learning Portal contains the latest trainings including eBooks and e-Learnings, Instructor-lead Trainings and Certification Exams on SQL Server 2008. Go to this site to be ready for SQL Server 2008 today! ..... more »

Powerpoint files. Part 1:. http://rapidshare.com/files/83313284/Top10CommonMistakesonMSSQLServer_Part1.rar. Part 2:. http://rapidshare.com/files/83313194/Top10CommonMistakesonMSSQLServer_Part2.rar. Thanks to Kevin Kline... more »

Microsoft SQL Server 2005 is a comprehensive, integrated data management and analysis software that enables organizations to reliably manage mission-critical information and confidently run today’s increasingly complex business ..... more »

returns 'Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 6.0 (Build 6000: ) ' on my machine SERVERPROPERTY displays information about ..... more »