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...

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...

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...

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...

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...

to get a meaningful answer, you need to provide the CREATE TABLE definitions for Invoices and Payments, and the INSERT INTO statements for your data;

i see that you pasted some...

my outside of the box comment:

wouldn't it be better to tune the process that seems slow so that it performs better?

what is that process doing, and does it involve a...

dense_rank, like all the windowing functions like row_number,ntile and rank all start with one, so just add your some number to it to get your starting number

select

dense_rank() over...

there's a codeproject which adds a CDC equivalent to a standard edition SQL server installation you could look at as well:

it creates a utility schema instead of a cdc schema.

http://standardeditioncdc.codeplex.com/

i also remember that if you apply column level permissions to a table for user or group, and leave one of the columns /deny one of them, then select *...

i think there's a couple of factors here:

queries and indexes need to be optimized, and people having permissions to do ad hoc queries when they are not supposed...

if you are getting "client not authenticated" , that means you already have connectivity to the mail server, because it's returning errors.

i think "client not authenticated" could mean one of...

i would go with one app=one database.

it sounds like they have four suites of tables related to a given functionality.

with the current planned design, at some point, you can be...

grant has a great point about owning the code;

if i give you the code, your next questions are going to be "I have images in the database , how...

don't arbitrarily remove an application or code from doing the work for you; that is what they are designed to do.

the code to upload the images/blobs in a programming language(the...