Viewing 15 posts - 4,141 through 4,155 (of 13,463 total)
similar to A word document, you can set up a template with something that represents the items that would be substituted.
then you need a cursor/loop for each email you plan...
January 16, 2013 at 6:30 am
Koen Verbeeck (1/15/2013)
That's great stuff Lowell, I didn't know you could force the installation of the provider.
Thanks Koen!
I've bean my head against that 64 bit installation rock a few times,...
January 15, 2013 at 2:49 pm
Krasavita (1/15/2013)
Thank you,How you move the table into a separate filegroup?
peek at the code i posted, which creates a new table in the filegroup.
for an existing table, you can Use...
January 15, 2013 at 2:35 pm
I've been in on a few other ACE /EXCEl threads, and have my comments saved from when i thouroughly tested this and got it to work:
myself(Lowell)
install...
January 15, 2013 at 2:29 pm
Want a cool sig is correct. what was produced is valid XML, just not prettified for readability.
SQL2000 used to have trace flag 257, which would format the xml with extra...
January 15, 2013 at 12:32 pm
here's something i put together for a different post that was talking about setting a table to read only:
this is not copy/paste/execute code, but rather, amodel to use to modify...
January 15, 2013 at 11:11 am
ok i'm not sure if this is doing a valid performance test or not;
i had initially thought that creating an object would be slower than regex, but that's not what...
January 15, 2013 at 10:54 am
it depends;
you cannot create an extended property that points to an object(includes the parameters for level0type/@level1type/@level2type) without the object actually existing.
an example:
EXEC sys.sp_addextendedproperty
@name=N'ColumnDescription',
@value=N'Credit...
January 15, 2013 at 8:21 am
cummings.rd (1/14/2013)
January 14, 2013 at 2:35 pm
i'm guessing that the application does not expect an empty database...it expects a database with specific tables, procedures, views etc to exist, but probably many of those objects are allowed...
January 14, 2013 at 2:18 pm
doesn't look quite right to me.
It looks to me like you are missing a relationship between t he two tables.
maybe the PO_Number exists between the two table,s and you need...
January 14, 2013 at 10:46 am
OK here's a starter kit for you in C# for SQL2008.
the usual caveats about downloading strangers code and all that applies, obviously.
don't deploy code you don't fully understand, and only...
January 14, 2013 at 10:37 am
this is the code for the CLR i use; It leverages the the .Net Mail object, which has some pretty expansive, built in rules for handling email addresses.
If you are...
January 14, 2013 at 9:17 am
i've always done a file task to copy an excel to a new file with a name unique to the process, so i was sure my process was the one...
January 11, 2013 at 2:28 pm
maybe he's confusing a virtual page with a server side trace and the possibility of a log file that has no limitations on the size or number of files...
January 11, 2013 at 1:45 pm
Viewing 15 posts - 4,141 through 4,155 (of 13,463 total)