Viewing 15 posts - 961 through 975 (of 7,168 total)
Jeff Moden (6/20/2013)
SQL-DBA (6/20/2013)
Jeff Moden (6/19/2013)
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...
June 20, 2013 at 3:23 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...
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...
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...
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...
June 15, 2013 at 11:01 am
Jeff Moden (6/15/2013)
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...
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...
June 14, 2013 at 8:33 pm
Jeff Moden (6/13/2013)
June 13, 2013 at 8:59 am
Jeff Moden (6/12/2013)
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...
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,...
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 ...
June 12, 2013 at 3:10 pm
Viewing 15 posts - 961 through 975 (of 7,168 total)