April 2006 - Posts

The previous post requires you to display the properties of a file to be able to "Unblock" the file.

There are 2 (at least) waysI know of. The first is to right click on the file and select properties.

The easier way is to double click on the file while holding down the ALT key.

-
Posted by simonsabin | with no comments

You may have noticed that with Windows XP SP2 files downloaded from the internet are now marked as such. This marks the files as unsafe.

This results in a number of problems.

  1. Compiled help files do not work correctly (the content doesn't display)
  2. .Net projects are treated as unsafe and so imposes restrictions on what can be done.

What I have found today is that zip files whilst treated the same also cause this setting to be propogated to the files extracted from the zip file when the built in "Extract All..." function is used. Once the files are extracted I am not aware of a way of globally marking the files as safe (unblocking them).

To stop this happening make sure you unblock the zip file before extracting the files. In doing this the files will be extracted as unblocked.

To unblock a file display the file properties and click the "Unblock" button.

-
Posted by simonsabin | with no comments

I truly think MS have missed a step with the install of SP1. The install for RTM introduced side by side installations with the promise of simplified patching and reduce down time during upgrades/patches. However SP1 has not delivered on these promises.

It seems that the side by side installation was put into the RTM but no one thought about the first Service Pack. When this came along the work had not been invested in using the side by side installations with the SP.

From Euan's post it appears that the cost of such a process is too high and MS won't even slipstream SP1 with the RTM. I don't take with Euan's argument of SKUs, surely all permutations of service packs are tested, and given the relative short time frame between RTM and SP1 that RTM should be replaced with SP1.

Given the breaking changes in SP1 and the number of fixes it suggests MS feel there aren't enough users using RTM and that SP1 should be the defacto version, in which case a lot of people will have to install RTM and SP1 very time consuming. I know this is going to be a recurring issue over the coming years.

I do hope that

  1. the promises of side by side installations are delivered in SP2
  2. a single installation (even if not slip streamed) is produced for SP1
-
Posted by simonsabin | with no comments

If you already use SSIS and you use date variables do not install service pack 1 without amending your packages

There has been change to the way that dates are stored in packages, it appears it is to do with locales.

Simply put a variable that is defined as 1 march 2006 in a pre SP1 package will be treated as 3 january 2006 in SP1.

The solution is to open your package correct the date and redploy. I suspect this will apply to configuration files and dates being passed in on the command line as well. In this case I believe you need to specifiy your dates in american format (mm/dd/yyyy).

Why dates aren't stored in ANSI format is beyond me anyway :(

I will bring you an update when I get one :)

http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx?FeedbackId=474c85d2-57f9-4219-9037-f2ee34948612

-
Posted by simonsabin | with no comments

Thanks to Andrew for providing this tip to provide a command prompt from any where in explorer.

1.      In explorer, open Tools, Folder Options.

2.      Select the File Types tab.

3.      Go to NONE / Folder.

4.      Press Advanced button.

5.      Select New

6.      In the action block type "Command Prompt from here" without the quotes.

7.      In the app block type "cmd.exe" without the quotes.

8.      Save and exit Folder Options.

Then you can have Command Prompt easily from the given path. You don’t have to navigate by typing long folder names.

-
Posted by simonsabin | with no comments

If you have large table on which you regularly only need to process a subset or perform an aggregation you may have come across indexed views. An indexed view allows you to defined a view just like any other view (almost) and have SQL Server persist the results so that when a query is made using the view, the persisted results can be used rather than combining all the data from the source tables that make up the views query. The intention being that it increases the performance of your code by reducing IO/CPU etc.

The thing that makes indexed views easy to use is that SQL Server maintains the persisted data when the data in the underlying tables is changed, so you don't have to do anything.

To create an indexed view you need to create a schema bound view, this stops the underlying tables from being changed without changing the view. You then create a unique clustered index on the set of columns that define a unique row in the table. if you know anything about an clustered index you know that it defines the how the data for the table is stored in pages in the database. This is the same for the indexed view.

Once the unique clustered index is created you can create what ever other indexes you like on the table.

Now here is the gotcha, with a normal table, if you update a column that is not included in an index the data on the data page is changed and thats it (assuming no page split). However with SQL 2000, if you update ANY column in that is part of an indexed view, even if it is not in the wher clause or the columns of one of the indexes, the engine does a deferred update i.e. a DELETE and then an INSERT.

So whats the impact. Well because of the delete any clustered index on the base table has to be modified, then because the clustered index is updated, ALL non clustered indexes have to be updated. Thats just the base table, the same applies to the indexed view. So imagine this, you have table BaseTableA that has 4 indexes, with column NotUsed. You then have an Indexed View View1 that is based on BaseTableA and includes the NotUsed column and the view that has 3 indexes, none of which include the NotUsed column.

If you update the NotUsed column, it will cause 2 clustered indexes and 5 non-clustered indexes to be modified.  Be warned

The good news is that it has been fixed in SQL 2005 so that updates to a column involved in a non-aggregate indexed view that is not in the clustered index or the where clause does not cause and insert and delete.

You can see the impact by running the script from http://sqlblogcasts.com/files/4/sql_server_engine/entry415.aspx.

-
Posted by simonsabin | with no comments
Filed under:

If you haven't already downloaded SQL Server April BOL then do so. There is a ton of new/updated stuff. The list for SSIS is ~190 new/changed pages/topics

Topic Categories
New Conceptual and Task Topics

Updated Conceptual and Task Topics

Updated Managed Reference Topics

New Conceptual and Task Topics
Building, Deploying, and Debugging Custom Objects

Coding a Custom Log Provider

Creating a Custom Connection Manager

Deprecated Features in SQL Server 2005 Integration Services

Developing a Custom ForEach Enumerator

Developing a User Interface for a Custom Log Provider

Developing Custom Objects for Integration Services

Enumerating Available Packages Programmatically

How to: Implement a Signing Policy Using a Registry Value

How to: Use Data Source Views in Packages

How to: View Packages in the Package Store Using SQL Server Management Studio

Important Differences between Local and Remote Execution

Integration Services Programming Architecture

Loading and Running a Package Programmatically on the Server

Managing Packages and Folders Programmatically

Persisting Custom Objects

Saving a Package Programmatically

Sending an HTML Mail Message with the Script Task

Sending to a Remote Private Message Queue with the Script Task

Using Integration Services with Analysis Services

Using Integration Services with Data Mining

Using Integration Services with Other Applications

Using Integration Services with Other SQL Server Features

Using Integration Services with SQL Server Mobile

Using Integration Services with the Database Engine

Working with Excel Files with the Script Task

 Back to Top

Updated Conceptual and Task Topics
Coding and Testing the Script Component

Coding and Testing the Script Task

Common Properties

Configuring the Integration Services Service

Creating a Custom Task

Creating a Synchronous Transformation with the Script Component

Creating an Asynchronous Transformation with the Script Component

Creating Packages Using the SQL Server Import and Export Wizard

Data Flow Task

DataReader Source

Debugging Script

Derived Column Transformation

Design-time Methods of a Data Flow Component

Destination Custom Properties

Developing a Custom Destination Component

Developing a Custom Source Component

Developing a User Interface for a Custom Task

Extending the Package with Custom Tasks and Objects

File System Task

Flat File Source

Gathering a List for the ForEach Loop with the Script Task

How to: Derive Column Values Using the Derived Column Transformation

How to: Loop through Excel Files and Tables

How to: Run a Package Using a SQL Server Agent Job

How to: Save a Copy of a Package

How to: Set Precedence Constraint Properties in the Properties Window

Integration Services Containers

Integration Services Programming

Interacting with the Package in the Script Component

Loading the Output of a Package

Logging in the Script Task

Lookup Transformation

Maintenance Cleanup Task

Managing Integration Services Packages

Monitoring Performance Counters with the Script Task

Package Configurations

Package Samples

Parsing Non-Standard Text File Formats with the Script Component

Pivot Transformation

Raising Events in the Script Task

Raw File Destination

Send Mail Task

Signing Packages with Certificates

Transfer Database Task

Unpivot Transformation

Using Checkpoints in Packages

Using Connections in the Script Task

Using Data Source Views in Packages

Using Data Sources in Packages

Using Other Assemblies in Scripting Solutions

Using Queries in Packages

Using Variables in Packages

Using Variables in the Script Task

Web Service Task

XML Source

 Back to Top

Updated Managed Reference Topics
Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.ASExecuteDDLTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.ASExecuteDDLTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.DTSProcessingTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.DTSProcessingTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.ManagedConnections.MSMQConn.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.ManagedConnections.MSMQConn.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.ManagedConnections.SMOServerConn.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.ManagedConnections.SMOServerConn.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.ManagedConnections.SMTPConn.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.ManagedConnections.SMTPConn.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.ManagedConnections.WMIConn.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.ManagedConnections.WMIConn.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Pipeline.Design.IDtsComponentUI.Initialize(Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData90,System.IServiceProvider)

Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.DirectRow(System.Int32)

Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSRuntimeComponent90.PerformUpgrade(System.Int32)

Microsoft.SqlServer.Dts.Runtime.Configuration.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.Configuration.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.ConnectionManager.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.ConnectionManager.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.Connections.Add(System.String)

Microsoft.SqlServer.Dts.Runtime.DtsContainer.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.DtsContainer.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachADOEnumerator.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachADOEnumerator.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachSchemaRowsetEnumerator.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachSchemaRowsetEnumerator.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Runtime.Enumerators.SMO.ForEachSMOEnumerator.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Runtime.Enumerators.SMO.ForEachSMOEnumerator.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Runtime.ExtendedProperty.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.ExtendedProperty.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.FlatFileColumn.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.FlatFileColumn.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.ForEachEnumeratorHost.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.ForEachEnumeratorHost.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.ForEachVariableMapping.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.ForEachVariableMapping.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.FtpClientConnection.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.FtpClientConnection.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.HttpClientConnection.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.HttpClientConnection.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Runtime.IDTSPersist.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.IDTSPersist.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.LoggingOptions.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.LoggingOptions.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.LogProvider.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.LogProvider.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.PrecedenceConstraint.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.PrecedenceConstraint.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.Variable.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Runtime.Variable.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)

Microsoft.SqlServer.Dts.Tasks.ActiveXScriptTask.ActiveXScriptTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.ActiveXScriptTask.ActiveXScriptTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.BulkInsertTask.BulkInsertTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.BulkInsertTask.BulkInsertTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.DMQueryTask.DMQueryTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.DMQueryTask.DMQueryTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.ExecuteProcess.ExecuteProcess.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.ExecuteProcess.ExecuteProcess.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.FtpTask.FtpTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.FtpTask.FtpTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.MessageQueueTask.MessageQueueTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.MessageQueueTask.MessageQueueTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.SendMailTask.SendMailTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.SendMailTask.SendMailTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask.TransferDatabaseTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask.TransferDatabaseTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.TransferErrorMessagesTask.TransferErrorMessagesTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.TransferErrorMessagesTask.TransferErrorMessagesTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.TransferJobsTask.TransferJobsTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.TransferJobsTask.TransferJobsTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.TransferLoginsTask.TransferLoginsTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.TransferLoginsTask.TransferLoginsTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask.TransferSqlServerObjectsTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask.TransferSqlServerObjectsTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask.TransferStoredProceduresTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask.TransferStoredProceduresTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.WmiDataReaderTask.WmiDataReaderTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.WmiDataReaderTask.WmiDataReaderTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.WmiEventWatcherTask.WmiEventWatcherTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.WmiEventWatcherTask.WmiEventWatcherTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.XMLTask.XMLTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Tasks.XMLTask.XMLTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)

Microsoft.SqlServer.Dts.Runtime.DtsLogProviderAttribute.LogProviderType

Microsoft.SqlServer.Dts.Runtime.DtsTaskAttribute.TaskType

Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.Location

Microsoft.SqlServer.Dts.Tasks.ExecutePackageTask.ExecutePackageTaskClass.ExecuteOutOfProcess

Microsoft.SqlServer.Dts.Tasks.MessageQueueTask.MessageQueueTask.EncryptionAlgo

Microsoft.SqlServer.Dts.Tasks.MessageQueueTask.MessageQueueTask.UseEncryption

Microsoft.SqlServer.Dts.Runtime.DtsLogProviderAttribute

Microsoft.SqlServer.Dts.Runtime.DtsTaskAttribute

Microsoft.SqlServer.Dts.Runtime.VariableDispenser

Microsoft.SqlServer.Dts.Runtime.Variables

Microsoft.SqlServer.Dts.Tasks.MessageQueueTask.MessageQueueTask

-
Posted by simonsabin | with no comments

A map of the System Views in SQL Server 2005 can be downloaded from ..

http://www.microsoft.com/downloads/details.aspx?FamilyID=2ec9e842-40be-4321-9b56-92fd3860fb32&DisplayLang=en

-
Posted by simonsabin | with no comments

SQL Server 2005 April Books Online is now available. As of posting this the link from the main downloads page takes you to December BOL so you need the following link.

http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en

-
Posted by simonsabin | with no comments

Well not exactly as its been renamed to System Center Operations Manager 2007. There is now a public beta available to sign up for at

https://connect.microsoft.com/availableprograms.aspx?

You will need to register with a microsoft passport if you haven't already done so to be able to use connect.

-
Posted by simonsabin | with no comments
More Posts Next page »