The number of servers is an ongoing battle. Part of that battle is changing assumptions, many start from the "we need another server" assumption but where we should start...

My first thought is that the prod server isn't really there.. I say that because you did a restore and it remembered the prod server but the current server...

I just hate having to manually set all that up. I use the same base mail config for all servers. That script gets minor tweaks for the from...

Lowell beat me to the SYNONYM point. I prefer to use that, the code never changes and the SYNONYM is defined at the database level given you the ability...

Always is a strong word, so I'm going to say no. Over a long period of time they will probably be close, but any session remaining open when the...

If you add:

EXEC master.dbo.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'UseDatabaseMail', N'REG_DWORD', 1

GO

EXEC master.dbo.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'DatabaseMailProfile', N'REG_SZ', N'DBA'

GO

It will configure SQL Agent as well.

CEWII

I have a script to setup DBMail on my servers, but I still have to do Agent myself, maybe I'll script that too..

USE [msdb]

GO

EXEC dbo.sysmail_add_account_sp

...

siva 20997 (3/1/2012)

---

We have democarcey and rule of Law becuase unfair law is always chalanged. What we are discussing here is to see what is fair and what is not....

You are welcome.

I just hate asking the REALLY simple questions, I don't want people to think I am talking down to them.

And this is a REALLY easy step to miss....

I get the idea of not wanting to spend anymore $$$ than necessary for licensing. You need to keep in mind that it is Microsoft's definitions of multi-plexing and...

I'm gonna ask a stupid question, sorry, but did you configure SQL Agent to USE DBMail?

CEWII

DNS is incapable of port binding.. So as you have specified it it cannot be done.

However, since it isn't a clustered machine you may be able to add 2-3...

The differing schemas is a problem because the pipeline in a data-flow is set at design-time and cannot differ at run time.

You mention that they are different schemas in the...

A type 4 SCD is defined as basically history tables.

Neither the SSIS SCD Wizard or the Kimbal SCD component supports type 4 SCDs.

Is this for a data warehouse?...

I dislike the registry for configurations. It is less visible and my experience has been it is easier to miss when deploying. So perhaps it is more secure...