If the data is in SQL and you want it in a csv then that is exporting the data. The wizard will also allow you to save the export...

Have you tried the SQL Server import and Export Wizard? Right-click on the database that holds the data you want to export and click Tasks > Export Data.

declare @xml xml

set @xml='<batch>

<statements>

<StmtSimple id="1"/>

<QueryPlan id="1"/>

<StmtCond id="2"/>

<QueryPlan id="1"/>

<StmtSimple id="4"/>

<StmtSimple id="8"/>

<MissingIndex/>

<StmtSimple id="16"/>

<StmtSimple id="32"/>

<QueryPlan id="2"/>

<StmtSimple id="33"/>

<StmtSimple id="34"/>

<StmtSimple id="64"/>

<StmtSimple...

And how would I check for the existence of the element fun in this example?

Matt Miller (#4) (8/2/2012)

---

One last one - this might help you figure out how to detect...

declare @xml xml

set @xml='<batch>

<statements>

<StmtSimple id="1"/>

<QueryPlan id="1"/>

<StmtCond id="2"/>

<QueryPlan id="1"/>

<StmtSimple id="8"/>

<StmtSimple id="16"/>

<StmtSimple id="32"/>

<StmtSimple id="64"/>

<StmtSimple id="128"/>

</statements>

...

Great, thanks for all the replies. I'll try these out.

Which sites do you use as a reference? I looked at w3schools but they just give really...

I have tried this approach but it only works for simple examples where you already know the order of the elements and they have the same names at the same...

There was no dynamic SQL in the trigger and I didn't re-enable it so it wasn't a problem for me. Do you have any database triggers on your subscriber?

I think I found that my problem was a database trigger that was active on the subscriber. I disabled that and the ANSI PADDING setting was correct thereafter so...

The duration for the audit logout event is the time passed since the login connected:

http://msdn.microsoft.com/en-us/library/ms175827(SQL.90).aspx

The results you see are as expected. Does the result from the stored...

Thanks for the response. That's an interesting way of doing it and I think that would achieve what I'm looking for. My only concern is that I would...

That would involve granting the user direct access on the remote table which I want to avoid. I just want to grant access on the stored proc. Is...

The user wouldn't have access to the other server though. How would that work?

The proc is in the format:

USE [DB1]

GO

CREATE PROC dbo.usp_proc1

AS

SELECT a.[col1], b.[col2] FROM [table1] a

INNER JOIN [Server2].[DB2].[dbo].[table2] b

ON a.[ID] = b.[ID]

GO

Then executing it from Server1 where DB1 is located;

EXEC dbo.usp_proc1

What is...

Yes, if I log in as the user on both servers it works fine and the linked server works. It's only using EXECUTE AS, which is what I think...