Hello

My DB Mail is set up and I can send emails using the following code:

EXECUTE Msdb..sp_send_dbmail

@recipients = 'someone@hotmail.com',

@subject = 'Test DB Mail',

@body = 'SQL Database Mail...

Sorry I misled you with my...

No this wont solve the problem as I only wanted to copy the table as there are many other tables which I dont need to copy over - I have...

For now - just the once - But I know of other instances when I will want to copy a table from one database to another - Are we summarising...

I want to copy to another database which has a lot more space available (Held on a different hard drive) - and as this is a large table 14gb want...

I tired the Microsoft SQL Server Database Publishing wizard and again as far as I can see this again recreates the table, appends the data then recreates the indexes

Am I...

As far as I can see when the script is generated - The table is recreated as well as the indexes - So this doesn't really benefit me in time...

Hello Rob,

Only just had chance to look at this problem again...I see what you are saying however...

When I say the postcode is my unique address key - I meant I...

Tried BCP and got the same problem...I have checked other forums and have found somewhere where it's supposidly a bug in 2005 - This will get fixed in 2008 -...

I will give BCP a go....But would be useful to have the experts from here confirm that...

If I can help you with the stored procedure then just ask

Bicky;)

I am trying to produce a breakdown of the start months of customers who have a unique mailing address using the field postcode (postcode - is my unique address key)...

Hi Rod

If I was not to aggregate my fields it won't allow me to select them fields as they are not part of my group - How do you suggest...

Fantastic!

Works fine now....Thanks for the fast response and solution