What do you get with this:

select

serverproperty('LicenseType') AS LicenseType ,

serverproperty('NumLicenses') AS NumLicenses

Have you tried running the bcp command by itself from a command prompt? That should give you some error messages if it doesn't work.

I will say I have started reading more books in PDF format now that I found that check mark in the Preferences for Restoring to the last view when reopening...

Thanks, I've heard similar things about SSRS before but was hoping that SQL 2012 made it better. Sounds like they still have a ways to go.

YSLGuru (9/24/2013)

---

Professional Microsoft SQL Server 2012 Reporting Services from WROX publishing (by Paul Turley and several others) is what I ended up getting and so far its been a very...

Koen Verbeeck (9/24/2013)

---

They are just some fun way to indicate how many points you have already gathered.

Some point totals have special statuses that only people who know a lot of...

I'm going the other way. I've been a windows admin for a long time with some DBA duties on the side. Now I'm working on the T-SQL ninja stuff, more...

As a side note, this does get easier in SQL 2012 with OFFSET-FETCH:

http://www.dbadiaries.com/new-t-sql-features-in-sql-server-2012-offset-and-fetch

Print & PDF. While I read a lot of books on my iPad I have yet to read a technical computer book on the iPad... usually because they are too...

You say "I need following output ..." but then you show a query. So what output are you trying to get from querying that data?

The information for that report comes from here:

sp_help_log_shipping_monitor