None, it's just a client tool.

I connect with my 32-bit SSMS (still on Windows XP) to 64-bit servers all the time without issues.

What kind of SQL login did you create?

Windows Authentication? SQL Server Authentication?

Did you enable it?

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1384535-1633-1.aspx

pmercer (11/14/2012)

---

I have tried 2 different ways now and each data row comes out with the exact same data in. It seems to be picking up the all the ...

How did you create the user?

This article explains various methods to concatenate row values:

Concatenating Row Values in Transact-SQL[/url]

Here you go:

http://lmgtfy.com/?q=sql+server+export+to+xml+bcp

Then bcp would be ideal.

Or if you want to complicate things, you could use OLE Automation:

Create File from T-SQL Using OLE Automation[/url]

OLE Automation Stored Procedures

What's wrong with bcp? It's probably the most efficient method to create the XML file.

An alternative is to use SSIS and the export column component in the dataflow.

What are the property values for FailParentOnFailure and FailPackageOnFailure?

In a schedule, you can choose "Start automatically when SQL Server Agent starts" as the schedule type.

You have only 1 row. How are you supposed to find an average that is not 365?

If you have Office 2013 and SQL Server 2012 sp1, you can have PowerView in Excel. (that's where most of the SSRS teams efforts went to, I think)

There's SQL Magazine (focused only on SQL Server) who did have a printed issue, but recently they switched over to e-magazines only.

http://www.sqlmag.com/

What are the errors?