Browse by Tags

All Tags » SQL 2008 (RSS)
[Events] SQLBits - Thursday 19th - Saturday 21st November, Newport, Wales
We are pleased to announce SQLBits goes West , the 5th instalment of SQLBits conferences. We are making it even bigger and better than last time, now spanning 3 days, and still keeping everything that has worked so well at previous events. The event will...
Posted: Oct 28 2009, 05:38 AM by Cliff Hobbs at myITforum.com
Filed under: , , , , , ,
[MS KBs] New KB Articles At Microsoft 14 Oct 2009 - Weekly Summary
.NET Framework 2.0 976111 Introduction to URL rewriting, to URL mapping, and to URL routing in ASP.NET in a .NET Framework environment 976112 Introduction to ASP.NET inline expressions in the .NET Framework Expression Web 957488 MS09-062: Vulnerabilities...
Posted: Oct 14 2009, 12:38 PM by Cliff Hobbs at myITforum.com
Filed under: , , , , , , , , ,
[MS KBs] New KB Articles At Microsoft 23 Sep 2009 - Weekly Summary
Outlook 2007 200197 Outlook 2007: Body of HTML e-mail messages are blank 974370 When you delete a meeting request in Outlook 2007 without responding to the request, there is no message that states that the corresponding calendar item is deleted SQL Server...
Posted: Sep 23 2009, 04:09 PM by Cliff Hobbs at myITforum.com
Filed under: , , , , , ,
[SQL] Error message when you try to batch insert data on a publisher of a merge replication...
Full Title: Error message when you try to batch insert data on a publisher of a merge replication in SQL Server 2008 or SQL Server 2005: "Msg 548, Level 16, State 2, Line 1. The insert failed" Symptoms Consider the following scenario. In SQL...
Posted: Jun 02 2009, 01:33 AM by Cliff Hobbs at myITforum.com
Filed under: , , ,
[SQL 2005] UPDATED: PRB: 'Script table as' reports an error for linked servers created using...
Full Title: PRB: 'Script table as' reports an error for linked servers created using MSDASQL provider in SQL Server 2005 and SQL Server 2008 Symptom Consider the following scenario: You create a linked server from SQL Server 2005 or SQL Server...
Posted: May 23 2009, 08:08 AM by Cliff Hobbs at myITforum.com
Filed under: , , ,
[MS KBs] New KB Articles At Microsoft 19 May 2009 - Weekly Summary
Forefront Security for Exchange Server 971151 An Antigen 9.0 for Exchange or Forefront Security for Exchange Server installation does not configure correctly when the EMC AutoStart application is installed Outlook 2003 971435 Steps to enable Exchange...
Posted: May 20 2009, 06:02 AM by Cliff Hobbs at myITforum.com
Filed under: , , , , , ,
[SQL 2005][SQL 2008] UPDATED: FIX: When you run a query that uses the NOLOCK table hint...
Full Title: FIX: When you run a query that uses the NOLOCK table hint in SQL Server 2005 or in SQL Server 2008 to retrieve BLOB data, the query runs very slowly Symptoms You have a query that uses the NOLOCK table hint in Microsoft SQL Server 2005 or...
Posted: May 19 2009, 02:42 AM by Cliff Hobbs at myITforum.com
Filed under: , , ,
[SQL 2005][SQL 2008] UPDATED: FIX: You obtain incorrect values for a column when you...
Full Title: FIX: You obtain incorrect values for a column when you use the OPENROWSET function to import data from a data file by using an XML format file in SQL Server 2005 or in SQL Server 2008 Symptoms Consider the following scenario. You create an...
Posted: May 19 2009, 02:40 AM by Cliff Hobbs at myITforum.com
Filed under: , , ,
[SQL 2005][SQL 2008] FIX: The SQL Server engine in SQL Server 2005 and in SQL Server...
Full Title: FIX: The SQL Server engine in SQL Server 2005 and in SQL Server 2008 may consume large amounts of memory during the setup configuration phase Symptoms During the setup or patching of a server that is running Microsoft SQL Server 2005 or Microsoft...
Posted: May 19 2009, 02:38 AM by Cliff Hobbs at myITforum.com
Filed under: , , ,
[ConfigMgr] New FAQ Published about SQL Reporting Services and ConfigMgr R2/ V.next
In case you missed the announcement at MMS, one of the features Microsoft announced in V.next is that they are replacing the current ASP-based Reporting feature with SQL Reporting Services (remember that SRS integration is a new feature introduced with...
Posted: May 15 2009, 10:40 AM by Cliff Hobbs at myITforum.com
Filed under: , ,
[MS KBs] New KB Articles At Microsoft 5 May 2009 - Weekly Summary
.NET Framework 2.0 967622 The local credential is audited instead of the remote credential that you enter when you run an application that uses the System.Management namespace to connect to a remote computer 968556 FIX: The XslCompiledTransform.Transform...
Posted: May 06 2009, 09:11 AM by Cliff Hobbs at myITforum.com
Filed under: , , , , , ,
[Event] Understanding ADO.NET Data Services and Windows 7 features in-depth.
Passing this on from my good buddy Tony Rogerson: “Come and join us for the evening of Wednesday the 13th May at TVP Reading where we have Mike Taulty from Microsoft presenting on "Understanding ADO.NET Data Services" and we have James O'Niell...
Posted: May 06 2009, 09:10 AM by Cliff Hobbs at myITforum.com
Filed under: , , , ,
[SQL 2008] KB961073 - FIX: Error message when you run a DML statement in a LINQ to...
Full Title: FIX: Error message when you run a DML statement in a LINQ to SQL application in SQL Server 2008: "The target table '<Table Name>' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT...
Posted: Apr 03 2009, 03:05 AM by Cliff Hobbs at myITforum.com
Filed under: , ,
[MMS] 2009 Early Bird Registration Closes on April 3rd!
Make sure you get in before 3rd April to get your discount... Register by April 3 rd and save over $300! Reserve your place now at the premiere technical event of the year for IT Management Professionals. Register before April 3 rd 2009 and you’ll save...
Posted: Mar 18 2009, 03:41 AM by Cliff Hobbs at myITforum.com
Filed under: , , , , , , , , , , , , , , ,
[SQL] KB 967576 - Microsoft SQL Server Database Engine Input/Output Requirements
SQL Server requires systems to support ‘ guaranteed delivery to stable media ’ as outlined under the Microsoft SQL Server Always-On Storage Solution Review program ( http://www.microsoft.com/sqlserver/2005/en/us/storage-solutions-review.aspx This requirement...
Posted: Feb 09 2009, 06:20 AM by Cliff Hobbs at myITforum.com
Filed under: , , , ,
[SMS 2003]Link to SQL 2005 SP3 added to SMS 2003 SQL Page
Download link to SQL 2005 SP3 added to SQL page [18/12/08] Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS] I've added a link to SQL 2005 SP3 to the SQL Page......( read more ) Read More...
Posted: Dec 18 2008, 04:13 PM by Cliff Hobbs at myITforum.com
Filed under: , , , ,
[MMS] Registration is now Live for MMS 2009…!!
TODAY is the the day – Registration for MMS 2009 is now officially OPEN: http://mms-2009.com/public/registrationoverview.aspx Not sure if I’m going to make it next year (like most folks depends on my employment status and funding)....( read more ) Read...
Posted: Dec 09 2008, 04:03 AM by Cliff Hobbs at myITforum.com
Filed under: , , , , , , , , , ,
[ConfigMgr] New FAQShop Article 12th Nov 08
Useful SQL Information [12/11/08] Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS] I've updated the SQL Page to not only include download locations for all of the SQL Service Packs but also to contain...( read more ) Read More...
Posted: Nov 12 2008, 03:40 AM by Cliff Hobbs, FAQShop.com, myITforum.com and the Windows Management User Group
Filed under: , , , ,
[ConfigMgr] Does ConfigMgr support SQL 2008?
Yes it does but you'll need to apply a hotfix depending on which version of ConfigMgr you're running… [Go to article]...( read more ) Read More...
Posted: Sep 26 2008, 02:45 PM by Cliff Hobbs at myITforum.com
Filed under: , ,
[Events] UK SQL Server UG Meeting – Thursday 28th August
The UK SQL Server User Group are holding their next meeting at Milton Keynes (yey ;-) ), tomorrow night at Unisys close to Junction 14 of the M1. For full details goto: http://sqlserverfaq.com/events/128...( read more ) Read More...
Posted: Aug 27 2008, 02:16 AM by Cliff Hobbs - FAQShop.com, myITforum.com & The Windows Management User Group
Filed under: , , , , ,
More Posts Next page »