@Luis Cazares
Your code is faulty. That STUFF is...

Here is a simple stored procedure that will do basically the same thing:
CREATE PROCEDURE [dbo].[spHtmlFromTableEmail]
    @database varchar(100),
    @schema varchar(5)='dbo',
    @table_name varchar(100),
    @columns_list varchar(8000)='ALL',
    @subject varchar(100)='',
    @body...

Simple, I am connecting to the source sever, whatever platform it may be, querying it, or downloading...

I have been using Python 3.* for few years now and I think is the best auxiliary tool for a DBA. You can do anything you need and not only...

And because the whole "trick" is using the dm_exec_describe_first_result_set_for_object function I directly tried it with sp_who and sp_who2 and again, for sp_who2 doesn't work, it returns on empty row with...

This doesn' work:

SELECT

*

INTO #result

FROM

OPENQUERY([LOCALHOST], 'EXEC sys.sp_who;')

select * from #result

Msg 7202, Level 11, State 2, Line 2

Could not...

rcowley 35231 (8/27/2014)

What I can't figure out, is why SQL-B worked when using the GUI, but not when using the command line. (Starting to lose faith in this training...

Do not install them at the same time, if that is what you did. Another thing is that it is possible that running the command line generates the problem. I...

And the answer is easy to find again from that smart guy called "Google". If you search for:

hiper-v guest internet access

you will get

http://superuser.com/questions/469806/windows-8-hyper-v-how-to-give-vm-internet-access

However if you do that it...

From Google search:

http://www.tomshardware.com/faq/id-1954439/mount-bootable-iso-image-windows-installation-windows-server-2012-hyper-virtual-machine.html

http://technet.microsoft.com/en-ca/library/ee340124.aspx

http://social.technet.microsoft.com/wiki/contents/articles/3402.how-to-build-a-sql-server-2012-hyper-v-virtual-machine-kiwi-build.aspx

In VirtualBox you can select a VM from the list (it has to be shut down when you do that and not in a saved state) and then right click...

I was able to install all the servers described in the prep book using the instructions from the book. In my case instead of Hiper-V I used the Oracle VM...

David McKinney (8/2/2013)

Before my post, I did in fact (quickly) read through all the comments...and the month function was mentioned a number of times already. I didn't see any...