This should've been posted under SQL Server 2012. Can anyone with the authority move the post there please?

Cheers.

Based on the information provided, it looks like all you have to do is to create a connection to Server2 as OLEDB Provider for SQL Server, and then create an...

I am a humanoid too and don't mind reading an odd non-IT-related article, but why would one turn to a technical newsletter for this? Receiving a double-digit number of newsletter titles is expensive...

Having some editorials off topic devalues the site to many IT pros, especially outside the US (and there is a world outside the US!

Many people are confused with this type of triggers (INSTEAD OF). This article is just another example.

The "solution" suggested in the article has a number of deficiencies.

The first was picked...

Dan, what I suggested is NOT what you described in your first post:

---------------

The JobQueue table starts each day empty.  I want to write an ActiveX script in a DTS package...

From my experience, it is much cheaper (in terms of development effort and system resources) to let SQL Agent manage the polling loop. I would create a DTS package implementing...

This is easy to do, see the example below.

1. Createthe stored procedure

CREATE PROOC procFitbitsDotComDotAu @Msg VARCHAR(50) OUTPUT

AS

SET @Msg = 'Fitbits.com.au - Australian SQL Server specialist'

RETURN 123

GO

2. Create DTS package with 2...

Dear admins,

Please do something to improve usability if these forums! I just wasted 20 min typing a detailed answer to this post to find out the post was not saved...

David,

This method is incorrect - SQL Server does not guarantee that the identity values will be assigned in the order given in the ORDER BY clause. According to Itzik Ben-Gan, this...

<<

I need to know how to create a PROCEDURE that will output the mean and standard deviation of a table, which I created with the name Account, and then output...

There was a recent article by Leo Peysakhovich on SQL auditing - you shall be able to find it easily. Also, there was a follow-up discussion with some good ideas...

As we all know - each project has different auditing requirements, and there is no magic solution, I'm afraid. Let's consider just some of the possible requirements:

1. Metadata never changes.

2. Metadata...

This is an excellent article which describes a simple and generic solution to database auditing. The solution is reduced to the essential minimum and therefore is mathematically elegant.

Coincidently, only 2 months ago...

Tonya,

If your ActiveX task sets up file name in the destination connection, it must complete before the data transformation task. The workflow shall be:

(on success of) ActiveX task --> Data...