Viewing 15 posts - 961 through 975 (of 7,164 total)
Jeff Moden (6/20/2013)
SQL-DBA (6/20/2013)
Jeff Moden (6/19/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 20, 2013 at 3:26 pm
Jeff Moden (6/19/2013)
Why didn't you just use sp_SendDBMail which can take a 2GB VARCHAR(MAX) body with the custom HTML formatting from your article?
Amen. You took the words right out of...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 20, 2013 at 3:23 pm
Voight
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 20, 2013 at 2:53 pm
Heh... read my post. I didn't say you called me any names. Normally it takes some name calling to get a PM like that from someone and I'm just making...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 17, 2013 at 8:58 pm
Ness (6/17/2013)
Roy gave the answer. This is expected behaviour if the login is not granted view definition
Not exactly. Revoke (i.e. not being granted or denied a permission) is different than...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 17, 2013 at 12:27 pm
If all SCCM is doing in inspecting System Views, Catalog Views and DMOs then you may be able to go to something like this:
1. Create a Login for the SCCM...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 17, 2013 at 12:19 pm
Jeff Moden (6/15/2013)
opc.three (6/15/2013)
One good turn deserves another Jeff. You started this one.
Absolute rubbish, Orlando. I've not called you any names nor used the kind of language you've used...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 15, 2013 at 11:01 am
Jeff Moden (6/15/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 15, 2013 at 10:21 am
To augment what Ed mentioned and highlight the .net aspect of your post. There is q class that is part of the .net framework called SqlBulkCopy that is an interface...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 15, 2013 at 8:41 am
One option: use a Script Task to write each resultset to the same file one after the other.
Another option: use a Transformation Script Component to change the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 14, 2013 at 8:33 pm
Jeff Moden (6/13/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 13, 2013 at 8:59 am
Jeff Moden (6/12/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 13, 2013 at 2:29 am
Jeff Moden (6/12/2013)
Ok, Orlando... I'd really be interested in how that bit of fine code could be modified to reject usage of cmd.exe
It cannot. I was only showing that it...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 13, 2013 at 2:27 am
Jeff Moden (6/12/2013)
opc.three (6/12/2013)
In my estimation, and from seeing what developers typically produce and have left behind when left to their own devices when using it, xp_cmdshell guides developers into,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 12, 2013 at 3:38 pm
Reprinting from Simple Talk article CLR Assembly RegEx Functions for SQL Server by Example[/url] by Phil Factor:
Imports System
Imports System.Data.Sql
Imports Microsoft.SqlServer.Server
Imports System.Data.SqlTypes
Imports System.Runtime.InteropServices
Imports System.Text.RegularExpressions
Imports System.Collections 'the IEnumerable interface is here ...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 12, 2013 at 3:10 pm
Viewing 15 posts - 961 through 975 (of 7,164 total)