Basically you need A/A/P/P and it is easy to achieve it .

select

B.key,

A.column

from s22.database.dbo.table A

inner join

customer B on B.column = A.column

Please Try below

select

customer.key,

A.column

from s22.database.dbo.table A

inner join

customer.key on co_customer.column = A.column

Go to your Job and edit the step then in Genaral Tab , go to Execution Option and their is option Use 32 bit runtime , enable this option and...

Can you create same database on other Server with same size (MDF and LDF) and then bring the database offlien and replace the MDF and LDF and see if database...

Yes it is possible with Active/Active/Passive configuration . but you have to consider lot of factors like the Hardware configuration,Memory,disk space ,Network bandwidth so that performnace should not be impacted...

if the length from the string where you have to extract the id is fixed then substring function will works eg substring(yourstring,3,5)

How come both identical databases will be live on production , how do application connect to databases, your statement is little vague , please clearly mention what things you want...

Use the variable to store any dynamic changes like in your case Database , connection string ,table name etc , so you can pass the value at runtime ,...

To restrict the access for database objects(table, SP , View etc) best approach is the create the Database role with minimum permissions you wants for objects and then add your...

Can you check in excel i think the column in Excel was formatted as date. For boolean, Yes or True is 1 and No or False is 0. My guess...

do A1,A2,A3 are table name???

if the structure of tables in both databases is same you can use simple T-SQL command like

insert into A1 Select * from A.dbo.A1.

if you...

Check the field type of these columns in excel and change to text type and try again .

HTH ...

you can't directly see when the particular feild has been changed , to do that u have to create the auditing trigger (DDL) then u can capture what /who/when has...

Lenovo Y550 is pretty good choice