The subscriber server is down? or the replication agent is down?

You can see the SQL Native Client version index under odbcad32 in the drivers tab.

It comes with your installation of SQL. If you want to install it on a separate...

What if you have the license though? But you don't want to install all of the client tools?

If the questions to my above are "Doesn't matter, it breaks the license"...

I think you can get around having to install the SQL client tools. You could run the BCP from the application server direct to the database server as long as...

The topic title suggests you want to know about forecasting database growth, but the content is that you want to know which maintenance to apply.

Do you want to know about...

Nope I have

A) Truncate

B) Insert

C) Update

but I like your advice thankyou

Actually he did NOT state that is the correct way. He gave some sound advice that I am best benchmarking the different options to see what is best! You should...

We have a table - Lets call it "SalesData"

We remove the indexes

We populate this table with data from tables A,B and C

We then add the indexes back on to fields...

Can you explain your reasoning? My way of thinking is that if the process is updating based on joins to other tables, and the relevant fields in the update table...

Good point - but surely better to put the indexes back in before the updates so that SQL can take advantage of the indexes in the main table when joining...

Hmmmm.....it was the network guy. Didn't set the correct permissions. Only had read permissiosn. Begs the question why SQL didn't report "Write permissions denied" rather than "Cannot see"!!!

The idiot has fixed it! @Settings_Profile wasn't being passed in correctly. :crazy:

Thanks for your help people, discussing it opened my eyes!

This is the statement -

SELECT @RunStatus = RUN_STATUS

,@FileFolder = EXTRACT_FOLDER

,@AlertTo = ALERT_TO

,@AlertCC = ALERT_CC

,@StartDate = START_DATE

,@EndDate = END_DATE

FROM dbo.Job_Settings

WHERE PROFILE_DESC = @SettingsProfile

All parameters are mapped and use the...

Do you mean you want to create some variables, populate them from data source, and then use these in the SMTPSendMail task?

If so, which bits do you not know...

Yep that is set. Thanks for trying.